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

Why Choose Bilginç IT Academy

At Bilginç IT Academy, we combine our strong presence in both the UK and Türkiye to deliver high-quality, practical training solutions for organizations worldwide.

International Presence with Local Expertise
With operations in the United Kingdom and Türkiye, we bring together global standards and local market understanding to deliver effective training experiences across regions.

Expert Instructors with Real-World Experience
Our courses are delivered by certified trainers with extensive industry experience, ensuring you gain practical knowledge that can be applied immediately.

Corporate-Focused Training Approach
We specialize in training corporate teams, tailoring our programs to meet your organization’s goals, technologies, and project requirements.

Flexible Training Delivery Worldwide
We offer classroom, virtual classroom, and onsite training options globally, tailored to your organization’s needs.

Hands-On, Practical Learning
Our training sessions include real-world scenarios, case studies, and interactive exercises to ensure lasting understanding and skill development.

Proven Track Record
With over 10 years of experience, we have successfully trained professionals from leading organizations across different industries and regions.

Training Reviews

T. Y. D. - Sistem Analist
Architect Bilişim

Rated the training 5 stars.

Ş. A. - Yazılım Uzmanı
Architect Bilişim

Rated the training 5 stars.

G. B. - İş Analisti
Architect Bilişim

Rated the training 5 stars.

Ö. F. K. - Sistem Analisti
Architect Bilişim

Rated the training 5 stars.

H. G. - Sistem Analisti
Architect Bilişim

Rated the training 5 stars.

Why have you chosen us?

I have attended a training from Bilginc IT Academy before and I was satisfied.

I have attended a training from a different provider and it was not helpful.

Other

How many employees do you have in your IT department?

0 – 50

50 – 250

250 – 1000

1000+

Intermediate Querying SQL Databases using T-SQL Training in Germany

Prerequisites

Who Should Attend

What You Will Learn

Training Outline

Module 1: Using Table Expressions

Module 2: Using Set Operators

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

Module 4: Pivoting and Grouping Sets

Module 5: Programming with T-SQL

Module 6: Implementing Error Handling

Module 7: Implementing Transactions

Why Choose Bilginç IT Academy

Avaible Training Dates