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
Homepage

https://www.udemy.com/course/azure-synapse-analytics-master-course-and-cookbook-2022/

Related Downloads :

{related-news}