SQL Server & T-SQL Training (LIVE, Instructor-Led)

This impeccable Microsoft SQL Server Training Course is exclusively designed for aspiring Data Analysts, Business Analysts, Data Scientists, MSBI / Power BI Engineers and SQL Database Developers. This SQL Server and T-SQL Training Course is designed for both starters as well as for experienced professionals. This course includes SQL Basics, T-SQL Queries, Query Writing and Query Understanding required for Data Analysts and Business Analysts. This course also includes Programming, Tuning and Azure SQL (Cloud) concepts required for BI Developers and SQL Database Developers. One Real-time project is included in this SQL Server and T-SQL Training Course addressing Basic to Advanced SQL Queries, Detailed Database Design, Complex Joins, Common Table Expressions (CTEs), Complex Stored Procedures, Triggers, Remote Joins, Transactions and Query Tuning with XML, BLOB and JSON Data Sources with complete guidance to MCSA 70-761 and MCSA 70-762 Microsoft Certification Exams.

Practice Material, Certification, Resume & Interview Guidance are included in this SQL Server T-SQL Course.

SQL Server & T-SQL Training with Azure SQL

	PLAN A	PLAN B	PLAN C
Applicable For	SQL Dev (0-2 yrs)	SQL Dev (2+ yrs)	SQL Dev (2.5+ yrs)
Course Duration	4 Weeks	5 Weeks	8 Weeks
Course Content	Chapters 1 to 20	Chapters 1 to 26	Chapters 1 to 38
Completely Real-time, Practical	✔	✔	✔
Mock Interviews, Case Studies	✔	✔	✔
SQL Basics and Query Writing	✔	✔	✔
SQL DB Design, Table Design	✔	✔	✔
Normal Forms, Joins, Queries	✔	✔	✔
Indexes, Stored Procedures	✔	✔	✔
Excel Integration, Pivot Charts	✔	✔	✔
Advanced Stored Procedures	✔	✔	✔
CTE, PIVOT, XML and BLOB Data	✔	✔	✔
Real-time Project [Banking]	✔	✔	✔
In-depth Query Tuning	❌	✔	✔
Performance Tools, Locks	❌	✔	✔
Complex SPs, MCSA - 70 761	❌	✔	✔
Azure SQL Database (Cloud)	❌	❌	✔
Azure SQL Database Migrations	❌	❌	✔
Stretch Databases, MCSA 70-762	❌	❌	✔
Total Course Fee*	INR 6000 USD 81	INR 10000 USD 136	INR 19000 USD 257

Trainer: Mr. Sai Phanindra (17+ Yrs of Experience)

All Session Are Completely Practical & Real Time

Trainer : Mr. Sai Phanindra (17+ Yrs of Experience)

S No	Timings (IST)	Start Date
SQL Server & T-SQL Schedules [Chapters 1 to 20]
Regular Schedules [Mon - Fri]
1	6 AM - 7 AM	Aug 18th	Register
2	8 AM - 9 AM	Sep 6th	Register
3	10 AM - 11 AM	Nov 2nd	Register
4	6 PM - 7 PM	Aug 22nd	Register
5	8 PM - 9 PM	Aug 30th	Register
6	9 PM - 10 PM	Oct 3rd	Register

S No	Timings (IST)	Start Date
Query Tuning Schedules [Chapters 21 to 26]
	Weekend Schedules [Sat & Sun]
7	7:30 AM - 9 AM	Oct 8th	Register
8	7:30 PM - 9 PM	Sep 3rd	Register

S No	Timings (IST)	Start Date
Azure SQL Dev Schedules [Chapters 27 to 38]
	Weekend Schedules [Sat & Sun]
9	7:30 AM - 9 AM	Oct 22nd	Register
10	7:30 PM - 9 PM	Sep 17th	Register

If none of the above schedules work for you, please opt for On-demand Video Training

SQL Server T-SQL Training Highlights

✔ Queries, Joins	✔ Dynamic SQL
✔ Query Tuning	✔ CTEs, TVPs
✔ Excel Imports	✔ In-Memory Tables
✔ Excel Pivots	✔ Azure SQL Concepts
✔ Complex joins	✔ Azure DB Migrations

SQL Server T-SQL (DEV) Training Course Contents:

Curriculum

Register Today

Module 1: SQL Server & T-SQL Dev Training Content [For Plans A, B, C ]

Ch 1: SQL SERVER INTRODUCTION

Data, Databases and RDBMS Software
Database Types : OLTP, DWH, OLAP
Microsoft SQL Server Advantages, Use
Versions and Editions of SQL Server
SQL : Purpose, Real-time Usage Options
SQL Versus Microsoft T-SQL [MSSQL]
Microsoft SQL Server - Career Options

SQL Server Components and Usage
Database Engine Component and OLTP
BI Components, Data Science Components
ETL, MSBI and Power BI Components
Course Plan, Concepts, Resume, Project
24 x 7 Online Lab for Remote DB Access
Software Installation Pre-Requisites

Ch 7: JOINS, T-SQL Queries : Level 1

JOINS - Table Comparisons Queries
INNER JOINS For Matching Data
OUTER JOINS For (non) Match Data
Left Outer Joins with Example Queries
Right Outer Joins with Example Queries
FULL Outer Joins - Realtime Scenarios
Join Queries with "ON" Conditions

Join Unrelated Tables in SQL Server
NULL, IS NULL Operators in Joins
CROSS JOIN and CROSS APPLY
CROSS JOIN Versus CROSS APPLY
One-way & Two Way Data Comparisons
Important Join Queries in T-SQL
Join Options: Merge, Loop, Hash

Ch 13: STORED PROCEDURES Level 2

Try..Catch & Error Handling Concepts
THROW Statement and PRINT Options
Event Handling in Stored Procedures
Copying Table Data with Transactions
Creating and Using Table Data Types
Table Valued Parameters (TVP) in SPs
ReadOnly Parameters in Stored Procs

Output Parameters, Stored Procedures
Using Cast, Convert with Stored Procs
Identity Property - Missing ID Values
Data Validations, DMLs in Stored Procs
Dynamic Data Insertions with SPs
Table Cloning, Inserts @ Table Variables
SQL Injection Attacks - Precautions

Ch 2: SQL SERVER INSTALLATIONS

System Configuration Checker Tool
Versions and Editions of SQL Server
SQL Server and SSMS Installation Plan
SQL Server Pre-requisites : S/W, H/W
SQL Server 2016 / 2017 Installation
SQL Server 2019 Installation
Instance Name and Server Features
Instances : Types and Properties

Default Instance, Named Instances
Port Numbers, Instance Differences
Service and Service Account Use
Authentication Modes and Logins
Windows Logins and SQL Logins
FileStream and Collation Properties
DBEngine and Replication Components

Ch 8: Group By, T-SQL Queries Level 2

GROUP BY Queries and Aggregations
Group By Queries with Having Clause
Group By Queries with Where Clause
Using WHERE and HAVING in T-SQL
Rollup : Usage and T-SQL Queries
Cube : Usage and T-SQL Queries
UNION and UNION ALL Operators
Comparing Where, Having Conditions

GetDate, Year, Month, Day Functions
Rollup with Having & Grouping
Date and Time Functions in T-SQL
Convert Functions with DateTime
DateTime Styles, DateAdd, DateDiff
String Functions: Trim, SubString
StringSplit, Concat, Len, Left, Right

Ch 14: STORED PROCEDURES - Level 3

Views: User Defined, System Defined
Data Retreival with Views, Conditions
DML Operations with Views, Conditions
Schema Binding, Structural Modifications
With Check Options and Data Validations
Embedd Views inside Stored Procedures
Dynamic Conditions with Views in SPs
Views: Real-world Use Cases

DML Triggers and DDL Triggers
FOR and INSTEAD OF Triggers
Magic Tables : Inserted, Deleted
ENCRYPTION and CHECK OPTION
Cascaded Views, Encrypted Views
Updatable Views, Joins with Triggers
Stored Procedures @ Triggers, Views

Ch 3: SSMS Tool, SQL BASICS - 1

SQL Server Management Studio
Local and Remote Connections
System Databases: Master and Model
MSDB, TempDB, Resource Databases
Creating Databases : Files [MDF, LDF]
Creating Tables in User Interface
Data Insertion & Storage. Limitations

SQL : Purpose and Real-time Usage
SQL Versus T-SQL : Basic Differences
DDL, DML, SELECT, DCL and TCL
Creating Tables using SQL Scripts
Data Storage, Inserts - Basic Level
Table Data Verifications with Select
SELECT Statement for Table Retrieval

Ch 9: JOINS, T-SQL QUERIES Level 3

Self Referencing Keys, Candidate Key
Adding PK to Existing Tables
Adding FK to Existing Tables
Self Joins and Table Aliases
Join Queries with Group By, Aggr
Views For T-SQL Query Store
Fetch, Offset, Next Rows, Order By

Joins with Group By, Sub Queries
Formating with IIF and CASE
Formating with Cast, Convert
Using Joins with Nested Sub Queries
Sub Queries and Alternatives to Joins
Excel Pivot Tables and Reports
Pie Charts & Data Refresh Options

Ch 15: STORED PROCEDURES - Level 4

Cursors - Benefits, Cursors in SProcs
ForwardOnly, Scroll & Local Cursors
Static, Dynamic & Global Cursors
Keyset Cursors and @@FetchStatus
Nesting of Stored Procedures - Dynamic
Data Formatting and WHILE Loops
Using Temporary Tables for Formatting

CTE : Common Table Expressions
Real-time Scenarios with CTEs - Usage
ROW_NUMBER() with CTE Queries
Using CTEs for Avoiding Self Joins
Using CTEs for Avoiding Sub Queries
Recursive CTEs and ANCHOR Element
Termination Checks in Recursive CTEs

Ch 4: SQL BASICS - 2

Creating Databases & Tables in SSMS
Single Row Inserts, Multi Row Inserts
Rules for Data Insertion Statements
SELECT Statement @ Data Retrieval
SELECT with WHERE Conditions
Batch Concept and Go Statement
AND and OR Operators Usage
IN Operator and NOT IN Operator

Between, Not Between Operators
LIKE and NOT LIKE Operators
UPDATE Statement & Conditions
DELETE & TRUNCATE Statements
Logged and Non-Logged Operations
ADD, ALTER and DROP Columns
ALTER & DROP Table Statements

Ch 10: View, SPs, Function Basics

Views : Types, Usage in Real-time
System Predefined Views and Audits
Listing Databases, Tables, Schemas
Function Types, Usage in Real-time
Scalar, Inline and Multi-Line Functions
UDF: Creation, Executions with Select
Variables & Parameters in SQL Server
Implementing Dynamic Joins in T-SQL

Procedures : Types, Usage in Realtime
User & System Predefined Procedures
Using Parameters in Stored Procedures
Store, Execute T-SQL Queries in SPs
Performance Advantages with SPs
SPs on Single and Multiple Tables
Dynamic Joins & SP Recompilations

Ch 16: XML,BLOB,FUNCTIONS Level 2

Functions : Types, Real-world Usage
Scalar Value Returning Functions
Inline Table Value Functions
Multi-Line Table Value Functions
WHILE Loops and Iterations in T-SQL
Table Variables Usage in T-SQL
Data Types, Usage and Conversions
Scenario: Generating Calendar Values

Composite Keys, Computed Columns
Cascading Keys, Auto Update, EXISTS
XML AUTO, XML RAW and XML PATH
BULK INSERT, BULKCOLUMN, JSON
OPENROWSET, PIVOT and UNPIVOT
JSON Files - Data Import into SQL DB
Nested Queries, Co-related Queries

Ch 5: SQL Basics - 3, T-SQL INTRO

Database Objects : Tables and Schemas
Schemas : Group Tables in Database
Schemas : Security Management Object
Creating Schemas & Batch Concept
Using Schemas for Table Creation
Data Storage in Tables with Schemas
Data Retreival and Usage with Schemas
Table Migrations across Schemas

Import and Export Wizard in SSMS
Data Imports with Excel File Data
Performing Bulk Operations in SSMS
Temporary Tables : Real-time Use
Local and Global Temporary Tables
# and ## Prefix, Scope of Usage
Session Level, Connection Level Use

Ch 11: Triggers & Transactions

Triggers - Purpose, Real-world Usage
FOR/AFTER Triggers - Real time Use
INSTEAD OF Triggers - Real time Use
INSERTED, DELETED Memory Tables
Using Triggers for Data Replication
Enable Triggers and Disable Triggers
Database Level, Server Level Triggers
Auditting Triggers and Real World Use

Transactions : Types, ACID Properties
Transaction Types and AutoCommit
EXPLICIT & IMPLICIT Transactions
COMMIT and ROLLBACK Statements
Open Transaction Scenarios & Cause
Query Blocking Scenarios @ Real-time
NOLOCK and READPAST Lock Hints

Ch 17: Server, DB Architecture

Server Architecture and Protocols
Database Engine and Query Processor
Parser, Optimizer, SQL & DB Manager
Storage Engine Components, SQL OS
File Manager and Database Files
Transaction Services, Buffer Manager
Lock Manager, IO Manager, MDAC
CLR, WAL, Lazy Writer, Checkpoint

Database Architecture - Data Files
Database Architecture - Log Files
Primary (mdf), Secondary Files (ndf)
Filegroups Usage, ReadOnly Filegroups
Database Files : Size and Location
Pages, Extents. Uniform, Mixed Extents
Transaction Log File [LDF], LSN, VLF

Ch 6 : CONSTRAINTS,INDEXES BASICS

Constraints and Keys - Data Integrity
NULL, NOT NULL Property on Tables
UNIQUE KEY Constraints: Importance
PRIMARY KEY Constraint: Importance
FOREIGN KEY Constraint: Importance
REFERENCES, CHECK and DEFAULT
Candidate Keys and Identity Property

Database Diagrams and ER Models
Relationships Verification and Links
Indexes : Basic Types and Creation
Index Sort Options, Search Advantages
Clustered and NonClustered Indexes
Primary Key and Unique Key Indexes
Need for Indexes - working with Keys

Ch 12 : ER MODELS, NORMAL FORMS

Normal Forms for Entity Relationships
1st Normal Form and Atomocity
2 Normal Form, Functional Dependancy
3 Normal Form Multi Value Dependancy
Boycee-Codd Normal Form : BNCF
4 Normal Form Realtime Advantages
1:1, 1:M, M:1, M:M Relationship Types

MERGE Statement - Comparing Tables
WHEN MATCHED and NOT MATCHED
Incremental Loads, IIF Function
CASE Statement : WHEN, ELSE, END
ROW_NUMBER() and RANK() Queries
Dense Rank and Partition By Queries
Identify, Remove Duplicate Rows

Ch 18 - 20: REAL-TIME PROJECT (BANKING)
Includes 2500 Lines of Code (SOLVED).
Phase 1: DATABASE DESIGN

End to End Project Work Flow
Naming Conventions in Real-time
Schemas & Normal Forms (OLTP)
Computed Columns and Data Types
Email and Phone Number Validations

Phase 2: QUERY DESIGN

Views with JOIN Options
Implementing Indexed Views
Using PIVOT Tables in Queries
Dynamic Conditions in Queries
Parameterized Queries in T-SQL

Phase 3: PROGRAMMING

Event Handling, Error Handling
Transactions, Event Handling Options
Transaction Nesting, Save Points
Stored Procs with Functions, Triggers
Project Deployments, Project FAQ

Project Solution, Interview FAQs

Real-time Case Study - 1 (Sales & Retail)
Objective : DB Design, Table Design, Relations
Involves Purchases, Products, Customers
and Time Data with Various Data Types.

Real-time Case Study - 2 (Sales & Retail)
Objective : Query Writing, Excel Integration
Excel Pivot Tables, Pivot Charts,
Data Formatting, ODC Connections & Labelling

Module 2: Performance Tuning Training Content [For Plans B & C]

Ch 1: Basic Tuning & Auditting

Audit Long Running Queries : DMV, DMF
Activity Monitor Tool, Server Dashboards
Logical I/O, Physical I/O, Database I/O
Recent Expensive Queries, Wait Time
Active Expensive Queries, Statistics
Plan Handle, Execution Time - Audits

CPU, IO, Memory Consumption Reports
Server Dashboards and Usage
Database Settings, Performance
Query Store - Settings and Advantages
In Memory Data Store and Query Audits

Ch 3: Statistics and Partitions FTS

PARTITIONS: Performance Tuning
Partition Functions & Partition Schemes
Partitioning Un-partitioned Tables: GUI
Partition Compression : ROW & PAGE
Auditing Table Partitioned Structures
Statistics : Auto Creation, Updates

Index Rebuilding Process and Audits
Index Page Count and Index Condition
Degree Of Parallelism [DOP] Settings
Resumable Indexes: ONLINE, RESUME
PAUSE & RESUME in Index Rebuilds

Ch 5: Tuning Tools & Query Optimization

Tuning Tools: Workload Files, .trc Files
Profiler Tuning Template, SP Events
DTA, Profiler Trace : Recommendations
PDS: Physical Design Structures
Index, Stats, Partition Recommendations
DTA with Query Execution Cache

Perfmon Tool : Usage, Permon Counters
Real-time Tracking: CPU, Memory, IO
Execution Plan Analysis and Internals
Query Costs: IO Cost and CPU Cost
Query Costs: SubTree & Operator Cost
NUMA Nodes, Processor, IO Affinity
Thread Count, Degree of Parallelism
Table Scan, Index Scan, Index Seek

Ch 2: Indexes & Query Tuning

Indexes: Architecture and Index Types
Database Architecture: Data Files
Database Architecture: Log Files
Data Pages and Index Pages
B Tree Structure, IAM Page [Root]
Clustered & NonClustered Indexes

Included, Columnstore, Online
Filtered, Covering, Indexed Views
Fill Factor and Pad Index Options
Index Selectivity with T-SQL Joins
Index Selectivity with Parameters

Ch 4: Full Text Search Indexes, Tables

Introduction to Full Text Search (FTS)
Stop Words, Stemmer and Thesaurus
Indexer Program, Query Processor
Database Catalogs (FTC), FDHost.exe
Creating Full Text Catalogs (FTCs)
CONTAINS() & FREETEXT() Queries

Query Performance Impact with FTS
Resumable Indexes with SQL Server
ONLINE, RESUME, PAUSE Options
In-Memory Tables: Creation & Usage
Memory Snapshots at Database
File Stream Files in SQL Server
Temporal Tables : for DML Audits
Using Temporal Tables for Data Audits

Ch 6: Locks & Isolation Levels

LOCKS : Types and Isolation Levels
S, X, IX,U, MD, Sch-M and Sch-S
Lock Audits : SP_WHO2 & SP_LOCK
sysprocesses and Lock Waits : Audits
Open Transactions, Query Blocking
Lock Hints and Isolation Levels

Read Committed, Read Uncommitted
Serializable and Repeatable Read
Snapshot Isolation, Page Versioning
Read Committed Snapshot Row Version
Choosing Correct Isolation Level
Profiler Tool and Lock Templates
Profiler Filters, Column Selections
XDL Files and Deadlocks Prevention

Module 3: Azure SQL Dev Training Content [For Plan C]

Azure Fundamentals	Azure SQL Dev
Ch 1: Cloud Introduction & Azure Introduction to Cloud Components Cloud Implementation Concepts SaaS: Software as a Service PaaS: Platform as a Service IaaS: Infrastructure as a Service Public, Private and Hybrid Cloud Introduction to Microsoft Cloud Introduction to Azure Cloud; Advantages Azure Cloud Benefits and Pricing Shared Responsibility Model Cloud Computing Options with Azure Azure Implementation of Cloud Services Azure Storage and ETL Resources	Ch 7: Azure SQL Server, Database SQL Server Implementation in Azure Azure SQL Server: PaaS and IaaS Logical SQL Server Creation Resource Name, Resource Group Azure SQL Server Region, Credentials Firewall Settings, Password Reset SSMS Tool and ADS Tool Installation Connections with SSMS Tool Connections with ADS Tool System Databases and Metadata Database Connections and Sessions Versions and Editions with Azure SQL Limitations with Azure SQL Databases
Ch 2: Azure Cloud Concepts Azure Cloud Account Registration Tenant ID and Account ID Concepts Subscriptions: Types and Importance Resource Providers: Types, Importance Resources: Storage, ETL & Analytics, Apps Resouce Groups: Advantages and Usage Azure Services Versus Azure Resources Azure Resources and Service Lines Geography Locations in Azure Azure Regions and Availbility Zones Azure Data Centers with Zones Azure Locations Versus Regions Azure Regional Pairs, Sovereign Regions	Ch 8: TSQL Differences with Azure TSQL Differences with On-Premise Database Connections Linked Servers and Remote Joins Schemas, Indexes and Statistics System Metadata Objects, Audits CTEs and Memory Tables in Azure Azure SQL Databases & Pricing Tiers Elastic Scaling with Azure Databases General Purpose and Business Critical Basic, Standard and Premium Plans vCore Based Purchasing : Gen 4, Gen 5 Elasitc DTU (eDTU) and Performance Edition Upgrade @ Azure SQL Database
Ch 3: Azure Storage & Explorer Tool Azure Storage Resource: Importance Azure Storage Services: BLOB Data Azure Tables, File Shares, Azure Queues Azure Data Lake Storage Gen 2 (ADLS) Service End Points and App Access Storage Browser: Uploads, Downloads Azure Storage Explorer Tool: Importance Installing and Using Azure Storage Explorer Generating SAS [Shared Access Signature] Access Keys and Security Options Data Redundancy Options: LRS, GRS, ZRS Pricing Impact with ADLS Gen 2 Pricing Impact with Geo Replication	Ch 9: Azure SQL DB Migration Azure SQL DB Migration Options Using bapac Method and DMA Tool DMA: Data Migration Assistant Scripting Database: Objects Scripting Objects and Relations Migration Schemas and Data Azure Storage Account: Creation Azure Storage Container For BOLB Generating Access Key for SSMS Onpremise Database Exports Generating bacpac Files, Uploads Importing bacpac Files to Azure SQL Verifying SQL Database Migrations
Ch 4: Azure Active Directory & Pricing Azure Active Directory (AD) Concepts Creating Azure AD Users Creating Azure AD Groups Tenants and Zero Trust Defenders IAM: Identity and Access Management RBAC Roles: Owner and Contributor Azure Resources and Pricing Units Azure Pricing Calculator, Billing Tools Pricing with Region, Availability Zone Local and Geo Options & Cost Management Azure Product Categories, Pricing Units Pricing Estimates: Hourly / Monthly Compute Cost and Storage Cost	Ch 10: AZURE SQL DATABASE TUNING Azure SQL Server Level Tuning Options Azure SQL Database Tuning Options Automated Tuning and Peak-Loads Force Plan, Create Index and Drop Index Query Insight and Recommendations IO Metrics, CPU & Query Statistics Data File IO, Log File IO, Custom Reports Query Audits with Query IDs, Dashboards Query Recommendations, Query Costs Azure Search Service and Pricing Tiers Suggester and Analyzer Modes for Tuning Retrievable, Facetable, Facetable Indexes Change Tracking & Watermark Columns
Ch 5: Azure Monitor & Metrics Azure Resource Manager (ARM) Azure Monitor Components, Metrics Azure Metric Charts and Timelines Chart Compoents; Azure Insights Monitor Dashboards and Audditing Azure Advisor Options and Service Health Azure Alerts and Signal Logic Conditions & Thresholds Evalaution Timelines & Frequency Signal Logic Condition Frequency Action Rules and their Usage Notification Settings Alert Monitoring and Verifications	Ch 11: Azure SQL Server in VM Azure Virtual Machines (VMs) SQL Server with Azure VMs Size, Networking and Authenitcation SQL Server Connection Settings Deployment and VM Verifications VM Verification Options SQL Server Verification Options SQL Server Connections inside VM Database Operitions with SSMS Onpemise to AzureVM Migration Azure Logical Server to VM Migrations Working with Security Logins, Users Comparing IaaS and PaaS
Ch 6: Azure Vitual Machine (VM) Azure Virtual Machines, Container Instance Advantages of Azure Virtual Machines Deploying Azure VMs Using Portal VM Types and Sizing Parameters Disk Types, CPU and Memory; Scale Sets Network Concepts; Firewalls; Availability RDP with Azure VM; Azure Virtual Desktop Availability Sets and Availability Zones Public and Private End Points Application Hosting Options with VM Web Apps Features & Containers Virtual Networking; Subnets & Masks Peering, Azure DNS, Gateways, Express Route	Ch 12: Real-time Project @ Banking Phase 1: Design Phase 2: Queries Phase 3: Programming Concept wise FAQs Project Work @ Banking Project Solution Explanation Project FAQs For Interiews Resume Guidance Mock Interviews