Azure SQL Data Warehouse Synapse Analytics Service

Preview this course

In terms of data processing and analytics, Azure Synapse Analytics is a game-changer. This course will teach you all you need to know about Azure SQL Data Warehouse, Azure Synapse Analytics Service, PolyBase, Cloud Data Warehouse, and Microsoft SQL Data Warehouse foundations.

Unlimited access to 750+ courses.
Enjoy a Free Trial. Cancel Anytime

- OR -

30-Day Money-Back Guarantee
Full Lifetime Access.
74 on-demand videos & exercises
Level: Beginner 
English
6hrs 28mins
Access on mobile, web and TV

What to know about this course

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

Who's this course 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.

What you'll 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

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

Course Curriculum

About the Author

Eshant Garg

Eshant Garg has 16 years of extensive professional experience with expertise in database and business intelligence solutions, advanced analytics, design and solution architecture, reporting, and cloud computing technologies (Azure and AWS). He loves to explain complicated things in a simple and effective way. As a developer and architect, he has worked closely with customers, users, and colleagues to support business solutions across a variety of industries including healthcare, insurance, finance, and government ranging from small companies to Fortune 500 companies. Outside of the technical world, he loves yoga and meditation. He is a student of the ancient yogic text, the Bhagavad Gita, and loves to discuss and practice philosophical teachings.

40% OFF! Unlimited Access to 750+ Courses. Redeem Now.