Azure SQL Data Warehouse Synapse Analytics Service
Video description
Start your journey with the cloud data warehouse in Azure Synapse Analytics Service
About This Video
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
In Detail
Welcome to Azure Synapse Analytics Service (formerly Azure SQL Data Warehouse). In this course, we will …
Azure SQL Data Warehouse Synapse Analytics Service
Video description
Start your journey with the cloud data warehouse in Azure Synapse Analytics Service
About This Video
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
In Detail
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.
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.
Chapter 2 : Azure Synapse Analytics (Updated Dec 2020)
Introduction
Why Warehousing in Cloud
Traditional Versus Modern Warehouse Architecture
What is Synapse Analytics Service
Demo: Create Dedicated SQL Pool
Demo: Connect Dedicated SQL Pool with SSMS
Demo: Create Azure Synapse Analytics Studio Workspace
Demo: Explore Synapse Studio V2
Demo: Create Dedicated SQL Pool and Spark Pool
Demo: Analyze Data Using Dedicated SQL Pool
Demo: Analyze Data Using Apache Spark Notebook
Demo: Analyze Data Using Serverless SQL Pool
Demo: Data Factory from Synapse Analytics Studio
Demo: Monitor Synapse Studio
Azure Synapse Benefits
Synapse Unified Experience for All Data Professionals
Summary
Chapter 3 : Data Warehouse Internals and Architecture
Introduction
Azure Synapse MPP Architecture
Storage and Sharding Patterns
Data Distribution and Distributing Keys
Data Types and Table Types
Partitioning
Best Practices for Fact and Dimension Tables
Demo - Analyze Data Distribution Before Migration to Azure Synapse
Summary
Chapter 4 : Data Migration
Introduction
Five Best Practices for Data Load
Different Loading Methods
Loading with SSIS Versus PolyBase
Demo - Loading with SSIS
Demo - Loading with PolyBase
Demo Loading with Data Factory
Summary
Assignment - Lab Request
Assignment - Lab Solution
Chapter 5 : Security Layers
Introduction
Advance Data Security
Auditing
Network Security
Transparent Data Encryption
Dynamic Data Masking
Access Management
Summary
Chapter 6 : Configuring and Optimizing
Introduction
Configuration Options
Performing Other Common Tasks
Backup and Restore
Price Optimization
Monitoring
Support and Troubleshooting
Managing Workloads
Delete Resource
Summary
Chapter 7 : Data Warehouse Crash Course
Introduction
What is Data Warehouse
Why We Need Data Warehouse
Ideal Data Warehouse Solution
Responsibility of Data Warehouse Designer
SQL Server (OLTP) Versus Data Warehouse (OLAP)
Dimensional Modelling
Facts and Fact Table
Dimensions and Dimension Table
Star Versus Snowflake
Summary
Start your Free Trial Self paced Go to the Course We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.
This site uses cookies. By continuing to use this website, you agree to their use.I Accept