Complete Practical and Real-time Training on Azure Data Engineer. This Job Oriented Course includes basic to advanced Data Engineering activities including ETL (Extract, Transform, Load), DWH (Data Warehouse), Spark, Python for ETL, PySpark, Pipelines with Azure Data Factory and Synapse Analytics, Notebooks with Azure Databricks, Jobs with Azure Stream Analytics and IoT, Security with Azure Key Vaults, IAM, RBAC and more .. !
This course also includes one Real-time Project for your resume & job work including DP-203 Microsoft Certification Guidance.
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 | ❌ | ✔ | ✔ |
TSQL : Constraints, Joins, Queries | ❌ | ✔ | ✔ |
TSQL : Queries, SProcs, Lock Hints | ❌ | ✔ | ✔ |
TSQL : Views, Group By, Self Joins | ❌ | ✔ | ✔ |
TSQL : Excel Analytics, Query Tuning | ❌ | ✔ | ✔ |
Power BI: Report Design, Visuals | ❌ | ❌ | ✔ |
Power BI: Power Query (M Lang), DAX | ❌ | ❌ | ✔ |
Power BI: Report Server, Admin | ❌ | ❌ | ✔ |
Power BI: Dashboards, RLS, Analytics | ❌ | ❌ | ✔ |
Power BI: PL-300 Certification Guidance | ❌ | ❌ | ✔ |
DP 500 Certification Guidance | ❌ | ❌ | ✔ |
Total Course Fee ( Payable in Installments) | INR 25000 USD 350 |
INR 30000 USD 400 |
INR 42000 USD 500 |
SQL Server & T-SQL Schedules | ||||
S No | Time (IST, Mon - Fri) | Start Date | ||
---|---|---|---|---|
1 | 6 AM - 7 AM | Dec 5th | Register | |
2 | 8 AM - 9 AM | Dec 13th | Register | |
3 | 6 PM - 7 PM | Jan 3rd | Register | |
4 | 8 PM - 9 PM | Jan 22nd | Register | |
5 | 9 PM - 10 PM | Dec 19th | Register |
Azure Data Engineer Training Schedules | |||
S No | Time (IST, Mon - Fri) | Start Date | |
---|---|---|---|
6 | 7 AM - 8 AM | Dec 6th | Register |
7 | 11 AM - 12 PM | Dec 13th | Register |
8 | 7 PM - 8 PM | Dec 5th | Register |
Power BI Training Schedules | |||
9 | 8 AM - 9 AM | Jan 3rd | Register |
10 | 6 PM - 7 PM | Dec 11th | Register |
11 | 8 PM - 9 PM | Dec 25th | 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 Notebooks |
✔ 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 |
✔ Python, Scala | ✔ Spark Clusters |
✔✔ End to End Real-time Project @ Resume |
Ch 1: DATABASE INTRODUCTION
|
Ch 5: SQL Basics - 3, TSQL INTRO
|
Ch 9: Functions, Procedures Basics
|
Ch 2: SQL SERVER INSTALLATION
|
Ch 6: Constraints, Index Basics
|
Ch 10: TRIGGERS & TRANSACTIONS
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 7: Joins Basics, TSQL Queries
|
Ch 11: Normal Forms, Cursors
|
Ch 4: SQL BASICS - 2
|
Ch 8: Group By, Views & Excel
|
Ch 12: TSQL Merge, Cursors
|
Case Study 1: Database Design with Tables, Constraints, Keys & Relations |
Case Study 2: Joins with Group By, Sub Queries, Views, Excel Analytics |
Part 1: Azure Data Factory, Synapse Analytics |
Part 2: Data Lake Storage, Stream Analytics |
Part 3: Databricks, Spark, Python |
||
Chapter 1: Cloud Basics, Azure SQL
|
Chapter 1: Azure Fundamentals - Storage
|
Chapter 1: Azure Intro, Azure Databricks
|
||
Chapter 2: Synapse SQL Pools (DWH)
|
Chapter 2: Azure Storage Operations
|
Chapter 2: SparkDatabase, SQL Notebooks
|
||
Chapter 3: Azure Data Factory, Pipelines
|
Chapter 3: Azure Storage Security, ACLs
|
Chapter 3: Python Intro, Data Loads
|
||
Chapter 4: OnPremise Data Loads, Upsert
|
Chapter 4: SQL Database Migrations
|
Chapter 4: PySpark with ADLS
|
||
Chapter 5: File Incremental Loads in ADF
|
Chapter 5: Azure Tables & Replication
|
Chatper 5: PySpark Widgets
|
||
Chapter 6: ADF Data Flow - 1
|
Chapter 6: Azure Stream Analytics, IoT
|
Chapter 6: Architecture, Workflows
|
||
Chapter 7: ADF Data Flow - 2
|
Chapter 7: Azure Event Hubs
|
Chapter 7: Databricks Security, Scala
|
||
Chapter 8: Azure Synapse Analytics
|
Chapter 8: Storage Architecture, Queues
|
Chapter 8: Scala with ADLS, Azure SQL
|
||
Chapter 9: Synapse Analytics with Spark
|
Chapter 9: Monitoring & Key Vaults
|
Chapter 9: DeltaLake Incr Loads, DWH
|
||
Chapter 10: Synapse Security & Parameters
|
Real-time Project (Azure Data Engineer)
|
|||
Chapter 11: Change Data Capture (CDC)
|
Azure Data Engineering with Power BI (For Power BI Registrations)
|
Part 1: Power BI Report Design |
Part 2: Power Query, Cloud (Service) |
Part 3: DAX & Report Server |
Ch 1: POWER BI INTRODUCTION
|
Ch 7: POWER QUERY LEVEL 1
|
Ch 13: DAX Functions - Level 1
|
Ch 2: Basic Report Design
|
Ch 8: POWER QUERY LEVEL 2
|
Ch 14: DAX Functions - Level 2
|
Ch 3: Visual Interaction, Visual Sync
|
Ch 9: POWER QUERY LEVEL 3
|
Ch 15: DAX Functions - Level 3
|
Ch 4: Grouping & Hierarchies
|
Ch 10: POWER BI CLOUD - 1
|
Ch 16: DAX Functions - Level 4
|
Ch 5: Filters & Bookmarks
|
Ch 11: POWER BI CLOUD - 2
|
Ch 17: Power BI Report Server
|
Ch 6: Big Data Access, Visuals
|
Ch 12: POWER BI CLOUD - 3
|
Ch 18: Power BI Admin & AI
|
Power BI : Realtime Project (Sales - Retail) |
||
Phase 1 : Basic Report Design
|
Phase 2 : SME Level
|
Phase 3: Deployments (Cloud, Server)
|
Above course curriculum applicable for registrations from Sep 1st, 2023
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