This intensive one-day course provides participants with the skills needed to build and manage data analysis solutions using Azure Synapse Analytics. You will learn to work with SQL pools (dedicated and serverless), manage data with Apache Spark in Synapse, and implement ELT (Extract, Load, Transform) processes using Synapse. Pipelines — a familiar experience to those who know Azure Data Factory.
Through hands-on labs and real-world examples, the course provides a solid understanding of data orchestration in modern lakehouse and warehouse environments. Azure.
The course is recommended for:
• Data Engineers who want to integrate and analyze data using Azure Synapse
• Administrators involved in designing and monitoring data flows in cloud
• Professionals using SQL and Python in analytical contexts
• Users familiar with notebooks like Databricks, Jupyter, Zeppelin, etc.
• Teams that have experience with Azure Data Factory and they want to expand it into Synapse
After completing the course, you will know how to:
• Query files from the data lake using serverless SQL pool in Synapse
• Analyze data with Apache Spark Pools and Delta Lake
• Build and manage data pipelines using Synapse Pipelines
• You work with relational data warehouses in Synapse
• Use modern data wrangling and transformation tools in Azure
Participants should have:
• Basic knowledge of SQL and Python
• Experience with Spark-based notebooks (e.g. Databricks, Jupyter)
• Familiarity with services such as Azure Data Factory
1. Introduction to Azure Synapse Analytics
Presentation of the architecture and main components
2. Using serverless SQL pool to query files in the data lake
Running direct queries on JSON, CSV, Parquet files
3. Data analysis with Apache Spark in Azure Synapse
Working with notebooks and manipulating data with PySpark
4. Data Management with Delta Lake in Synapse
Implementing ACID transactions, versioning and time travel
5. Data analysis in relational data warehouse
Creating and querying tables in SQL dedicated pool
6. Building a data pipeline with Synapse Pipelines
Orchestrating ELT tasks with ADF-like tools
