65317A - Querying and Analyzing SQL Server 2025
This 3-day course teaches students how to perform Transact-SQL queries, query analysis and query optimization on SQL Server 2025. Students will learn to use SQL Server Management Studio 22 and explore modern features including native JSON, vector search, and Intelligent Query Processing. Many lessons also apply to Azure SQL Database environments.
What's included?
-
10 Modules
-
10 Reviews
-
10 Labs
Audience
The primary audience for this course is individuals who want to learn SQL Server 2025 data querying and analysis skills. This course is also a prerequisite for those who want to take the Advanced SQL Server Performance Tuning course (65318A).
At course completion
After completing this instructor-led course, students will be able to:
* Write and execute Transact-SQL queries against SQL Server 2025 databases using SSMS 22 and Copilot assistance.
* Analyze query performance using execution plans, SET STATISTICS IO, and AI-powered interpretation tools.
* Optimize queries through indexing strategies including clustered, non clustered,covering, and JSON indexes.
* Leverage SQL Server 2025 features including native JSON, Intelligent Query Processing, and Optimized Locking.
* Apply analytical query techniques using window functions, subqueries, and table expressions for complex reporting.
* Analyze query performance using execution plans, SET STATISTICS IO, and AI-powered interpretation tools.
* Optimize queries through indexing strategies including clustered, non clustered,covering, and JSON indexes.
* Leverage SQL Server 2025 features including native JSON, Intelligent Query Processing, and Optimized Locking.
* Apply analytical query techniques using window functions, subqueries, and table expressions for complex reporting.
Course Lessons