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

Categories: Microsoft
Wishlist Share
Share Course
Page Link
Share On Social Media

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