Complete Practical and Real-time Training on Azure Data Engineer. This Job Oriented Course includes: 1. Azure Fundamentals, 2. Azure Active Directory, 3. Azure SQL Databases, 4. Azure Migrations, 5. Azure Data Factory, 6. Azure SQL Pools (Synapse), 7. Azure Synapse Analytics, 8. Azure Storage, 9. Azure Data Lake Storage, 10. Azure Stream Analytics, 11. Azure Databricks, 12. SparkSQL, 13. PySpark, and 14. End to Implementation with a Real-time Project for your resume & job work. This extensive, 100% practical Azure Data Engineer Online Training coures also includes End to End Real-time Project with Power BI Integrations and complete guidance for DP 203 Microsoft Certification Examination. Register Today for a Free Demo
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
Azure Data Engineer |
T-SQL, Azure Data Engineer |
T-SQL, Power BI, Azure Data Engineer |
|
Total Duration | 7 Weeks | 10 Weeks | 14 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 | ✔ | ✔ | ✔ |
DP 203 Certification Guidance | ✔ | ✔ | ✔ |
SQL: Database Basics, T-SQL | ❌ | ✔ | ✔ |
SQL : Constraints, Joins, Queries | ❌ | ✔ | ✔ |
T-SQL : Queries, SProcs, Lock Hints | ❌ | ✔ | ✔ |
SQL: Views, Group By, Self Joins | ❌ | ✔ | ✔ |
Power BI: Report Design, Visuals | ❌ | ❌ | ✔ |
Power BI: Power Query (M Lang), DAX | ❌ | ❌ | ✔ |
Power BI: Report Server, Admin | ❌ | ❌ | ✔ |
Power BI: PL-300 Certification Guidance | ❌ | ❌ | ✔ |
DP 500 [ADE + Power BI] | ❌ | ❌ | ✔ |
Trainer: Mr.Sai Phanindra (17+ Yrs of Exper)
All Session Are Completely Practical & Real Time
SQL Server & T-SQL Schedules | ||||
S No | Time (IST, Mon - Fri) | Start Date | ||
---|---|---|---|---|
1 | 6 AM - 7 AM | June 27th | Register | |
2 | 8 PM - 9 PM | July 12th | Register | |
3 | 9 PM - 10 PM | June 8th | Register | |
4 | 11 PM - 12 AM | June 19th | Register |
Azure Data Engineer Training Schedules | |||
S No | Time (IST, Mon - Fri) | Start Date | |
---|---|---|---|
5 | 1 AM - 2 AM | June 13th | Register |
6 | 7 AM - 8 AM | June 13th | Register |
7 | 7 PM - 8 PM | June 5th | Register |
Power BI Training Schedules | |||
S No | Time (IST, Mon - Fri) | Start Date | |
---|---|---|---|
8 | 8 AM - 9 AM | July 19th | Register |
9 | 8 PM - 9 PM | June 20th | Register |
10 | 12 AM - 1 AM | July 4th | 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: DATABASE INTRODUCTION
|
Ch 5: SQL Basics - 3, T-SQL INTRO
|
Ch 9: Triggers & Transactions
|
Ch 2: SQL SERVER INSTALLATIONS
|
Ch 6 : CONSTRAINTS, INDEXES
|
Ch 10: DB Architecture & Group By
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 7: JOINS & LINKED SERVERS
|
Ch 11: TSQL Queries: Group By, Joins
|
Ch 4: SQL BASICS - 2
|
Ch 8: VIEW, SPs, FUNCTIONS BASICS
|
Ch 12 : ER MODELS, NORMAL FORMS
|
Case Study 1 - For Database, Table Design (Constraints, Keys) |
Case Study 2 - For Query Writing + Window Functions (Rank, RowNumber) |
Mod 1: Azure Data Factory [ADF], Synapse |
Mod 2: Azure Storage & Stream Analytics |
Mod 3: Azure Databricks & SparkSQL |
Chapter 1: Cloud Basics, Azure SQL DB
|
Chapter 1: Azure Storage & Containers
|
Chapter 1: Azure Intro, Azure Databricks
|
Chapter 2: Synapse SQL Pools (DWH)
|
Chapter 2: Azure Migration, BLOB Imports
|
Chapter 2: SQL Notebooks & Python
|
Chapter 3: Azure Data Factory Concepts
|
Chapter 3: Azure Tables, Shares
|
Chapter 3: Python Notebooks
|
Chapter 4: ADF Pipelines, Polybase
|
Chapter 4: Azure Storage Security, Admin
|
Chapter 4: Open Data Sources, DeltaLakes
|
Chapter 5: OnPremise Data with ADF
|
Chapter 5: Azure Monitoring, Power BI
|
Chapter 5: Databricks Security & Jobs
|
Chapter 6: ADF Data Flow - 1
|
Chapter 6: Azure Stream Analytics, IoT
|
Chapter 6: Databricks @ BLOB, Power BI
|
Chapter 7: ADF Data Flow - 2
|
Chapter 7: IoT Hubs & Event Hubs
|
Chapter 7: Databricks Integrations
|
Chapter 8: Azure Synapse Analytics
|
Chapter 8: Azure Stream Analytics Security
|
Real-Time Project
|
Chapter 9: Synapse Analytics with Spark
|
||
Chapter 10: Incremental Loads @ Synapse
|
||
Chapter 11: Optimizations, Power Query
|
||
Chapter 12: Pipeline Monitoring, Security
|
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
|
SQL School Training Institute is at your reach, 24 x 7 for Trainings, Jobs and Placements on SQL Server, SQL DBA, MSBI Trainings. Also include Azure SQL, Azure DBA, Azure BI and Power BI Training Courses. We provide LIVE Online Training, In-house Classroom Training as well as On-demand Video Tranings and Certification Trainings - 24 x 7. All our trainings are completely real-time and 100% practical. We provide Placement and Consulting Services in addition to Project Oriented Trainings. Register Today for Free Demo