#Microsoft SQL

Microsoft SQL Server is one of the stable technologies in database platform. SQL Databases are every where around us.. from Banking to HealthCare, from Petro Chemicals to Retail – SQL Server is the most preferred database systems in the IT market for last FOUR decades !

Learning SQL Server and TSQL is very easier, useful and simple. With my step by step classes, I will make sure I teach every concept relating to the things around us !

Training Schedules

S No	Time (IST, Mon - Fri)	Start Date
1	6 AM - 7 AM	Sep 23rd
2	8 PM -9 PM	Sep 15th

Microsoft SQL (TSQL) Training Course Contents:

Brochure Download Register Now

Module 1: MSSQL & TSQL Queries

Ch 1: Database Intro & Job Roles

Database Introduction
Database Types: OLTP, DWH
DBMS & Realtime Use
DBMS Software & Purpose
SQL : Purpose & Use
SQL Server Versions, Editions
Job Roles & Responsibilities

Ch 2: SQL Server Installations

SQL Server 2022 Installations
SQL Server 2019 Installations
SSMS Tool Installation
Server Connections, Properties
Instance & Instance Types
Authentication Types
System Databases & Purpose

Ch 3: SQL Basics V1 (Commands)

Database, Tables & Columns
SQL Basics: Purpose
DDL Statements
DML Statements
DQL Statements
Verifications @ GUI
Basic SELECT Queries

Ch 4: SQL Basics V2 (Operators)

DDL Variants in MSSQL
DML Variants in MSSQL
INSERT & INSERT INTO
SELECT & SELECT INTO
Basic Operators in SQL
Special Operators in MSSQL
ALTER, TRUNCATE, DROP

Ch 5: Excel Data Imports

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

Ch 6: Schemas & Security

Schemas: Creation, Usage
Schemas & Table Grouping
Using Default Schema
Real-world Banking Database
Table Migrations @ Schemas
2 Part, 3 Part & 4 Part Naming
Verifying Schemas in UI

Ch 7: Constraints & Keys Basics

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

Ch 8: Relations, Normal Forms

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

Realtime Case Study 1

Ch 9: Joins Basics

Joins: Table Comaparisons
Inner Joins & Matching Data
Outer Joins: LEFT, RIGHT
Full Outer Joins & Audits
Cross Joins & Table Combinations
Joining more than 2 tables
Joining Tables with Aliases

Ch 10: Remote Joins

Working with Multiple Servers
Multi Server Access from SSMS
Linked Servers Creation, Tests
4 Part Naming Convention
Remote Data Access
RPC & RPC OUT
Remote Joins & Data Analysis

Ch 11: Transactions & ACID

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

Ch 12: Views & RLS

Views : Realtime Usage
Storing SELECT in Views
DML, SELECT with Views
RLS: Row Level Security
WITH CHECK OPTION
Database Audits & Metadata
Important System Views

Ch 13: Triggers & Automations

Need for Triggers
DDL & DML Triggers
For / After Triggers
Instead Of Triggers
Memory Tables with Triggers
Data Replication, Automation
Disabling DMLs & Triggers

Ch 14: Stored Procedures – L1

Stored Procedures: Realtime Use
User SPs and System SPs
Parameters Concept with SPs
Procedures with SELECT
System Stored Procedures
Metadata Access with SPs
SP Recompilations, Tuning

Ch 15: Stored Procedures – L2

Stored Procedures For DML
Data Validations and SPs
IF..ELSE Conditions in SPs
Multi Parameter Procedures
Merge Statement & Upsert
Merge Statement with SPs
Incremental Loads in TSQL

Ch 16: User Defined Functions

Using Functions in MSSQL
Scalar Value Functions
Inline & Multiline Functions
Parameterized Queries
Date & Time Functions
String Functions & Queries
Aggregated Functions & Usage

Realtime Case Study 2

Ch 17: Data Types & Conversions

Integer Data Types
Character, MAX Data Types
Decimal & Money Data Types
Boolean & Binary Data Types
Date and Time Data Types
Table, SQL_Variant Types
Cast( ) and Convert( ) Functions

Ch 18: Sub Queries

Sub Queries Concept
Sub Queries & Aggregations
Joins with Sub Queries
Sub Queries with Aliases
Sub Queries with OrderBy
Sub Queries with WHERE
Sub Queries, Joins, Where

Ch 19: 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 20: Joins with Group By

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

Ch 21: Window Functions, CASE

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

Ch 22: Self Joins, EXISTS

Joining same table
Correlated Queries
Joining Tables, Queries
Self Joins with WHERE
Self Joins with UNION
Self Joins with Order By
Self Joins with Views

Ch 23: Cursors & Queries

Cursors : Realtime Usage
Cursor Declaration Types
Open Cursor, Close Cursor
Local & Global Cursors
Scroll & Forward Only Cursors
Static & Dynamic Cursors
Fetch, Absolute Cursors

Ch 24: CTEs & Tuning

CTE: Common Table Expression
Creating and Using CTEs
CTEs and In-Memory Processing
Using CTEs for DML Operations
Using CTEs for Data Retrieval
Using CTEs for Tuning
CTEs For Duplicate Row Deletion

Realtime Case Study 3

Module 2: TSQL Programming

Ch 25: Variables & Try..Catch

Variables: Declaration & Usage
Assigning Values to Variables
SELECT & SET Operations
Using Variables in SPs
Variables Versus Parameters
Try.. 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 Expressions
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 & Verying 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

Planning for 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

Realtime Project 1

Module 3: Query Tuning

Ch 37: Query Audits & AM Tool

Activity Monitor Tool
Perfmon Tool & Counters
Query Audits: DMVs, DMFs
Cross Apply & DMFs
Plan Handle, Execution Time
Auditing Long Running Queries
Audit Frequent Running Queries

Ch 38: Query Store

Buffer Cache: Limitations
Query Store: Advantages
Query Store: Configurations
Operation Mode, Data Flush
Query Mode, Capture Mode
Stats Collection, Stale Queries
Query Store in Realtime

Ch 39: Indexes & Tuning

Indexes: Realtime Use
Clustered Index: Sort, PadIndex
Non-Clustered Index: Regular
Included, Column Store Indexes
Filtered, Online Indexes
Covering Index, Selectivity
Indexed Views & Tuning Options

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: Partitions, Compressions

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

Ch 42: Statistics & Updates

Statistics: Realtime Use
Automated Statistics
Index Level Statistics
Column Level Statistics
Conditional Statistics
Manual Update of Statistics
Indexes Versus Statistics

Ch 43: Index Management

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

Ch 44: Tuning Tools

Tuning Tools: Workload Files, .trc
Profiler Tuning Template, Events
DTA, Profiler: Recommendations
PDS: Physical Design Structures
PDS Recommendations
DTA with Query Execution Cache
Tuning Tools: Precautions

Ch 45: 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 46: Lock Management 1

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 47: Lock Management 2

Deadlocks in Real-world
Profiler Tool & Deadlocks
Lock Management: Deadlocks
Deadlock Graphs & Events
Deadlock Avoidance, Prevention
Deadlock Prevention
sysprocesses & sp_who2

Ch 48: 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

Realtime Case Study 4

Module 4: Azure SQL Dev With AI

Ch 49: Cloud Fundamentals

Cloud Fundamentals
Public Cloud & Private Cloud
Cloud Implementations: SaaS
Paas & IaaS Implementations
Cloud Storage : Practical Benefits
Database Hosting in Cloud
Azure Cloud: Advantages

Ch 50: Azure Cloud Concepts

Azure Cloud Account Funda
Azure Cloud Account Creations
Azure Subscriptions (Free)
Azure Management Groups
Azure Resources Creation
Azure Resource Groups
Azure Portal Usage

Ch 51: Azure SQL Deployments

Azure SQL Server Creation
Azure Server (Logical Server)
Networking Settings
Azure Firewall Creations
Azure Services : Enabling
Testing SSMS Connections
Password Resets in Azure

Ch 52: SQL DB Deployments

SQL Database Deployment
Daabase Pricing Tiers
DTU Selection & Compute
Azure SQL DB Connections
Database Verifications
DB Connections @ Portal
DB Connections @ SSMS

Ch 53: Azure SQL Concepts (TSQL)

Creating TSQL Sessions
TSQL : DB Connections
TSQL : Creating Schemas
TSQL : Creating Tables
Data Inserts, Bulk Loads
Stored Procedures & TVP
Programming Concepts

Ch 54: Azure SQL DB Licensing

Azure SQL DB Licensing
DTU: Data Transaction Units
Basic, Standard Plans
Premium Plans, Scale-Up
VCore Purchasing Plans
Hyperscale VCore Plans
Provisioned & Serverless

Ch 55: Azure Elastic Pools, Tuning

Elastic Pools in Azure
Performance Tuning Options
DTU Versus Core Plans
Standard, Premium, Basic
HyperScale & Serverless
Horizontal Scaling, Databases
Elastic Query Processing

Ch 56: Azure SQL DB Migrations 1

SQL DB Migrations Options
Azure SQL DB Assessment
Data Migration Strategies
Using DMA Tool in Realtime
Schema Generation @ OLTP
Schema & Data Migrations
Data Migration Verifications

Ch 57: Azure SQL DB Migrations 2

Database Migration Strategies
Azure Storage Account
BLOB Storage Container
Generating bacpac File
Uploading bacpac File
Azure SQL DB Imports
DB Migration Verifications

Ch 58: Azure Tuning & AI – 1

Azure SQL Server Tuning
Azure SQL DB Tuning
Query Insights & Tuning
Automated Tuning with AI
Index Creation & AI Engine
Index Drop & AI Engine
Forced Plan Options, Tuning

Ch 59: Azure Tuning & AI – 2

Azure AI Search Service
Azure Table Tuning Options
Creating & Using Timestamps
Facetable Indexes & Uses
Retrieval Indexes & Uses
Filterable and Sortable
Azure AI For DB Tuning

Ch 60: Azure Metrics & Alerts

Query Insights & Reports
Automated Tuning Alerts
Query Metrics in Azure
Azure Notification Service
Azure Action Groups, Emails
Azure Alerts & Metrics
Alert Verifications and Edits

Realtime Project 2

SQL SCHOOL

24x7 LIVE Online Server (Lab) with Real-time Databases.
Course includes ONE Real-time Project.

Microsoft SQL (TSQL) Training FAQ's

What is Microsoft SQL (TSQL) Job Role?

Microsoft SQL (TSQL) professionals focus on writing efficient queries, stored procedures, functions, views, and triggers to manage, manipulate, and retrieve data from SQL Server databases. The role involves designing database objects, creating data models, and optimizing TSQL scripts for performance, security, and scalability in transactional and reporting systems.

What are the Job Roles of an Microsoft SQL (TSQL)?

💼 Top Job Roles:

1️⃣ Writing complex TSQL queries for data extraction and reporting
2️⃣ Developing and managing stored procedures, functions, and views
3️⃣ Implementing triggers for data integrity and automation
4️⃣ Optimizing queries and indexes for performance tuning
5️⃣ Building and maintaining data models and relational structures
6️⃣ Collaborating with application teams for backend database logic and more..!

What does our Microsoft SQL (TSQL) Training course contains?

The course is carefully curated with below module:
👉🏻Module 1: MSSQL & TSQL Queries
👉🏻Module 2: TSQL Programming
👉🏻Module 3: Query Tuning
👉🏻Module 4: Azure SQL Dev

Who can join this course?

Freshers aiming to start a career in database development
Application developers wanting to enhance SQL Server backend skills
Data analysts requiring advanced querying capabilities
IT professionals upskilling for TSQL and SQL Server roles
Anyone passionate about working with databases and data

No prior coding experience is required. All concepts are taught from scratch

What training modes are available?

Option 1: LIVE Online Training (100% Interactive, step by step, assignments)

Option 2: Self Paced Videos (100% practical, step by step with concept wise assignments)

You may choose any one of these options, same curriculum!

I (Trainer) shall be available for doubts and clarifications, assignment check and review.

Why should I choose SQL School for Microsoft SQL (TSQL) training?

👉🏻 Every session is Practical, Step by Step with Concept wise FAQs !!

👉🏻 100% results with on-time practice. Daily Tasks for every session.

👉🏻 Concept wise tasks be submitted before next class for Job Waiters / Starters.

👉🏻 Concept wise tasks due for submission by Weekends for Working Professionals.

Why Choose SQL School

100% Real-Time and Practical
ISO 9001:2008 Certified
Concept wise FAQs
TWO Real-time Case Studies, One Project
Weekly Mock Interviews
24/7 LIVE Server Access
Realtime Project FAQs
Course Completion Certificate
Placement Assistance
Job Support
Realtime Project Solution
MS Certification Guidance