Intermediate Querying SQL Databases using T-SQL Training in Switzerland

Take your SQL querying expertise to the next level with this hands-on, expert-led course.
Designed for professionals who already understand basic T-SQL concepts, this program explores advanced querying techniques, optimization strategies, and real-world scenarios used in Microsoft SQL Server environments (from SQL Server 2005 through 2016).

Please note: This is not a beginner course.

Module 1: Using Table Expressions

• Creating and using Derived Tables

• Implementing Common Table Expressions (CTEs)

• Defining and managing Views

• Building Inline Table-Valued Functions

Module 2: Using Set Operators

• Combining datasets with UNION

• Comparing data with EXCEPT and INTERSECT

• Applying the APPLY operator for advanced joins

Module 3: Using Window Ranking, Offset, and Aggregate Functions

• Understanding the OVER clause

• Applying window functions: ROW_NUMBER, RANK, DENSE_RANK, NTILE

• Utilizing LAG, LEAD, FIRST_VALUE, LAST_VALUE

Module 4: Pivoting and Grouping Sets

• Transforming data with PIVOT and UNPIVOT

• Building multi-level summaries with GROUPING SETS, ROLLUP, and CUBE

Module 5: Programming with T-SQL

• Working with batches, variables, and control flow

• Implementing dynamic SQL and synonyms

• Understanding loops and conditional logic

Module 6: Implementing Error Handling

• Differentiating compile-time and run-time errors

• Managing errors with TRY/CATCH

• Using ERROR functions and the THROW statement

Module 7: Implementing Transactions

• Understanding ACID principles

• Controlling transactions with BEGIN, COMMIT, ROLLBACK

• Configuring isolation levels for concurrent environments