Azure SQL Data Warehouse Synapse Analytics Service

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

Audience

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.

Approach

This course is suitable for both beginners and intermediate students, as we will begin with the fundamentals and progress through demos. To help with cloud warehousing, the course also contains a mini crash course on data warehouse basics.

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

Github Repo

https://github.com/PacktPublishing/Azure-SQL-Data-Warehouse-Synapse-Analytics-Service

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.

Course Outline

1. Course Introduction

2. Azure Synapse Analytics [Updated Dec 2020]

3. Data Warehouse Internals and Architecture

4. Data Migration

5. Security layers

6. Configuring and Optimizing

7. Data Warehouse Crash Course