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.

• In the most recent study conducted by GigaOm in January 2019 for the TPC-H benchmark report shows that Synapse Analytics is 14 times fast 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 Azure Synapse Analytics Data Warehouse then 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 the Data Analytics

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

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

• You will learn different migration techniques and advantage 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% 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)