SQL Server & TSQL Training

#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	Aug 5th
2	9 AM - 10 AM	July 29th
3	6 PM - 7 PM	Aug 11th
4	8 PM - 9 PM	Aug 18th

Microsoft SQL (TSQL) Training Course Contents:

Brochure Download Register Now

Module 1: MSSQL & TSQL Queries

Ch 1: SQL SERVER INTRODUCTION

Database Introduction
Types of Databases
Need for & ETL, DWH
BI Implementations
SQL Server Advantages
Version, Editions of MSSQL
Data Analyst Job Roles

Ch 2: SQL SERVER INSTALLATIONS

SQL Server 2022, 2019
SSMS Tools Installation
Database Engine (OLTP)
SCM, Configuration Tools
Instance Types, Uses
Authentication Modes
Collation, File Stream

Ch 3: SQL BASICS – 1

Need for Databases, Tables
Need for SQL Commands
DDL, DML & DQL Statements
Database Creation @ GUI
Data Operations @ GUI
Session ID, SQL Context
DB, Tables, Data @ SQL

Ch 4: SQL BASICS – 2

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

Ch 5: Data Imports, Schemas

Data Imports with Excel
ORDER BY & UNION
UNION ALL For Sorting Data
Creating, Using Schemas
Real-world Banking Database
Table Migrations @ Schemas
2 Part, 3 Part & 4 Part Naming

Ch 6 : Constraints, Index Basics

Need for Constraints, Keys
NULL, NOT NULL, UNIQUE
Primary Key & Foreign Key
RDBMS and ER Models
Identity Property, Default
Clustered Index, Primary Key
Non Clustered Index, Unique

Ch 7: Joins & Views Basics

JOINS: Purpose. Inner Joins
Left / Right / Full Outer Joins
Cross Joins, Query Tuning
Creating & Using Views
DML, SELECT with Views
RLS : WITH CHECK OPTION
System Views & Metadata

Ch 8: Functions(UDF), Data Types

Using Functions in MSSQL
Scalar Value Functions
Inline & Multiline Functions
Date & Time Functions
String, Aggregate Functions
Data Types : Integer, Char, Bit
SQL Variant, Timestamp, Date

Ch 9: Stored Procedures,Models

Stored Procedures & Usage
Creating, Testing Procedures
Encryption, Deferred Names
SPs for Validations, Analysis
System SPs, Recompilation
Normal Forms & Types
Data Models, Self-References

Ch 10: Triggers, Temp Tables

Need for Triggers
DDL & DML Triggers
Using Memory Tables
Data Replication, Automation
Local & Global Temp Tables
Testing & Using Temp Tables
SELECT .. INTO & Bulk Loads

Ch 11: DB Architecture, Locks

Planning VLDBs : Files, Sizing
Filegroups, Extents & Types
Log Files : VLF, Mini LSN
Table Location, Performance
Schemas, Transfer, Synonyms
Transactions Types, Lock Hint
Query Blocking Scenarios

Ch 12 : Cursors & CTEs, Links

Cursors : Realtime Use
Fetch & Access Cursor Rows
CTEs for SELECT, DML
CTEs: Scenarios & Tuning
Linked Servers, Remote Joins
Linked Servers: MSDTC, RPC
Tuning Remote Queries

Ch 13: Merge, Upsert & Rank

Need for Merge in ETL
Incremental Loads with SQL
MERGE and RANK Functions
Window Functions, Partition
Identify, Remove Duplicates

Ch 14: Grouping & Cube

Group By & HAVING
Cube, Rollup & Grouping
Joins with Group By
3 Table, 4 Table Joins
Query Execution Order

Ch 15: Self Joins, Excel Analysis

Self Joins & Self References
UNION, UNION ALL
Sub Queries with Joins
IIF, CASE, EXISTS Statements
Excel Analytics, Pivot Reports

Module 2: TSQL Programming

Ch 16: Adv. Stored Procedures 1

Declaring, Using Variables
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 17: Adv. Stored Procedures 2

Table Valued Parameters
Using TVP with Procedures
Creating User Defined Types
Big Data Copy & Transactions
Using SPs & Table Variables
Transactional Integrity
Output Parameters in SP
IN and OUT Options Usage

Ch 18: Adv. Stored Procedures 3

Dynamic SQL Programs
sp_executesql Extended SP
Formatting Queries, Nvarchar
Cursors Types: Local, Global
Cursor Types: Static, Dynamic
Forward Only, Scroll Types
WHILE Loop: @@Fetch Status
Variables with Dynamic SQL

Ch 19: Complex Functions (UDF)

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 20: Complex Functions – 2

Reading JSON Data
Using OPENROWSET ()
Using nvarchar(max) values
Using PIVOT () Function
Data De-duplication in SQL
Recursive CTEs, Anchors
Recursive CTEs, Anchors

Ch 21 – 24: Banking Project

Design & Planning Phase
Querying Phase
Programming Phase
Debugging Phase
Testing Phase
Complete Project Solution
Project FAQs, Resume Points

Module 3: Query Tuning

Ch 25: Performance Tuning Intro

Performance Tuning: Reasons
Factors Affecting Performance
Processor Affinity and Memory
Disk Configurations and Memory
Server Dashboards & Monitoring
Performance Tuning Techniques

Ch 26: Server Architecture

Database Engine Components
SQL OS Components
Protocols and Query Processing
MDAC and CLR Components
Parsing and Compilation
Memory Manager & IO Managers

Ch 27: Database Architecture

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

Ch 28: Query Audits

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

Ch 29: Query Store

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

Ch 30: Indexes

Indexes: Realtime Use
Clustered Index: Sort, PadIndex
Non-Clustered Index: Regular
Included, Column Store Indexes
Filtered, Online Indexes
Covering Index, Selectivity

Ch 31: Indexed Views

Views with Schemabinding
Creating Views for Indexes
Creating Indexes on Views
Recursive Queries, Index Views
Composite Indexes
Indexes on Text Columns

Ch 32: Statistics

Statistics: Realtime Use
Automated Statistics
Index Statistics
Column Statistics
Conditional Statistics
Manual Update of Statistics

Ch 33: Partitions

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

Ch 34: Index Management

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

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

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

Ch 37, 38: Temporal & MOT Tables

In-Memory Tables: Usage
MOT Tables and Performance
Memory Snapshots at Database
File Stream Files in SQL Server
Temporal Tables for DML Audits
Temporal Tables for Data Audits

Ch 39: Lock Management

LOCKS : Types & Isolation Levels
S, X, IX,U, MD, Sch-M, Sch-S
Lock Audits: SP_WHO2, SP_LOCK
sysprocesses and Lock Waits
Open Transaction, Blocking
Deadlocks in Real-world

Ch 40: Isolation Levels

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

Module 4: Azure SQL Dev

Ch 41: Cloud Basics, Azure Funda

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

Ch 42: Azure SQL Database

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 43: 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 44: 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 45: 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 46: Azure SQL DB Tuning, AI

Automated Tuning Options
Manual Tuning Options
Server Level Tuning
Database Level Tuning
AI Search Service, Tuning
AI Indexes and Practical Use
Watermark Columns, Updates

Ch 47: Azure PaaS & Azure IaaS

Azure PaaS: Operations
Azure Paas: Limitations
Azure IaaS: Advantages
Azure IaaS Components
Azure Virtual Machines
Capacity & Networking
Disk & Memory Config.

Ch 48: Azure IaaS Concepts

Azure Virtual Machines
SQL Server with Azure VM
Access Azure VM from SSMS
Migrations from PaaS
Migrations from On-Premise
Azure Data Studio, VMs
Comparing SSMS & ADS Tool

Ch 49 – 50: Banking Project

OLTP Databases in Azure
Code Based Deployments
Code Less Deployments
Debugging Phases in Azure
Testing Phases in Azure
Complete Project Solution
Project FAQs, Resume Points

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