This is an intermediate to advanced course in SQL Server querying using Transact-SQL. The training is focused on extending the fundamental querying skills by exploring more complex SQL scenarios, deeper data analysis techniques, and efficient query design. The main goal of the course is to develop practical skills in writing advanced queries using modern SQL constructs such as subqueries, derived tables, common table expressions (CTEs), windowing functions, and advanced filtering. The course emphasizes hands-on practice and instructor-led labs to reinforce concepts.

The primary audience of this class are professionals who already have basic experience with writing SQL queries and want to advance their T-SQL skills. This includes Data Analysts, BI Developers, Data Engineers, and experienced users of SQL Server who need to work with more complex datasets and querying logic.

The secondary audience includes database developers and administrators looking to optimize queries and structure data retrieval more efficiently through ranking, windowing, and subquerying techniques.

Prerequisites:

• Basic proficiency with SELECT, JOIN, WHERE, GROUP BY
• Understanding of relational databases and SQL syntax
• Familiarity with Microsoft SQL Server Management Studio (SSMS)
• Prior completion of a fundamentals-level SQL course or equivalent experience

• Write complex SELECT statements using nested logic and filtering
• Use advanced string, date/time, and conversion functions
• Apply GROUP BY with advanced expressions and HAVING filters
• Create and use subqueries, derived tables, CTEs, and views
• Apply windowing functions and ranking logic (ROW_NUMBER, RANK, DENSE_RANK, NTILE)
• Combine sets of data and use CASE expressions for conditional logic
• Build reusable logic patterns for advanced reporting and analytics

Module 1. Join, Group BY and Complex Filters – Fast Recall

Module 2. Complex Queries and Expressions

Module 3. Subqueries and Derived Tables

Module 4. Ranking and Windowing

Module 5. Review and Practice with Instructor