Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

T-SQL Execution Plans, Indexes, Transactions, In-Memory OLTP

Name: T-SQL Execution Plans, Indexes, Transactions, In-Memory OLTP
Rating: 4.6 (823 reviews)

Learn Execution Plans, Indexes, Transactions, Isolation Levels & In-Memory OLTP using T-SQL in Microsoft SQL Server

Bestseller

Highest Rated

Created byVikas Munjal

Last updated 1/2026

English

What you'll learn

Understand how SQL Server stores and accesses data using pages, extents, heaps, and indexes
Design and maintain effective indexing strategies using clustered and nonclustered indexes
Identify performance issues using execution plan operators, warnings, and indicators
Tune queries by recognizing common execution plan patterns and anti-patterns
Understand transactions and concurrency behavior in SQL Server
Identify and resolve concurrency problems such as dirty reads, phantom reads, and deadlocks
Choose the correct transaction isolation level based on real-world scenarios
Understand and implement In-Memory OLTP, including tables, indexes, and native compiled procedures

Course content

9 sections • 79 lectures • 9h 0m total length

Introduction4:51
Page in SQL Server3:17
Extent in SQL Server4:12
Heap in SQL Server5:22
Clustered Index8:46
Non Clustered Index5:34
Heap with Non Clustered Index3:33
Indexes are not very Deep2:39
Composite Index Part 17:00
Composite Index Part 21:46
Index Fragmentation8:45
More on Fragmentation2:45
Please download Demonstration Scripts0:02
Index Creation using T-SQL Commands13:27
Index Rebuild and ReOrganize2:58
Index Fragmentation Practical12:11
FillFactor5:26
T-SQL Command to introduce FillFactor in an Index0:24
Included Columns5:42
Data Type on Clustered Index6:13

What are Estimated & Actual Execution Plans along with Statistics6:57
Download and Restore AdventureWorks Database4:09
Table Scan Operator3:40
Index Scan Operator2:30
Index Seek Operator1:51
Key Lookup, RowID Lookup & Nested Loop Operators14:59
Index supports Wild Card5:31
Sort in Execution Plan7:58
Merge Join Operator5:46
Hash Join,Merge Join & Nested Loop Operators16:43
Compute Scalar Operator6:12
Stream and Hash Aggregate Operators4:55
Compare stream and hash aggregate operators in SQL Server, showing how sorted data enables stream aggregation and unsorted data triggers hash aggregation for group by and sums.
Subtree Cost of Stream and Hash Aggregate0:36
Semi Joins & Anti Semi Joins in Execution Plan12:44
Explore semi joins and anti semi joins in execution plans, including left and right variants, demonstrated inside a nested loop with practical examples.
Merge using Left Anti Semi Join in Execution Plan5:32
Execution Plan of Insert Operation12:13
Execution Plan of Delete Operation2:58
Parallelism in Execution Plan8:03
Distribute Stream ,Gather Stream & Repartition Stream3:49
Segment Operator & Sequence Project Operators in Execution Plan6:18
Lazy Spool in Execution Plan11:08
Eager Spool and Halloween Problem -Update Practical10:04
Understand how eager spool loads all data into tempdb to prevent the Halloween problem, using a staging temp table to update safely instead of reading from the index.

Introduction0:35
Parameter Sniffing vs Parameter Sensitive Plan Optimization in Sql Server 20226:07
Parameter Sniffing vs Parameter Sensitive Plan Optimization Practical11:25
Merge Join Patterns4:34
Study merge join patterns by noting outdated statistics cause underestimation and tempdb spills during sorting, and assess how index choices and estimated versus actual row counts shape execution plans.
Hash Join Patterns4:00
Explore hash join patterns in SQL Server, including build and probe phases, outer vs inner tables, cardinality issues, and memory spills to tempdb in hash match executions.
Key Lookup Patterns3:12
Sort Aggregate & Parallelism Indicators3:47
Warnings in Execution Plan1:27
Summary0:24
Learn index concepts and commonly used execution plan operators, identify indicators and patterns in execution plans, and use these concepts to tune SQL commands.

Read Uncommitted Isolation Level6:11
Explore the read uncommitted isolation level and how it bypasses concurrency protections, enabling dirty reads and showcasing locking behavior and rollback impact with a SQL Server example.
Read Committed Isolation Level3:59
Repeatable Read Isolation Level7:10
Serializable Isolation Level8:05
Scenario where Repeatable Read or Serilizable or Snashot can be used1:13
Snapshot Isolation Level Part 110:29
Snapshot Isolation Level Part 211:26
Read Committed Snapshot Isolation Level8:00

Auto Commit , Implicit and Explicit Transaction5:55
Deadlock6:47
Analyze how deadlocks occur when two transactions wait on locked records, how SQL Server detects them, rolls back a victim (error 1205), and how timing adjustments prevent recurrence.
Lock Modes12:21
Explore how SQL Server uses lock modes such as shared, exclusive, update, and intent, along with schema locks and page-level behavior to maintain data consistency.
Pessimistic v/s Optimistic Concurrency Control5:06

What are Inmemory Tables8:23
Advantages of In-memory Table26:00
Explore when in-memory oltp tables excel in high-concurrency workloads by avoiding heavy locking and hot pages, and apply them to session state, data staging, and etl workflows.
Creating Inmemory Table and Testing its performance18:04
Inmemory Table Indexes10:18
Explore hash indexes on in-memory tables, noting bucket counts for point lookups and inserts and their limits on inequalities and sorting, then compare to range non-clustered indexes.
Native Compiled Stored Procedure11:21
Migration from Existing Disk Based Tables to Inmemory Table12:17

In-Memory OLTP Snapshot Isolation Level14:51
Learn how in-memory OLTP snapshot isolation keeps reads stable during a transaction without locking, prevents lost updates, and uses snapshot elevation or hints for memory-optimized tables.
In-Memory OLTP Repeatable Read Isolation Level5:23
Understand repeatable read isolation in in-memory OLTP, where reads within a transaction yield the same results and include snapshot features. Explore rollback on commit and phantom reads with SSMS demonstrations.
In-Memory OLTP Serializable Isolation Level4:35
Bonus Lecture1:40

Requirements

RDBMS concepts should be known & should have good hands-on on T-SQL Commands
Microsoft SQL Server and SQL Server Management Studio should be installed already

Description

This course is not for beginners. One should have prior knowledge on T-SQL commands before enrolling into this course.The course contains the following topics

Index Concepts in SQL Server

Page in SQL Server

Extent in SQL Server

Heap in SQL Server

Clustered Index

Non Clustered Index

Heap with Non Clustered Index

Indexes are not very Deep

Composite Index

Index Fragmentation

Index Creation using T-SQL Commands

Index Rebuild and ReOrganize

FillFactor

Included Columns

Data Type on Clustered Index

Execution Plan

Statistics

Actual Execution Plan

Estimated Execution Plan

Common Operators

Table Scan

Index Scan

Index Seek

Key Lookup

RowID Lookup

Nested Loop

Sort

Merge Join

Hash Join

Compute Scalar

Stream Aggregate

Hash Aggregate

Left Semi Join

Right Semi Join

Left Anti Semi Join

Right Anti Semi Join

Segment

Sequence Project

Lazy Spool

Eager Spool

Parallelism - Distribute Stream ,Gather Stream & Repartition Stream

More on Execution Plans

Halloween Problem

Execution Plan of Insert Operation

Execution Plan of Delete Operation

Execution Plan of Update Operation

Subtree cost related to Parallelism

Subtree Cost of Stream and Hash Aggregate

Index supports Wild Card

Patterns to Note to Tune Queries

Parameter Sniffing

Parameter Sensitive Plan Optimization in Sql Server 2022

MergeJoin Patterns

Hash Join Patterns

Key Lookup Patterns

Sort Indicators

Aggregate Indicators

Parallelism Indicators

Warnings in Execution Plan

From these topocs you will learn how to read and understand execution plans which will help in tuning Transact SQL Commands

Later sections of the online video training course include topics related to Transactions , Concurrency Problems , their solutions using Transaction Isolation Levels . Another major portion of the course consists of In-Memory OLTP in T-SQL .

The details topics are

Transactions

Auto Commit Transactions

Implicit Transactions

Explicit Transactions

Deadlock

Lock Modes

Concurrency Problems

Dirty Read Problem

Non Repeatable Read Problem

Phantom Read Problem

Lost Update Problem

Isolation Levels and Solutions

Read Uncommitted Isolation Level

Read Committed Isolation Level

Repeatable Read Isolation Level

Serializable Isolation Level

Scenario where Repeatable Read or Serializable or Snapshot can be used

Snapshot Isolation Level

Read Committed Snapshot Isolation Level

In-Memory OLTP

What are In-memory Tables

Scenarios of In-memory Table

Creating In-memory Table and Testing its performance

In-memory Table Indexes

Native Compiled Stored Procedure

Migration from Existing Disk Based Tables to In-memory Table

In-Memory OLTP Isolation Levels

In-Memory OLTP Snapshot Isolation Level

In-Memory OLTP Repeatable Read Isolation Level

In-Memory OLTP Serializable Isolation Level

Who this course is for:

The partitcipants who have prior knowledge of T-SQL commands.
This course is for SQL Server Developers , SQL Server DBAs, .NET Developers who writes T-SQL Commands , Data Analysts etc.

T-SQL Execution Plans, Indexes, Transactions, In-Memory OLTP

What you'll learn

Explore related topics

Course content

Index Concepts20 lectures • 1hr 45min

Execution Plans22 lectures • 2hr 35min

Patterns to Notice in Execution Plans9 lectures • 36min

Transaction Introduction2 lectures • 19min

Concurrency Problems4 lectures • 26min

Isolation Levels and Solutions8 lectures • 57min

More on Locking and Transactions4 lectures • 30min

In-Memory OLTP6 lectures • 1hr 26min

In-Memory OLTP Isolation Levels4 lectures • 26min

Requirements

Description

Who this course is for: