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 |
|
No of Videos | 28 Videos | 40 Videos | 58 Videos |
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] | ❌ | ❌ | ✔ |
Total Course Fee ( Payable in Installments) | INR 25000 USD 350 |
INR 30000 USD 400 |
INR 42000 USD 500 |
Trainer: Mr.Sai Phanindra (17+ Yrs of Exper)
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 |
Video 29: DATABASE INTRODUCTION
|
Video 33: SQL Basics - 3, T-SQL INTRO
|
Video 37: Triggers & Transactions
|
Video 30: SQL SERVER INSTALLATIONS
|
Video 34 : CONSTRAINTS, INDEXES
|
Video 38: DB Architecture & Group By
|
Video 31: SSMS Tool, SQL BASICS - 1
|
Video 35: JOINS & LINKED SERVERS
|
Video 39: TSQL Queries: Group By, Joins
|
Video 32: SQL BASICS - 2
|
Video 36: VIEW, SPs, FUNCTIONS BASICS
|
Video 40: ER MODELS, NORMAL FORMS
|
Case Study 1 - For Database, Table Design (Constraints, Keys) |
Case Study 2 - For Query Writing + Window Functions (Rank, RowNumber) |
Set 1: Azure Data Factory [ADF], Synapse |
Set 2: Azure Storage & Stream Analytics |
Set 3: Azure Databricks & SparkSQL |
Video 1: Cloud Basics, Azure SQL DB
|
Video 13: Azure Storage & Containers
|
Video 21: Azure Intro, Azure Databricks
|
Video 2: Synapse SQL Pools (DWH)
|
Video 14: Azure Migration, BLOB Imports
|
Video 22: SQL Notebooks & Python
|
Video 3: Azure Data Factory Concepts
|
Video 15: Azure Tables, Shares
|
Video 23: Python Notebooks
|
Video 4: ADF Pipelines, Polybase
|
Video 16: Azure Storage Security, Admin
|
Video 24: Open Data Sources, DeltaLakes
|
Video 5: OnPremise Data with ADF
|
Video 17: Azure Monitoring, Power BI
|
Video 25: Databricks Security & Jobs
|
Video 6: ADF Data Flow - 1
|
Video 18: Azure Stream Analytics, IoT
|
Video 26: Databricks @ BLOB, Power BI
|
Video 7: ADF Data Flow - 2
|
Video 19: IoT Hubs & Event Hubs
|
Video 27: Databricks Integrations
|
Video 8: Azure Synapse Analytics
|
Video 20: Azure Stream Analytics Security
|
Real-Time Project
|
Video 9: Synapse Analytics with Spark
|
||
Video 10: Incremental Loads @ Synapse
|
||
Video 11: Optimizations, Power Query
|
||
Video 12: Pipeline Monitoring, Security
|
Set 1: Power BI Report Design |
Set 2: ETL, Data Modeling, DAX |
Set 3: Power BI Cloud, Admin |
Video 41: POWER BI BASICS
|
Video 47 : POWER QUERY LEVEL 1
|
Video 53 : POWER BI CLOUD - 1
|
Video 42: BASIC REPORT DESIGN
|
Video 48 : POWER QUERY LEVEL 2
|
Video 54 : POWER BI CLOUD - 2
|
Video 43 : Visual Sync, Grouping
|
Video 49: POWER QUERY LEVEL 3
|
Video 55 : EXCEL & RLS
|
Video 44: Hierarchies, Filters
|
Video 50 : DAX Functions - Level 1
|
Video 51: Report Server, RDL
|
Video 45 : Bookmarks, Azure, Modeling
|
Video 51 : DAX Functions - Level 2
|
Video 57: MSBI Integrations
|
Video 46 : Visualization Properties
|
Video 52 : DAX FUNCTIONS Level 3
|
Video 58 : REAL-TIME PROJECT
|