SQL School

#Microsoft SQL Course

✅ Introduction to MS SQL Server Architecture
✅ Writing Basic to Advanced T-SQL Queries
✅ Joins, Subqueries, CTEs & Window Functions
✅ Data Types, Constraints & Normalization
✅ Creating & Managing Tables, Views & Indexes
✅ Stored Procedures, Functions & Triggers
✅ Transactions, Locking & Error Handling
✅ Performance Tuning & Query Optimization
✅ Backup, Restore & Database Maintenance
✅ Real-Time Scenarios & SQL Server Management Studio

Training Schedules

S No	Time (IST, Mon - Fri)	Start Date
1	6 AM - 7 AM	Sep 2nd
2	10 AM - 11 AM	Aug 26th
3	6 PM - 7 PM	Sep 8th
4	8 PM -9 PM	Sep 15th

Trainer : Mr. Sai Phanindra Tholeti

www.linkedin.com/in/saiphanindra/

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, 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

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

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

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 Training FAQ's

What is Microsoft SQL Job Role?

A Microsoft SQL Developer / Admin is responsible for designing, developing, managing, and securing databases using Microsoft SQL Server (T-SQL). The role involves writing SQL queries, stored procedures, triggers, and functions, managing indexes, views, and transactions, and ensuring the security, performance, and availability of SQL databases. SQL professionals work closely with application developers, DBAs, and analysts to build and support data-driven applications and solutions.

What are the Job Roles of a Microsoft SQL Professional?

💼 Top Job Roles:

1️⃣ Design and create relational database structures
2️⃣ Develop T-SQL code: queries, procedures, functions, triggers
3️⃣ Ensure data integrity and implement constraints
4️⃣ Tune queries and optimize database performance
5️⃣ Manage backups, restores, and high availability
6️⃣ Secure databases with roles, permissions, and encryptions and more..!

What does our Microsoft SQL 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 for a career in database development or administration
Developers seeking expertise in SQL Server backend development
DBAs looking to upskill in performance tuning and security
ETL professionals working with SQL as a data source
Anyone interested in mastering SQL Server and T-SQL

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