T-SQL Execution Plans Index Transactions & 2025 New Features (Udemy.com)

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

Optional Parameter Plan Optimization in SQL Server 2025

MergeJoin Patterns

Hash Join Patterns

Key Lookup Patterns

Sort Indicators

Aggregate Indicators

Parallelism Indicators

Warnings in Execution Plan

From these topics 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

Also this course provides a technical walkthrough of the new developer-centric features introduced in SQL Server 2025. It is designed for developers and database professionals who want to move beyond traditional T-SQL and leverage modern capabilities like AI-driven vector search, native JSON handling, advanced regular expressions, and intelligent query optimization.

This is a practical, feature-focused course. We cut through the marketing to focus on syntax, implementation, and performance impact.

What You Will Learn The curriculum is organized into four core modules covering the following technical areas:

• AI & Vector Search: Integration of semantic search capabilities using the native Vector datatype. We cover embeddings with OpenAI, distance functions for similarity searching, and efficient implementation using DiskANN.

• Native JSON & Data Handling: Transitioning from legacy NVARCHAR parsing to SQL Server’s new high-performance native JSON datatype, including native indexing strategies and the JSON_OBJECTAGG function.

• Regex, Text Analytics & Productivity: Implementation of native Regular Expressions (REGEXP_LIKE, REPLACE, SUBSTR, COUNT), practical usage of the || concatenation operator, Base64 encoding/decoding, and Fuzzy Matching algorithms (Edit Distance and Jaro-Winkler).

  
  

  After learning these new features , you will have a clear, working knowledge of these specific SQL Server 2025 features and be prepared to implement them in your development and production environments.