Azure SQL Data Warehouse Synapse Analytics - Module 1 (Free)

Cloud Data Warehouse in Azure Synapse Analytics Service (formerly Azure SQL Data Warehouse)
Rating: 4.4 out of 5 (250 ratings)
5,265 students
Azure SQL Data Warehouse Synapse Analytics - Module 1 (Free)
Rating: 4.4 out of 5 (250 ratings)
5,267 students
Azure Synapse Analytics Service Basics
Azure SQL Data Warehouse Architecture
Traditional Data Warehouse Architecture
Modern Data Warehouse Architecture

Requirements

  • Basic T-SQL and Database concepts
  • Azure Free trial Subscription

Description

Important Note:

Please note that this is NOT a full course but a single module of the full-length course, and intended to cover very basic fundamental concepts for absolute beginners.

This module is NOT GOOD for you if:

  • You are already experienced in this technology

  • You are looking for an intermediate or advance concepts

  • You are looking for practical examples or demo

This module is GOOD for you if:

  • You want to understand the basic fundamental concepts of this technology.

This is a free module to help others. If you are not in the intended audience, I request you to please feel free to unenroll.

Where I can find a full-length course?

Please look at the bonus lecture in the end.


What will students learn in this course?

  • Azure SQL Data Warehouse

  • Azure Synapse Analytics Service

[Note]: This is the free version of this course. In case you are interested to learn below synapse topics further, you can look at my profile for the full version of this course.

  • MPP, Types, Partitioning, etc.

  • PolyBase loading techniques

  • Security

  • Configuration

  • Backup and Restore

  • Managing Workloads

  • Monitoring

Level

  • Beginners

Intended Audience

  • Database and BI developers who want to learn how to implement these technologies in Azure Cloud.

  • Anyone who wants to start learning warehousing and Data Engineering in the Azure cloud.

Language

  • English

  • If you are not comfortable in English, please do not take a course, captions are not good enough to understand the course.

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

Target Students

  • Beginners in Azure Platform

  • Data Engineers

  • Data Scientist

  • Database and BI developers

  • Database Administrators

  • Data Analyst or similar profiles

Prerequisites

  • Basic T-SQL and Database concepts

  • Azure Free trial Subscription


Course In Detail


Azure Synapse Analytics Service

  • Why we should consider warehousing solutions in the cloud

  • And then we'll discuss Microsoft's brand new Azure Synapse analytics service, and how this service brings together enterprise data warehousing and Big Data analytics, and provide a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.

  • Advantages of Synapse analytics service over other cloud-based analytics services.

  • We will discuss the difference between Traditional vs Modern vs Synapse Architecture.

  • You will also see Azure Synapse studio which provides a unified experience for all Data Professionals. So, whether you are Data Engineer, Data Scientists, Database administrator, business analysts or any other IT professional, you will find your space in Synapse studio.

  • And then finally in Demo, we'll provision new Azure Synapse Analytics Service, we will see how to pause or resume compute node which is very important, and how to set firewall rules and connect with SQL Server Management studio



[Tags]

Microsoft SQL Server, Azure SQL Server, Azure SQL Data Warehouse, Data Factory, Data Lake, Azure Storage, Azure Synapse Analytics Service, PolyBase, Azure monitoring, Azure Security, Data Warehouse, SSIS

Who this course is for:

  • Beginners in Azure Platform
  • Data Engineers
  • Data Scientist
  • Database and BI developers
  • Database Administrators
  • Data Analyst or similar profiles

Course content

1 section • 12 lectures • 1h 19m total length
  • Is this course good for me? Set expectation
    00:27
  • Introduction
    02:45
  • Why Warehousing in Cloud
    02:48
  • Traditional vs Modern Warehouse architecture
    14:24
  • Azure Synapse a Game changer
    06:48
  • Azure Synapse Benefits
    03:00
  • Modern vs Azure Synapse Architecture
    03:20
  • Demo - Azure Synapse Analytics
    16:10
  • Demo - Azure Synapse Studio
    25:13
  • Synapse unified experience for all Data Professionals
    02:20
  • Summary
    01:53
  • Bonus Lecture
    00:40

Instructor

Azure Data Architect || Author || Adviser
Eshant Garg
  • 4.5 Instructor Rating
  • 3,727 Reviews
  • 29,402 Students
  • 11 Courses

13 years of extensive professional experience with expertise in Microsoft Database and Business Intelligence Solutions, Advanced Analytics, Reporting and Azure cloud computing technologies

CERTIFICATIONS

- DP-200: Implementing an Azure Data Solution
- DP-201: Designing an Azure Data Solution
- Microsoft Certified Technology specialist (MCTS) – SQL Server Database development
- Information Technology Infrastructure Library (ITIL V3) Certified

SPECIALITY

Azure : Data Lake, Data Factory, Synapse Analytics (DW), PolyBase, Stream Analytics & Storage

Big Data Tech : HDInsgiht, Databricks, CosmosDB, Hadoop, Spark, PySpark, Hive, Sqoop

Database versions : Microsoft SQL Server 2005-2016, NoSQL

Languages : T-SQL, USQL, Python, MDX, DAX, PySpark

BI Tools : SSRS, SSIS, SSAS, Power BI


I have been messing around with data for more than a decade now, I love to work on Database internals, performance tuning, and optimization, Database design, modeling, and implementation especially using Microsoft SQL Server and Azure database and analytics technologies.

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. These experiences provided opportunities to see varied implementations, troubleshoot performance-related problems, give guidance on design, and provide consultation on optimization, availability, and recoverability.

I helped in End to End Implementations of many database projects, providing team leadership and project management, requirements gathering, specification documentation, functional/technical design, Data modeling & solution architecture.

Outside of the technical world, I love yoga and meditation. I am a student of ancient yogic text Bhagavad Gita and love to discuss and practice philosophical teachings.