This impeccable Azure Synapse Training course is carefully designed for Microsoft Azure Data Engineers and Architects. This Azure Synapse Training includes basic to advanced Data Warehouse (DWH) and Data Management, Data Analytics concepts. This Azure Synapse Online Training course also includes SQL Warehouse Migrations, Azure Storage, Azure Data Explorer, Synapse Management, Monitoring and Analytics for Azure Data Engineer. This course is also helpful for Azure DP 200, DP 201 Certifications.
Complete practical and realtime Azure Synapse Training course with In-Depth Analytics, DWH Concepts, Azure Data Engineer and DP 200, DP 201 Certification Guidance. Resume Guidance Included.
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
Azure DataFactory & Syanpse |
TSQL Azure DataFactory |
TSQL, Azure Data Engineer |
|
Total Duration | 2 Weeks | 4 Weeks | 8 Weeks |
ADF : Azure Data Factory | ✔ | ✔ | ✔ |
ADF : Data Imports, ETL | ✔ | ✔ | ✔ |
ADF : Data Flows, Wrangling | ✔ | ✔ | ✔ |
ADF : Transformations, ETL | ✔ | ✔ | ✔ |
Synapse: Configuration, Loads | ✔ | ✔ | ✔ |
Synapse: ETL with ADF, DWH | ✔ | ✔ | ✔ |
Synapse: Performance Tuning | ✔ | ✔ | ✔ |
Synapse: MPP, cDWH, DIUs | ✔ | ✔ | ✔ |
SQL: Database Basics, T-SQL | ❌ | ✔ | ✔ |
SQL : Constraints, Joins, Queries | ❌ | ✔ | ✔ |
T-SQL : Queries, SProcs, Lock Hints | ❌ | ✔ | ✔ |
SQL: Views, Group By, Self Joins | ❌ | ✔ | ✔ |
ADB : Azure Data Bricks | ❌ | ❌ | ✔ |
ADB : Architecture, Data Loads | ❌ | ❌ | ✔ |
ADB : Run Spark Jobs, Pools | ❌ | ❌ | ✔ |
ADB : Workspace, Delta Tables | ❌ | ❌ | ✔ |
Cosmos : Configurations | ❌ | ❌ | ✔ |
Cosmos: Distribute Data, ETL | ❌ | ❌ | ✔ |
Cosmos: Integration with ADF | ❌ | ❌ | ✔ |
Cosmos: Structured Streaming | ❌ | ❌ | ✔ |
Total Course Fee * |
INR 10,000 USD 136 |
INR 14,000 USD 190 |
INR 29,000 USD 392 |
If above schedule does not work, opt for Azure Synapse Training Videos
Azure Data Engineer Training Highlights :
✔ Azure Data Factory |
✔ Azure Databricks |
✔ Azure Synapse |
✔ Azure Cosmos DB |
✔ ADF Resources, Monitor |
✔ Power Query in ADF |
✔ Azure Storage Explorer |
✔ Azure Data Explorer |
✔ On-Premise Migrations |
✔ Big Data Storage |
✔ Performance Tuning |
✔ Security Management |
✔ Prepping, Ingestions |
✔ Spark Clusters, Python, Scala |
All Session Are Completely Practical & Real Time
Ch 1: SQL SERVER INTRODUCTION
|
Ch 5: SQL Basics - 3, T-SQL INTRO
|
Ch 9: JOINS, T-SQL QUERIES Level 3
|
Ch 2: SQL SERVER INSTALLATIONS
|
Ch 6 : CONSTRAINTS,INDEXES Basics
|
Ch 10: VIEW, SPs, Function Basics
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 7: JOINS, T-SQL Queries : Level 1
|
Ch 11: Triggers & Transactions
|
Ch 4: SQL BASICS - 2
|
Ch 8: Group By, T-SQL Queries Level 2
|
Ch 12 : ER MODELS, NORMAL FORMS
|
Real-time Case Study - 1
(Sales & Retail)
Objective : Database Design, Table Design and Relations. Involves Purchases, Products, Customers and Time Data with Various Data Types. |
Real-time Case Study - 2
(Sales & Retail)
Objective : Queries, Excel Integration Pivot Tables, Pivot Charts, ODC Connections |
Ch 1: Azure Data Factory, Synapse Intro
|
Ch 6: Incremental Loads with ADF - 1
|
Ch 2: Azure Synapse Architecture
|
Ch 7: Incremental Loads with ADF - 2
|
Ch 3: Azure Data Factory Architecture
|
Ch 8: Mapping Data Flow in ADF
|
Ch 4: Azure Data Lake with ADF
|
Ch 9: Wrangling Data Flow in ADF
|
Ch 5: On-Premise Data to Azure
|
Ch 10: ADF : End to End Implementation
|
1. Azure Fundamentals: What is Cloud? Advantages of Azure Cloud? IaaS, SaaS & PaaS. Azure Data Engineer Technologies, Job Roles. DP 200, 201 Exams Azure Account Registration and Free Trail Activation; Understanding Azure Resources and Resource Types; Creating Resource Groups in Azure Portal; | ||
2. Azure SQL Server: Azure Resources; Resource Groups; Azure SQL Server [Logical Server] Creation; Server Name Format and Firewall Rules; Azure Services Access with Firewall; Test Connections with SSMS Tool and Azure Data Studio Tool; Creating Azure SQL Databases in Portal, T-SQL; Tables, Data Inserts; | ||
3. Azure SQL DB Migrations: Azure SQL DB Migrations from OnPremise; Using Data Migration Assistant Tool; Migration Assessments; Deploy Schema & Migrate Data Options; Onpremise Versus Azure SQL DB Differences; Generating bacpac Files From SSMS Tool; Azure SQL DB Exports & Imports; |
Mod 1: Azure Data Factory, Azure Synapse, Azure Data Share, Azure Key Vaults |
Mod 2: Azure Storage, Azure Data Lake Storage, Azure Data Lake Analytics, U-SQL |
Mod 3: Azure Databricks, Azure Cosmos DB, Azure Stream Analytics, NoSQL |
Ch 1: Azure Data Factory, Synapse Intro
|
Ch 11: Azure Storage Concepts
|
Ch 21: Azure Databricks Configurations
|
Ch 2: Azure Synapse Architecture
|
Ch 12: Azure Tables & Azure BLOB
|
Ch 22: Databricks Notebooks, Spark Jobs
|
Ch 3: Azure Data Factory Architecture
|
Ch 13: Azure Files, Queues & Security
|
Ch 23: Python Notebooks & Operations
|
Ch 4: Azure Data Lake with ADF
|
Ch 14: Azure Monitor, KQL, Power Shell
|
Ch 24: Scala Notebooks, SQL Notebooks
|
Ch 5: On-Premise Data to Azure
|
Ch 15: Azure Stream Analytics, Event Hubs
|
Ch 25: Databricks Jobs & Power BI
|
Ch 6: Incremental Loads with ADF - 1
|
Ch 16: Azure Data Lake Storage (ADLS)
|
Ch 26: Azure Cosmos DB - Architecture
|
Ch 7: Incremental Loads with ADF - 2
|
Ch 17: ADLS Monitoring, Alerts
|
Ch 27: Azure Cosmos DB Queries Level 1
|
Ch 8: Mapping Data Flow in ADF
|
Ch 18: Azure Key Vaults & ADL Analytics
|
Ch 28: Azure Cosmos DB Queries Level 2
|
Ch 9: Wrangling Data Flow in ADF
|
Ch 19: Data Lake Analytics, U-SQL 1
|
Ch 29: Azure Notebooks, Azure Functions
|
Ch 10: ADF : End to End Implementation
|
Ch 20: Data Lake Analytics, U-SQL 2
|
Ch 30: Azure Cosmos Admin, Power BI
|
Real-time Project @ Ecommerce Domain: Includes On-Premise Migrations with bac Files, Azure Storage Compoments, Azure Data Ingestions using Azure Data Factory; Big Data Storage with Azure Synapse and Azure Cosmos Database; Big Data Analytics using Azure Databricks and Azure Stream Analytics. This Real-time Project also includes End User Reporting with Power BI. Additionally includes Resume Support and DP 200, DP 201 Certification Guidance. |