Ch 1: Data Engineer Job Roles

• Introduction to Data
• Data Engineer Job Roles
• Data Engineer Challenges
• Data and Databases Intro

Ch 2: Database Intro & Installations

• Database Types (OLTP, DWH, ..)
• DBMS: Basics
• SQL Server 2025 Installations
• SSMS Tool Installation
• Server Connections, Authentications

Ch 3: SQL Basics V1 (Commands)

• Creating Databases (GUI)
• Creating Tables, Columns (GUI)
• SQL Basics (DDL, DML, etc..)
• Creating Databases, Tables
• Data Inserts (GUI, SQL)
• Basic SELECT Queries

Ch 4: SQL Basics V2 (Commands, Operators)

• DDL: Create, Alter, Drop, Add, modify, etc..
• DML: Insert, Update, Delete, select into, etc..
• DQL: Fetch, Insert… Select, etc..
• SQL Operations: LIKE, BETWEEN, IN, etc..
• Special Operators

Ch 5: Data Types

• Integer Data Types
• Character, MAX Data Types
• Decimal & Money Data Types
• Boolean & Binary Data Types
• Date and Time Data Types
• SQL_Variant Type, Variables

Ch 6: Excel Data Imports

• Data Imports with Excel
• SQL Native Client
• Order By: Asc, Desc
• Order By with WHERE
• TOP & OFFSET
• UNION, UNION ALL

Ch 7: Schemas & Batches

• Schemas: Creation, Usage
• Schemas & Table Grouping
• Real-world Banking Database
• 2 Part, 3 Part & 4 Part Naming
• Batch Concept & “Go” Command

Ch 8: Constraints, Keys & RDBMS – Level 1

• Null, Not Null Constraints
• Unique Key Constraint
• Primary Key Constraint
• Foreign Key & References
• Default Constraint & Usage
• DB Diagrams & ER Models

Ch 9: Normal Forms & RDBMS – Level 2

• Normal Forms: 1 NF, 2 NF
• 3 NF, BCNF and 4 NF
• Adding Keys to Tables
• Cascading Keys
• Self Referencing Keys
• Database Diagrams

Ch 10: Joins & Queries

• Joins: Table Comparisons
• Inner Joins & Matching Data
• Outer Joins: LEFT, RIGHT
• Full Outer Joins & Aliases
• Cross Join & Table Combination
• Joining more than 2 tables

Ch 11: Views & RLS

• Views: Realtime Usage
• Storing SELECT in Views
• DML, SELECT with Views
• RLS: Row Level Security
• WITH CHECK OPTION
• Important System Views

Ch 12: Stored Procedures

• Stored Procedures: Realtime Use
• Parameters Concept with SPs
• Procedures with SELECT
• System Stored Procedures
• Metadata Access with SPs
• SP Recompilations

Ch 13: User Defined Functions

• Using Functions in MSSQL
• Scalar Functions in Real-world
• Inline & Multiline Functions
• Parameterized Queries
• Date & Time Functions
• String Functions & Queries
• Aggregated Functions & Usage

Ch 14: Triggers & Automations

• Need for Triggers in Real-world
• DDL & DML Triggers
• For / After Triggers
• Instead Of Triggers
• Memory Tables with Triggers
• Disabling DMLs & Triggers

Ch 15: Transactions & ACID

• Transaction Concepts in OLTP
• Auto Commit Transaction
• Explicit Transactions
• COMMIT, ROLLBACK
• Checkpoint & Logging
• Lock Hints & Query Blocking
• READPAST, LOCKHINT

Ch 16: CTEs & Tuning

• Common Table Expression
• Creating and Using CTEs
• CTEs, In-Memory Processing
• Using CTEs for DML Operations
• Using CTEs for Tuning
• CTEs: Duplicate Row Deletion

Ch 17: Indexes Basics, Tuning

• Indexes & Tuning
• Clustered Index, Primary Key
• Non Clustered Index & Unique
• Creating Indexes Manually
• Composite Keys, Query Optimizer
• Composite Indexes & Usage

Ch 18: Group By Queries

• Group By, Distinct Keywords
• GROUP BY, HAVING
• Cube( ) and Rollup( )
• Sub Totals & Grand Totals
• Grouping( ) & Usage
• Group By with UNION
• Group By with UNION ALL

Ch 19: Joins with Group By

• Joins with Group By
• 3 Table, 4 Table Joins
• Join Queries with Aliases
• Join Queries & WHERE, Group By
• Joins with Sub Queries
• Query Execution Order

Ch 20: Sub Queries

• Sub Queries Concept
• Sub Queries & Aggregations
• Joins with Sub Queries
• Sub Queries with Aliases
• Sub Queries, Joins, Where
• Correlated Queries

Ch 21: Cursors & Fetch

• Cursors: Realtime Usage
• Local & Global Cursors
• Scroll & Forward Only Cursors
• Static & Dynamic Cursors
• Fetch, Absolute Cursors

Ch 22: Window Functions, CASE

• IIF Function and Usage
• CASE Statement Usage
• Window Functions (Rank)
• Row_Number( )
• Rank( ), DenseRank( )
• Partition By & Order By

Ch 23: Merge(Upsert) & CASE, IIF

• Merge Statement
• Upsert Operations with Merge
• Matched and Not Matched
• IIF & CASE Statements
• Merge Statement inside SPs
• Merge with OLTP & DWH

Ch 1. Azure Fundamentals

• Basics of Cloud Computing
• Cloud Services: Advantages
• Cloud Services: Product Models
• Virtualization Concepts in Cloud
• Comparing On-Premise with Cloud
• DevOps : Introduction, Use
• Azure Cloud : Features, Advantages
• Azure Cloud : Services & Usage
• Azure Cloud : Platform Components
• Azure Resources, Service Types
• Azure PaaS, IaaS & SaaS
• Azure Account Creation, Resources

Ch 2. Azure Services, Configurations

• Azure Registration and Azure Portal
• Azure Resources, Azure Services
• Azure Resource Groups
• Cost and Billing Management
• Azure Storage Account Creation
• Storage Account Types, Replication
• Azure BLOB Data Storage Containers
• Azure Storage Explorer Tool
• Uploads, Imports, SAS and Access Key
• Azure File Storage and On-Premise Access

Ch 3. Azure Active Directory, Monitoring

• Azure Active Directory Service
• Azure AD : Users, Tokens & Passwords
• Azure AD : Groups, Members, Owners
• Azure AD : App Registrations, Tokens
• Service Principals and Real-time Use
• Identity & Access Management (IAM)
• Azure Monitoring and Metrics
• Azure Dashboards and Counters
• Customizations and Usage Reports
• Azure Alerts and Conditions
• Notifications: Push/Email/SMS
• Log Analytics and Health Checks

Ch 4. SDLC, Dev & Operations, DevOps

• Software Development Life Cycle
• SRS Documents and Principles
• Design, Planning and Coding
• Coding Techniques and Tools
• Testing Operations, Issues
• UAT, Production Deployment Issues
• Need for DevOps Services
• Life Cycle Management
• Automations and Code Control
• DevOps Tools and Techniques
• DevOps : Advantages, Benefits
• DevOps Engineers: Job Roles

Ch 5. DevOps Tools, Git & GitHub

• Continuous Development (CD)
• Continuous Integration (CI)
• Planning Phase: UML Tools
• Code: Visual Studio, Git
• Build: Maveen and Gradle
• Test: Selenium and Junit
• Release: Jenkin, Bamboo
• Deploy: Puppet, Chef, Ansible
• Operate: Visual Studio Options
• Monitor: NewRelic, Splunk
• Git & GitHub For Code Store

Ch 6. Docker, Kubernetes

• Introduction to Docker
• ACI Containers and Options
• Introduction to Kubernetes in Azure
• Kubernetes Lifecycle Implementation
• Azure Kubernetes Containers, Options
• Azure DevOps: Services
• Azure Boards, Azure Repos
• Azure Pipelines and Realtime Use
• Azure Test Plans and Artifacts

Ch 7: Organizations & Projects

• Azure DevOps: Implementation Plan
• Creating and Using Organizations
• Planning and Security Advantages
• Region Specifications and Owners
• Users and Resource Limits
• Azure DevOps – Org Notifications
• Azure Projects – Creation, Use
• Public and Private Projects
• Version Control: Git and TFS
• Work Item Process: Agile
• Basic, CMM and Scrum Options
• Security, Teams, Dashboards

Ch 8: Azure Boards

• Azure Boards – Creation, Use
• Work Item – Fields & Sprint
• Kanban Boards, Item Tracking
• Backlogs and Code Testing
• Team Dashboards, Monitoring
• Azure Boards with Agile Process
• Azure Boards For CMMI Process
• Azure Boards For Scrum Process
• Style Rules and Highlight Cards
• Color Tag & Work Item Cards

Ch 9: Azure Repos

• Azure Repository (Repo), Storage
• Distributed Versus Centralized
• Azure DevOps Repos: Cloning
• Commit, Push and Pull Options
• Branch & Branch Policies
• Fork, Git and WorkFlow
• Git Versus TFVC, Customizations
• Public Projects and Pull Requests
• Team Foundation Version Control
• Git and TFS Projects in DevOps

Ch 10: Azure Pipelines For CI/CD – 1

• Azure Pipelines – Architecture, Creation
• Azure Pipeline Creation Ecosystem
• Continuous Integration (CI)
• Continuous Development (CD)
• Build Pipeline in Azure DevOps
• Key Concepts, Real-time Use
• Creating Pull and Push Requests
• Release Pipelines – Creation
• Multi Stage Release Pipelines
• New Branch Options with Pipelines
• Classic Release Pipelines;
• Classic Editor – Pipeline Creation

Ch 11: Azure Pipelines For CI/CD – 2

• Continuous Integration Pipelines
• Redeployments in Azure DevOps
• WorkTeam Correlation Options
• GitHub with Azure Active Directory
• Github with DevOps Integration
• Azure Pipelines for YAML
• Agent, Approvals and Artifacts
• Caching, Conditions and Jobs
• Classic Builds and Class Release
• Dependencies, Job Deployments

Ch 12: Azure Testing & Artefacts

• Azure Testing Options in DevOps
• Manual Testing in Kanban
• Manual Testing in Test Manager
• UAT and Test Tracking
• Stakeholder Feedback
• Azure Artifacts and Feeds
• Single Feeds & Multi Feeds
• Nuget, npm, Maven with DevOps
• Versions and Compatibility
• Retention Policies with Artifacts
• Maven Central Upstream Sources

Ch 13: Azure Functions, App Service, Alerts

• Azure Functions and Automations
• Azure Event Notifications, Audits
• Azure App Services & Webapps
• Build, Deployment and Scaling
• Azure App Service Migrations
• Azure Apps Versus DevOps
• Azure Monitoring and Alerts
• Notification Options in Azure
• Alert Management, Operators
• Creating, Managing Alert Rules
• RBAC , Continuous Monitoring
• Smart Groups and Performance

Ch 14: Azure DevOps Resources in Portal

• Azure DevOps Services From Portal
• Application Insights and Logs, API
• Log Analytics and Storage Account
• Azure DevOps Organizations;
• DevTest Labs From Azure Portal
• Build Apps with Azure DevOps
• Azure Pipelines and Samples
• Plan and Build Tasks in DevOps
• Setup Azure DevOps Org Account
• Create & Publish Azure Pipelines

Ch 15: Azure DevOps Starter, App Insights

• Azure DevOps Starter Deployments
• Migrations from Git Repository
• Continuous Integration (CI)
• Continuous Delivery (CD)
• Item Pipeline and Workflow
• Azure DevOps Pipelines
• DevOps Starter, Github Integration
• Azure DevOps to Azure VM

Ch 16: Power Shell & Azure DevOps

• Power Shell in Azure Portal
• Creating Resources in Portal
• Creating Pipelines in PowerShell
• YAML Snippet and Arguments
• Writing Sample Apps, Builds
• Writing Warnings and Errors
• Powershell with Multiple Args
• Service Fabric Manifests
• Publish Test Results in DevOps
• Run Functional Test Results

Ch 17: DevOps Server – Configurations

• Azure DevOps Server – Advantages
• On-Premise Configurations for Server
• Code Share, Track Work and Shipping
• Azure DevOps Server – Installation
• Criterion for Azure DevOps Server
• SQL Server Installation for DevOps
• Services and Service Account, Agent

Ch 18: DevOps Server & Visual Tools

• Privacy Advantages with DevOps Server
• XML Definition Files and Options
• Build Server Configurations
• Content Version and Projects
• General Administration Tasks
• Server Level Administration Tasks
• Grant and Restrict Permissions
• Area and Iteration Paths
• Adding Teams and Scaling
• Billing Items & Monitoring

Ch 19: DevOps with SSMS, AI

• SSMS Tool with GIT
• SSMS with DevOps Integration
• AI Integrations
• Microsoft Copilot with AI
• AZ400 Exam Guidance (Certification)

Ch 1: Power BI Intro, Installation

• Power BI & Data Analysis
• 5 Design Tools, 3 Techniques
• 2 Hosting Solutions
• Power BI with Co-Pilot & AI
• Power BI Installation

Ch 2: Report Design Concepts

• Basic Report Design (PBIX)
• Get Data, Canvas (Design)
• Data View, Data Models
• Data Points, Spotlight
• Focus Mode, PDF Exports

Ch 3: Visual Interactions, PBIT

• Visual Interactions & Edits
• Limitations with Visual Edits
• Creating Power BI Templates
• CSV Exports & PBIT Imports

Ch 4: Grouping, Hierarchies

• Creating Groups : Lists
• Creating Groups: Bins
• List Items & Group Edits
• Bin Size & Bin Count

Ch 5: Slicer & Visual Sync

• Slicer Visual in Power BI
• Slicer: Format Options
• Single Select, Multi Select
• Slicer: Select All On / Off
• Visual Sync with Slicers

Ch 6: Hierarchies & Drill-Down

• Hierarchies: Creation, Use
• Hierarchies: Advantages
• Drill Up, Drill Down
• Conditional Drill Down
• Filtered Drill Down, Table View

Ch 7: Filters & Drill Thru

• Power BI Filters
• Basic, Top & Advanced
• Visual Filters, Page Filters
• Report Level Filters, Clear Filter
• Drill Thru Filters & Usage

Ch 8: Bookmarks, Buttons

• Power BI Bookmarks
• Images: Actions, Bookmarks
• Buttons: Actions, Bookmarks
• Page to Page NavigationsScore Cards, Master Pages

Ch 9: SQL DB Access & Big Data

• SQL DB Access, Queries
• Storage Modes: Direct Query
• Formatting & Date Time
• Storage Modes in Power BI
• Azure (Big Data) Access & Formatting

Ch 10: Power BI Visualizations

• Charts, Bars, Lines, Area
• TreeMaps & HeatMaps
• Funnel, Card, Multrow Card
• PieCharts & Waterfall
• Scatter Chart, Play Axis
• Infographics, Classifications

Ch 11: Power Query Introduction

• Power Query (Mashup)
• ETL Transformations in PBI
• Power Query Expressions
• Table Combine Options
• Merge, Union All Options
• Close, Apply & Visualize

Ch 12: Power Query : Table Tfns

• Table Duplicate, Header Promotion
• Group By Transformation
• Aggregate, Pivot Operation
• Reverse Rows, Count Rows
• Advanced Power Query Mode

Ch 13: Power Query: Column Tfn

• Any Column Transformations
• Data Type Detection, Change
• Rename, Replace, Move
• Fill Up, Fil Down
• Step Edits & Rollbacks

Ch 14: Power Query: Text, Date

• String / Text Transformations
• Split, Merge, Extract, Format
• Numeric and Date Time
• Add Column & Expressions
• Expressions and New Columns
• Column From Examples

Ch 15: Power Query: Parameters

• Parameters in Power Query
• Static Parameters, Defaults
• Dynamic Dropdowns, Lists
• Linking with Table Queries
• Step Edits, Type Conversions

Ch 16: Power BI Cloud: Publish

• Power BI Cloud Concepts
• Workspace Creation, Usage
• Report Publish Cloud
• Report Edits in Cloud
• Semantic Models & Usage

Ch 17: Power BI Cloud Dashboards

• Power BI Dashboards
• Dashboard Creation, Usage
• Pin Visuals, Pin LIVE Pages
• Add Image, Video Tiles
• Q&A & Pin Tiles

Ch 18: Power BI Cloud Operations

• Report Shares, Alerts
• Subscriptions, Exploration
• Downloads & Edits
• Report Cloning in Cloud
• QR Codes, Web Publish
• Lineage & Metrics

Ch 19: Power BI Cloud Gateways

• Data Gateways, Data Refresh
• Install, Configure Gateways
• Data Sources Configurations
• Data Refresh & Scheduling
• Gateway Optimizations

Ch 20: Power BI Cloud Apps

• Power BI Apps: Creation
• App Sections & Content
• Audience Options
• App Security & Sharing
• App Updates, Favourites
• App URL, End User Access

Ch 21: Power BI Report Server

• SQL Server 2025 (Mandatory Installations)
• Power BI Report Server
• Report Server Vs Cloud
• Installation, Configuration
• RS Config Tool Options
• Report Database, TempDB
• Web Service & Server URL

Ch 22: Paginated Reports

• Report Builder Tool
• Paginated Report (RDL)
• Report Expressions (RDL)
• Tablix, Chart Wizards
• Fields & Drill-Down
• RDL Report Publish

Ch 23: DAX Concepts (Basics)

• DAX Concepts: Intro & Realtime Need
• DAX Columns: Creation, Use
• DAX Measures: Creation, Use
• DAX Functions: IIF, ISBLANK
• SUM, CALCULATE Functions
• DAX Cheat Sheet

Ch 24: DAX Quick Measures

• Quick Measures in Power BI
• Average & Filters
• Running Totals
• Star Rating Calculations
• DAX Measures in Data View
• DAX in Visuals
• DAX in Cloud Reports

Ch 25: Data Modelling, DAX

• Dimensions Tables
• Fact Tables & DAX Measures
• Data Models & Relations
• DAX Expressions
• Star & Snowflake Schemas
• DAX Joins & Expressions

Ch 26: DAX Joins, Variables

• CALCULATEX & Variables
• COUNT, COUNTA, etc..
• SUM, SUMX, etc..
• SELECTED MEMEBER
• Filter Context, RETRUN
• Dynamic Report with DAX

Ch 27: DAX Time Intelligence

• Need for Time Intelligence
• Date Table Generation
• Time Intelligence with DAX
• PARALLELPERIOD, DATE
• CALENDAR, Total Functions
• YTD, QTD, MTD with DAX

Ch 28: DAX – Row Level Security

• RLS: Row Level Security
• Data Modelling & Roles
• Verify Roles (Testing)
• Add Cloud Users to Roles
• Dynamic Row Level Security
• Testing RLS in Power BI

Ch 29: Analytical Reports

• Analytical Report Concepts
• Excel Data Analytics
• Excel with Power BI Cloud
• SQL, AVRO, JSON Sources
• Analyse in Excel (Cloud)
• Excel Reports to Cloud

Ch 30: Power BI AI, CoPilot

• AI Components in Power BI
•  CoPilot Practical Uses
• CoPilot with Desktop
•  CoPilot with Cloud
• Need for AI Analytics (Fabric)
• PL 300 Exam (Microsoft Certified Data Analyst) Guidance
• PL 300 Exam Mocks

Realtime Project 1 (ECommerce / Financial Analysis)

Realtime Project 2 (Health Care / Banking)