Azure SQL Data Warehouse Synapse Analytics Service

person icon Eshant Garg

Azure SQL Data Warehouse Synapse Analytics Service

Cloud Data Warehouse in Azure Synapse Analytics Service (formerly Azure SQL Data Warehouse). [Covered: DP-200, DP-201]

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Eshant Garg

architecture icon IT & Software,Azure Synapse Analytics


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

Why Azure Synapse Analytics Service  (formerly Azure SQL Data Warehouse)

  • Azure Synapse Analytics truly is a game-changer in Data processing and Analytics.

  • In the most recent study conducted by GigaOm in January 2019 for the TPC-H benchmark report shows that Synapse Analytics is 14 times fast and still 94% cheaper than any other leading service in the market.

  • And that's why clients are shifting to Azure and Azure is growing at nearly twice the rate of Amazon Web Services.

  • According to a 2019 Dice report, there was an 88% year-over-year growth in job postings for data engineers, which was the highest growth rate among all technology jobs.

  • If you are interested in this domain, there cannot be a better time to start learning Azure Synapse Analytics Data Warehouse then now.

Expected Outcomes

In this course

  • You will learn the difference between Traditional vs Modern vs Synapse Data warehouse architecture

  • You will learn why Microsoft Synapse Analytics service is going to be a game-changer in the Data Analytics

  • You will learn how to provision, configure and scale Azure Synapse Analytics service

  • You will learn Cloud Data Warehouse MPP architecture, table types, partitioning, distribution key, and many other important concepts.

  • You will learn different migration techniques and advantage of PolyBase over other techniques with lots of Demos

  • You will learn Security, Configuration, backups, monitoring and other important topics with lots of Demos

  • By the end of this course, you will have a fairly good understanding of Synapse Service and you can directly start working in a Production environment.

  • 100% Syllabus covered for DP200 and DP201 certification exam for Azure Data warehouse (Synapse)

What if I am new in Data Warehouse?

  • I have included a module on Data Warehouse Basics (Crash course to speed up with Cloud warehousing)


What will you learn in this course:

  • Azure SQL Data warehouse

  • Azure Synapse Analytics Service

  • PolyBase

  • Cloud Data Warehouse

  • Microsoft SQL Data Warehouse basics


What are the prerequisites for this course?

  • Basic knowledge of Database and SQL

  • Free Azure Subscription

Azure SQL Data Warehouse Synapse Analytics Service


Check out the detailed breakdown of what’s inside the course

Course Introduction
3 Lectures
  • play icon Why you should buy this course? 03:56 03:56
  • play icon Course Introduction 03:11 03:11
  • play icon Further Study Material
Azure Synapse Analytics
18 Lectures
Data Warehouse Internals and Architecture
10 Lectures
Data Migration
11 Lectures
Security layers
9 Lectures
Configuring and Optimizing
11 Lectures
Data Warehouse Crash Course
12 Lectures

Instructor Details

Eshant Garg

Eshant Garg

Instructor | LearnCloud.Info | AWS | Azure

I love to explain complicated things in a simple and effective way.

I have 16 years of extensive professional experience with expertise in Database and Business Intelligence Solutions, Advanced Analytics, Design and Solution Architect, Reporting, and Cloud Computing Technologies (Azure & AWS).

As a developer and architect, I have 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, I love yoga and meditation. I am a student of the ancient yogic text Bhagavad Gita and love to discuss and practice philosophical teachings.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best



Mari Babu Neti

This course is not included Synapse Server Performance and cost optimization. You simply explained Synapse pricing in Azure portal in Configuring and Optimizing section. Can you please share the tutorial on Synapse Server Performance and Cost Optimization?

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us