Welcome to Azure Synapse Analytics Service (formerly Azure SQL Data Warehouse). In this course, we will start with understanding what Azure Synapse Analytics service is and then understand traditional versus modern versus synapse data warehouse architecture. Next, you will learn why Microsoft Synapse Analytics will be a game-changer in the data analytics space and learn how to set up the Azure Synapse Analytics service, customize it, and grow it. Then, you will learn about the cloud data warehouse MPP architecture, table types, partitioning, distribution keys, and a variety of other crucial concepts.
As we progress through the course, you will learn about different migration procedures and the advantages of PolyBase over other ways, as well as security, setup, backups, monitoring, and other important topics through a variety of demos.
By the end of this course, you will have a thorough grasp of Synapse Service and will be able to operate in a production setting right away.
The complete code bundle for this course is available at https://github.com/PacktPublishing/Azure-SQL-Data-Warehouse-Synapse-Ana…
Get introduced to Microsoft Synapse Analytics Service
Differences between traditional, modern, and synapse architecture
Learn about MPP, partitioning, sharding patterns, and distribution keys
Understand what is PolyBase, data migration, and security
Learn about configuration, backups, pricing, monitoring
Learn the fundamentals of Microsoft SQL Data Warehouse
To practice, all that is required is a basic understanding of databases and SQL, as well as a free Azure subscription.