Ch 1: SQL Database Job Roles

• Introduction to Data
• Database Job Roles
• SQL Job Roles
• SQL Developer Jobs
• Data Engineer Jobs
• Data Analyst Jobs

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 24: Key Take-Aways from Module 1

• Case Study 1: Medicare: Tasks, Solutions
• Case Study 2: ECommerce: Task, Solutions
• Chapter Wise Assignments: Solutions
• Dailly Assignments: Review (Feedback)

Ch 25: Variables & Try..Catch

• Variables: Declaration & Usage
• Assigning Values to Variables
• SELECT & SET Operations
• Using Variables in SPs
• Variables Versus Parameters
• . Catch Block with Variables
• THROW Statement, Error Handling

Ch 26: Updatable Views

• Using Triggers with Views
• Updatable Views, DML
• Views & Stored Procedures
• Data Distributions in Tables
• Transactions with Procedures
• Conditional Commits in SPs
• Rollback Options in Realtime

Ch 27: Stored Procedures & TVPs

• Using TVP with Procedures
• Creating User Defined Types
• Big Data Copy & Transactions
• Using SPs & Table Variables
• Transactional Integrity with SPs
• Conditional Commits, Rollbacks
• Procedure Recompilations

Ch 28: Stored Procedures, Cursors

• Cursors Types: Local, Global
• Using Procedues with Cursors
• Formatting Queries, Nvarchar
• WHILE Loop: @Fetch Status
• Variables with Dynamic SQL
• sp_executesql Extended SP
• Dynamic SQL Programming

Ch 29: SPs & Recursive CTEs

• CTEs: Common Table Expression
• CTEs For DML Operations
• Defining Recursive CTEs
• Anchor Element: Realtime Use
• Termination Checks and Loops
• Defining SPs with CTEs
• Cautions with Recursive CTEs

Ch 30: Functions & Loops

• Inline, Table Line Functions
• Multi Line Table Functions
• Using LOOPs in Functions
• Variables & Return Values
• Table Generation Logic
• Date & Time Data Types
• Calendar Data Generations

Ch 31: OpenRowSet, Debugging

• Reading JSON Data
• Using OPENROWSET( )
• OpenRowSet with Variables
• Debugging Stored Procedures
• Debugging Types in TSQL
• Debugging Techniques with SSMS
• Debug Options with Variables

Ch 32: PIVOT, UNPIVOT

• Reading Denormalized Data
• Normalizing Table Data
• PIVOT Operation with TSQL
• PIVOT with Aggregates
• FOR and IN Operators
• UNPIVOT with TSQL
• PIVOT with Functions, SPs

Ch 33: Temporary Tables

• TempDB: Realtime Use
• Local Temporary Tables
• Global Temporary Tables
• Testing & Using Temp Tables
• Temp Tables across Sessions
• Auto CreateTables using Select
• SELECT .. INTO & Bulk Loads

Ch 34: Synonyms & Realtime Use

• Synonyms: Creation, Use
• Creating Synonyms For Tables
• Synonyms for Schemas, Tables
• Synonyms: DB, Schemas, Tables
• Remote DB Access with Synonyms
• Listing & Varying Synonyms
• Synonyms Versus Aliases

Ch 35: Server Architecture

• Database Engine Components
• Parser, Compiler & Optimizer
• Protocols and Query Processing
• MDAC and CLR Components
• Parsing and Compilation
• Memory Manager & IO Managers
• SQL OS Components, MDAC

Ch 36: DB Architecture (VLDB)

• Planning Large Databases
• Primary, Secondary Data Files
• Filegroups, Spacing and Sizing
• Log File: Usage and Precautions
• Creating Tables with Filegroups
• Pages and Extents for Storage
• VLF, MiniLSN & Checkpoint

Ch 37: Tuning: Audits, AM Tool

• Activity Monitor Tool
• Perfmon Tool & Counters
• Query Audits: DMVs, DMFs
• Plan Handle, Execution Time
• Long Running Queries
• Query Store & Buffer Cache
• Data Flush, Stats Collection

Ch 38: Tuning : Indexes

• Indexes : Sort Locations
• Clustered & Online Indexes
• Non Clustered, Column Store
• Included Indexes in Realtime
• Filtered Indexes & Usage
• Covering Index & Selectivity
• Indexed Views (Materialized)

Ch 39: Tuning: Partitions

• Partitions: Performance Tuning
• Partition Functions & Schemes
• Partition Un-partitioned Tables
• Compressions: ROW, PAGE
• Auditing Partitions
• Partitions Limitations in OLTP
• Partitions with DWH

Ch 40: Statistics & Tuning

• Statistics: Realtime Usage
• Index & Column Statistics
• Statistics & Key Purpose
• Verifying, Using Stats
• Statistics Versus Indexes
• Stats Updates on Tables
• Stats Updates on Views

Ch 41: Index Management

• Index Management Options
• Index Rebuilds, Re-Organize
• Database Maintenance Plans
• Page Count and Index Conditions
• Degree Of Parallelism Settings
• Resumable & Online Indexes
• PAUSE, RESUME in Rebuilds

Ch 42: Tuning Tools

• Tuning Tools: Workload Files
• Profiler Tuning, Events
• DTA, Profiler Options
• Physical Design Structures
• PDS Recommendations
• Query Execution Cache
• Tuning Tools: Precautions

Ch 43: Execution Plans

• Execution Plan Analysis
• IO Cost and CPU Cost
• SubTree & Operator Cost
• NUMA Nodes, Processor Affinity
• Thread Count, DOP
• Table & Index Scan, Index Seek
• Index Selectivity & Tuning

Ch 44: Lock Management

• Open Transactions in Realtime
• Open Transaction, Blocking
• LOCKS: Types & Audits
• S, X, IX, U and MD Locks
• Sch-M and Sch-S Locks
• SP_WHO2, SP_LOCK
• sysprocesses & Lock Waits

Ch 45: Isolation Levels

• Lock Hints and Isolation Levels
• Read Committed, Uncommitted
• Serializable, Repeatable Read
• Snapshot Isolation, Versioning
• Read Committed Snapshot
• sysprocesses & sp_who2
• Choosing Correct Isolation Level

Ch 46: Cloud Basics, Azure Funda

• Cloud Fundamentals
• Activity Monitor Tool
• Cloud Concepts, Benefits
• IaaS, PaaS, SaaS Cloud Types
• Azure Cloud Concepts
• Azure Resources & Usage
• Azure Services & Purpose
• Azure Account & Subscription

Ch 47: Azure SQL Deployments

• Azure SQL Services
• Azure SQL Server Creation
• Azure SQL Databases
• Azure Firewall : Rules
• Test Connections from SSMS
• SSMS Tool : Test Connections
• ADS Tool : Installation, use)

Ch 48: Azure SQL DB Operations

• Azure SQL : DDL Statements
• Azure SQL: DML Statements
• Azure SQL: DQL Statements
• TCL & DCL Commands
• Differences with OnPrem
• Azure SQL DB Advantages

Ch 49: Azure SQL DB Licensing

• Azure SQL DB Licensing
• Per Database Licensing
• DTUs: Basic, Standard Types
• VPU and Plan Types
• DTU Versus VPU Licensing
• Elastic DTUs (eDTU) Usage
• Elastic Query Processing

Ch 50: Azure SQL DB Migrations

• SQL DB Migration Options
• Data Migration Assistant: DMA
• DMA Tool, Migration Options
• On-Premises DB Export
• Azure SQL Database Import
• Azure Storage Account
• Linking SSMS with Azure

Ch 51: Azure SQL DB Metrics

• Azure SQL DB Metrics
• CPU, Memory, Log Metrics
• Data File Metrics, Alerts
• Action Groups & Emails
• Query Performance Insight
• Automated Tuning Options
• Query Recommendations

Ch 52: Azure SQL DB Tuning, AI

• Automated Tuning Options
• Manual Tuning Options
• Server Level Tuning
• Database Level Tuning
• Create Index Option
• Drop Index, Seek Options
• Built-In Intelligence

Ch 53: Azure AI Search

• AI Search Service, Tuning
• AI Indexes, Practical Use
• Watermark Columns
• Triggers & Timestamp
• Filterable, Searchable
• Sortable, FaceTables
• Indexer & Data Refresh

👉🏻Realtime Project For your Resume: End to End Project

👉🏻Resume Guidance (1:1)

👉🏻Mock Interview