Implementing a Data Analytics Solution with Azure Synapse Analytics (DP-3012)

What Will You Learn?

• In this course, you will learn how to:
• Gain comprehensive instruction on SQL dedicated and serverless Spark pools.
• Acquire practical knowledge in data wrangling and the ELT process using Synapse Pipelines
• Learn to efficiently move data into Synapse dedicated pool databases.
• Enhance skills in querying various file formats (CSV, JSON, Parquet) using serverless SQL pools.
• Develop proficiency in analyzing data with Apache Spark within Azure Synapse Analytics.
• Understand the core features and capabilities of Delta Lake and learn to create, use, and query Delta Lake tables.
• Master the design and implementation of a relational data warehouse schema, including loading and querying data using SQL.
• Training Prerequisites
• Familiarity with notebooks using diverse languages and a Spark engine
• Experience with SQL, Python, and Azure tools such as Data Factory