Azure Synapse Analytics Master Course And Cookbook - 2022

This course course covers Azure Synapse Analytics eco-system - Serverless SQL Pool, Dedicated SQL Pool, Spark Pool

What you'll learn
Basic overview of Azure Synapse Analytics Eco-systems. The course is based on multiple modules form Microsoft learning paths.
This course provides fundamental theories and concepts on which Azure Synapse is designed.
Introduces each enrolled students with basics of cloud computing and concepts of different services across.
This course covers 4 basic pillars of Azure Synapse Analytics- Synapse Dedicated SQL Pooll, Synapse Serverless SQL Pool, Data Explorer and Synapse Apache Poo
Learn Deep Practical lab sessions - On how to load data from different sources in Synapse, Create External Tables, CTAS & CETAS, Polybase, Bulk Copy , Spark.
Requirements
Basic computer concepts, data and computers.
Description
Learn deep level data engineering skills in Azure most powerful platform to process terabytes of Big data with power of Cloud computing.Learn Analytics capabilities offered through Azure Synapse SQL through either dedicated SQL pools or serverless SQL poolsGet loaded with SQL scripts and Spark notebooks in Azure Synapse AnalyticsLab sessions to create and manage different synapse services like SQL Pool, Spark Pool and Data Explorer.This course covers Spark SQL scripting and loaded with lab sessions to read files and process data in more efficient way.This course teaches the learners from basics on learning how to ingest and transform data Serverless SQL Pool and Spark PoolThis course covers and teaches how to utilize Synapse analytics services in best and efficient way. Students will learn best practices of implementing data warehouse in Synapse Analytics and Spark Pool. Enrolled students will learn basic steps how to connect data in Synapse as source in Power BI and design reports and dashboards for data analysis and visualization. This course covers  Synapse Pipelines and Triggers in depth and teaches how to create and manage them in synapse workspace.Teaches how to do reporting from the data stored in Cosmos DB using Azure Synapse Analytics.Learn how to Perform operational analytics with near real-time hybrid transactional and analytical processing with Azure Synapse Link.Learn about single Web UI to be able to access all Azure Synapse Analytics capabilities.Learn how to Integrate with a variety of Azure Data Platform technologies in Azure Synapse Analytics and perform data transformations and cleansing.

Overview

Section 1: Introduction to Synapse Analytics and Cloud Computing Fundamentals.

Lecture 1 Introduction to Basic Concepts of Cloud Computing

Lecture 2 Cloud Computing Types and Services

Lecture 3 Introduction to Synapse Analytics

Lecture 4 What is MPP Architecture ?

Section 2: Steps to Create , Configure and Provision Azure Synapse Analytics

Lecture 5 How to Create your Azure Account Free

Lecture 6 Lab- Steps to Create Synapse Analytics in Azure Portal

Lecture 7 Walkthrough of Azure Synapse Workspace

Section 3: Get Started with Synapse SQL Pool

Lecture 8 Lab- Create your first SQL Dedicated Pool from Azure Portal

Lecture 9 Lab- Steps to Create Dedicated SQL Pool from Synapse Studio

Lecture 10 How to Manage Synapse SQL Pool

Lecture 11 Lab - How to Query a file from Synapse SQL Pool

Lecture 12 Distribution in Synapse and Types

Section 4: Get Started with Azure Synapse Spark Pool

Lecture 13 Introduction to Azure Synapse Pool

Lecture 14 Lab- Steps to Create Spark Pool in Synapse Studio

Lecture 15 Lab- Query Data in Synapse Spark Pool & Overview of Spark

Lecture 16 Lab- How to Create Data Frames and Write Spark SQL in Azure Synapse

Aspirants of Azure Data Engineer,Project Managers,Data Analysts,SQL Developers,BI Professionals,Data Architects & Leads,Analytics & BI learners