SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.
2024 Training Days
Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.
- 08:00 Registration opens and breakfast served.
- All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
- All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
- No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.
Operations
Master Python in Fabric for Data Engineers
Description
The world of data engineering is changing. Being fluent in T-SQL is not enough anymore. Whether you want to use Jupyter Notebooks to analyse your data or implement a Lakehouse in Microsoft Fabric, Python is the new kid on the block.
In this fullday workshop with lots of exercises you will get up to speed with Python and learn all the tips and tricks you need to know. The following topics will be covered:
- Syntax overview
- Leverage Jupyter Notebooks in Fabric
- Data Wrangling with Pandas
- Select, Group, Filter and Join data
- Big Data with PySpark
- Extract data from SQL Server, CSV files and Parquet files
- Load data into a Lakehouse as Parquet files and Delta Tables
In this fullday workshop with lots of exercises you will get up to speed with Python and learn all the tips and tricks you need to know. The following topics will be covered:
- Syntax overview
- Leverage Jupyter Notebooks in Fabric
- Data Wrangling with Pandas
- Select, Group, Filter and Join data
- Big Data with PySpark
- Extract data from SQL Server, CSV files and Parquet files
- Load data into a Lakehouse as Parquet files and Delta Tables
Learning Objectives
• Master Python, including syntax and debugging.
• Use Jupyter Notebooks in Microsoft Fabric for analysis.
• Perform data wrangling and operations with Pandas.
• Manage big data using PySpark.
• Extract data from SQL Server, CSV, and Parquet.
• Load data into Lakehouse (Parquet, Delta Tables).
• Practice skills with exercises, tips, and tricks.
Previous Experience
Basic knowledge of databases, T-SQL and programming languages.
Tech Covered
Python, Spark, Data Lake, Operations, Fabric