Learn how to use advanced Transact-SQL features to fetch and transform data in your databases.

This section covers the advanced SQL Server topics including views, index, stored procedures, user-defined functions,and triggers.

Feb 28, 2023 · In this article, we'll show 25 examples of advanced SQL queries from medium to high complexity. You can use them to refresh your knowledge of advanced SQL or to review …

Aug 21, 2024 · Mastering advanced T-SQL queries can significantly enhance your ability to manipulate and retrieve data efficiently. In this post, we'll explore some advanced T-SQL …

Sep 5, 2025 · Here are the 15 advanced SQL concepts that will help to transform your queries and enhance your database expertise: These concepts include advanced functions that …

Developed and delivered by Itzik Ben-Gan, the Advanced T-SQL course focuses on writing and tuning queries and programming with T-SQL in SQL Server and in Azure SQL Database.

Nov 25, 2015 · This is the first article in a new stairway series that will explore more advanced features of Transact SQL (TSQL).

Aug 12, 2025 · Advanced SQL uses complex queries, functions and joins to manage, transform and analyze data. It includes techniques like CTEs, recursive queries, window functions and …

Intensive course for SQL developers: Advanced Querying with T-SQL. Real-world examples, multiple solution methods, emphasis on optimal query writing. Enhance your skills and …

Developed in-house by Lucient, the Advanced T-SQL course focuses on writing and tuning queries and programming with T-SQL in SQL Server 2014, 2016, 2017, 2019, 2022 and in …