The Agenda
Agenda HomeSQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.
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