Course Summary

This course is designed to provide learners with comprehensive instruction on leveraging Azure Synapse Analytics for data processing tasks.

Participants will gain insights into both SQL dedicated and serverless Spark pools, learning to query files in a data lake, analyze data with Apache Spark, utilize Delta Lake, and build data pipelines using Synapse Pipelines.

The course emphasizes data wrangling techniques and the ELT (Extract, Load, Transform) process, akin to Azure Data Factory (ADF), facilitating seamless data movement into the Synapse dedicated pool database.

Key Skills Gained:
• Understanding the fundamentals of Azure Synapse Analytics and its components.

• Utilizing Azure Synapse serverless SQL pool for querying files in a data lake.

• Performing data analysis tasks using Apache Spark in Azure Synapse Analytics.

• Harnessing Delta Lake for efficient data management and storage.

• Analyzing data within a relational data warehouse environment.

• Building robust data pipelines in Azure Synapse Analytics, similar to those in Azure Data Factory (ADF).

Module 1: Introduction to Azure Synapse Analytics

Module 2: Use Azure Synapse serverless SQL pool to query files in a data lake

Module 3: Analyze data with Apache Spark in Azure Synapse Analytics

Module 4: Use Delta Lake in Azure Synapse Analytics

Module 5: Analyze data in a relational data warehouse

Module 6: Build a data pipeline in Azure Synapse Analytics

There are no prerequisites to this course.

Upon successful completion of the course, delegates will receive a certificate of completion, acknowledging their proficiency in the subject matter.

Following your booking, a confirmation message will be sent to all participants, ensuring you're well-informed of your successful enrollment. Calendar placeholders will also be dispatched to assist you in scheduling your commitments around the course. Rest assured, all course materials and access to necessary labs or platforms will be provided no later than one week before the course begins, allowing you ample time to prepare and engage fully with the learning experience ahead.

Our comprehensive training package includes all the necessary materials and resources to facilitate a full learning experience. Enrollees will be provided with detailed course content, encompassing a wide array of topics to ensure a thorough understanding of the subject matter. Additionally, participants will receive a certificate of completion to recognize their dedication and hard work. It's important to note that while the course fee covers all training materials and experiences, the examination fee for certification is not included but can be purchased separately.

Questions About This Course?