Complete Practical and Real-time Training on Azure Data Engineer. This Job Oriented Certification Course includes : Azure Fundamentals, Azure Active Directory, Azure SQL Databases, Azure Migrations, Azure Azure Data Factory (ADF), Azure Synapse, Azure Databricks (ADB), Azure Cosmos DB, Azure Stream Analytics, Azure Data Lake Storage, Azure Data Lake Analytics, Azure Key Vaults and Azure Data Share. Also includes End to End Real-time Project with Power BI Integrations including Storage Explorer Tool, Data Explorer Tool, Python/R/Scala Notebooks and Big Data Analytics.
This Azure Data Engineer Classroom Training course is applicable for DP 200 and DP 201 Microsoft Certification Examinations.
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
Azure Data Engineer |
T-SQL, Azure Data Engineer |
T-SQL, Power BI, Azure Data Engineer |
|
Total Duration | 6 Weeks | 8 Weeks | 12 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 | ✔ | ✔ | ✔ |
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 | ✔ | ✔ | ✔ |
SQL: Database Basics, T-SQL | ❌ | ✔ | ✔ |
SQL : Constraints, Joins, Queries | ❌ | ✔ | ✔ |
T-SQL : Queries, SProcs, Lock Hints | ❌ | ✔ | ✔ |
SQL: Views, Group By, Self Joins | ❌ | ✔ | ✔ |
Power B: Report Design, Visuals | ❌ | ❌ | ✔ |
Power BI: M Lang, DX for ETL | ❌ | ❌ | ✔ |
Power BI: Report Server, Admin | ❌ | ❌ | ✔ |
Total Course Fee
*
* Payable in Installments |
INR 24,000 USD 325 |
INR 28,000 USD 379 |
INR 36,000 USD 487 |
Trainer: Mr. Sai Phanindra T
All Session Are Completely Practical & Real Time
Schedules for SQL Server & T-SQL | |||
S No | Timings (IST) | Start Date | |
---|---|---|---|
Regular Schedules [Mon - Fri] | |||
1 | 6 AM - 7 AM | Feb 16th | Register |
2 | 8 AM - 9 AM | Feb 9th | Register |
3 | 6 PM - 7 PM | Jan 26th | Register |
4 | 8 PM - 9 PM | Feb 23rd | Register |
5 | 9 PM - 10 PM | Feb 8th | Register |
Azure Data Engineer Training Schedules | ||||
S No | Timings (IST) | Start Date | ||
---|---|---|---|---|
Regular Schedules [Mon - Fri] | ||||
1 | 7 AM - 8 AM | Jan 22nd | Register | |
2 | 7 PM - 8 PM | Feb 1st | Register |
If above schedule does not work, opt for Azure Data Engineer Training Videos
Azure Data Engineer Training Highlights :
✔ Azure Fundamentals | ✔ Azure AD |
✔ Azure SQL Concepts | ✔ Azure Migrations |
✔ Azure AD | ✔ Azure Key Vaults |
✔ Azure Monitor | ✔ Azure Functions |
✔ Azure Data Factory | ✔ Azure Synapse |
✔ Azure Synapse | ✔ Azure Strorage |
✔ Data Lake Storage | ✔ Data Lake Analytics |
✔ Stream Analytics | ✔ IoT, Event Hubs |
✔ Azure Cosmos DB | ✔ Azure Databricks |
✔ Azure Notebooks | ✔ U-SQL & NoSQL |
✔ Python, Scala | ✔ Spark Clusters |
✔✔ End to End Real-time Project @ Resume |
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 |
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 DB 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 wit Synapse, Cosmos Database; Big Data Analytics using Azure Databricks and End User Reporting. Resume Support and DP 200 & DP 201 Certification |
Part 1: Power BI Report Design |
Part 2: ETL, Data Modeling, DAX |
Part 3: Power BI Cloud, Admin |
Ch 1 : POWER BI BASICS
|
Ch 7 : POWER QUERY LEVEL 1
|
Ch 13 : POWER BI CLOUD - 1
|
Ch 2: BASIC REPORT DESIGN
|
Ch 8 : POWER QUERY LEVEL 2
|
Ch 14 : POWER BI CLOUD - 2
|
Ch 3 : Visual Sync, Grouping
|
Ch 9 : POWER QUERY LEVEL 3
|
Ch 15 : EXCEL & RLS
|
Ch 4 : Hierarchies, Filters
|
Ch 10 : DAX Functions - Level 1
|
Ch 16 : Report Server, RDL
|
Ch 5 : Bookmarks, Azure, Modeling
|
Ch 11 : DAX Functions - Level 2
|
Ch 17: MSBI Integrations
|
Ch 6 : Visualization Properties
|
Ch 12 : DAX FUNCTIONS Level 3
|
Ch 18 : REAL-TIME PROJECT
|