Intermediate Querying SQL Databases using T-SQL Training in Netherlands

  • Learn via: Classroom
  • Duration: 2 Days
  • Level: Expert
  • Price: From €2,286+VAT

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.

We can organize this training at your preferred date and location. Contact Us!

Prerequisites


Who Should Attend

This course is ideal for:

  • IT Professionals working with Microsoft SQL Server (2005–2016).

  • Technical users writing queries for reporting or data analysis.

  • Non-technical “power users” familiar with SQL Server Management Studio who wish to enhance their analytical skills.

Delegates joining via Extended Virtual Classroom will require a dual-monitor setup.

What You Will Learn

By the end of this two-day course, you will be able to:

  • Use table expressions (views, CTEs, and table-valued functions) effectively.

  • Compare datasets using set operators such as UNION, INTERSECT, and EXCEPT.

  • Implement window functions for ranking, aggregation, and offset analysis.

  • Apply PIVOT, UNPIVOT, and GROUPING SETS for multidimensional reporting.

  • Write advanced T-SQL programs with variables, conditionals, and loops.

  • Manage errors and transactions using TRY/CATCH and transaction control statements.

Training Outline

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

Training Reviews


Contact us for more detail about our trainings and for all other enquiries!

Avaible Training Dates

Join our public courses in our Netherlands facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

We can organize this training at your preferred date and location.
11 november 2025 (2 Days)
Amsterdam, Rotterdam
Classroom / Virtual Classroom
€2,286 +VAT
12 november 2025 (2 Days)
Amsterdam, Rotterdam
Classroom / Virtual Classroom
€2,286 +VAT
13 november 2025 (2 Days)
Amsterdam, Rotterdam
Classroom / Virtual Classroom
€2,286 +VAT
20 november 2025 (2 Days)
Amsterdam, Rotterdam
Classroom / Virtual Classroom
€2,286 +VAT
24 november 2025 (2 Days)
Amsterdam, Rotterdam
Classroom / Virtual Classroom
€2,286 +VAT
08 december 2025 (2 Days)
Amsterdam, Rotterdam
Classroom / Virtual Classroom
€2,286 +VAT
21 januari 2026 (2 Days)
Amsterdam, Rotterdam
Classroom / Virtual Classroom
€2,286 +VAT
26 maart 2026 (2 Days)
Amsterdam, Rotterdam
Classroom / Virtual Classroom
€2,286 +VAT
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.