Azure SQL Data Warehouse Synapse Analytics Service

Why Azure Synapse Analytics Service  (formerly Azure SQL Data Warehouse)

• Azure Synapse Analytics truly is a game-changer in Data processing and Analytics.

• The most recent study conducted by GigaOm in January 2019 for the TPC-H benchmark report shows that Synapse Analytics is 14 times faster and still 94% cheaper than any other leading service in the market.

• And that's why clients are shifting to Azure and Azure is growing at nearly twice the rate of Amazon Web Services.

• According to a 2019 Dice report, there was an 88% year-over-year growth in job postings for data engineers, which was the highest growth rate among all technology jobs.

• If you are interested in this domain, there cannot be a better time to start learning about Azure Synapse Analytics Data Warehouse than now.

Expected Outcomes

In this course,

• You will learn the difference between Traditional vs Modern vs Synapse Data warehouse architecture

• You will learn why Microsoft Synapse Analytics service is going to be a game-changer in data analytics.

• You will learn how to provision, configure, and scale the Azure Synapse Analytics service

• You will learn Cloud Data Warehouse MPP architecture, table types, partitioning, distribution keys, and many other important concepts.

• You will learn different migration techniques and the advantages of PolyBase over other techniques with lots of Demos

• You will learn Security, Configuration, backups, monitoring, and other important topics with lots of Demos

• By the end of this course, you will have a fairly good understanding of Synapse Service and you can directly start working in a Production environment.

• 100% of the syllabus covered for DP200 and DP201 certification exam for Azure Data warehouse (Synapse)

What if I am new in Data Warehouse?

• I have included a module on Data Warehouse Basics (Crash course to speed up with Cloud warehousing)