Start your journey with the cloud data warehouse in Azure Synapse Analytics Service
Key Features
- Learn security, configuration, backup, monitoring, and other important topics
- Learn different migration techniques and advantages of PolyBase over other techniques
- Learn with the help of demos and real-world assignments
Book Description
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-Analytics-Service
What you will learn
- 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
Who this book is for
This course is for Azure platform beginners, SQL developers, BI developers, DBAs (database administrators), and anyone interested in learning warehousing and data engineering in the cloud.
To practice, all that is required is a basic understanding of databases and SQL, as well as a free Azure subscription.
