This practical, instructor-led training provides a comprehensive introduction to the Transact-SQL (T-SQL) language — the foundation of querying Microsoft SQL Server databases.
Throughout the course, you’ll learn how to retrieve, filter, sort, and analyze data from multiple tables and gain hands-on experience using SQL Server Management Studio (SSMS) to write efficient queries.

By the end of this course, you’ll have the core T-SQL skills required to extract valuable insights from your data and prepare for more advanced SQL training.

No prior SQL experience is required.

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

Prerequisites

Who Should Attend

This course is designed for:

IT professionals working with Microsoft SQL Server 2005–2016.
Non-technical “power users” seeking to understand how to query and analyze data.
Anyone who needs to extract, report, or interpret information using SQL Server.

Note: For virtual participants, a second monitor (19” minimum, 1280x1024 resolution) is required for lab work.

What You Will Learn

By the end of this training, you will have gained knowledge and skills in the following areas:

Access and navigate SQL Server Management Studio (SSMS).
Write simple to complex SELECT queries.
Retrieve data from multiple tables using JOIN clauses.
Apply filters using the WHERE clause and logical operators.
Sort and organize data using ORDER BY and TOP.
Summarize data with GROUP BY, HAVING, and aggregate functions.
Create and use Views and Stored Procedures.
Utilize text, date, and conversion functions for data manipulation.

Training Outline

Module 1: Introduction to T-SQL

Overview of Relational Database Management Systems (RDBMS)
Introduction to Microsoft SQL Server
Getting started with SQL Server Management Studio (SSMS)
Query Editor basics

Lab: Familiarizing yourself with SSMS and writing your first query

Module 2: Retrieving Data

Writing basic SELECT statements
Using expressions in query results

Lab: Selecting data and using expressions

Module 3: Filtering Rows

Using the WHERE clause to filter data
Applying equality, logical, string, and NULL comparisons

Lab: Practicing different types of filters

Module 4: Sorting Returned Rows

Managing output order with ORDER BY
Sorting with expressions
Using DISTINCT and TOP for unique and limited results

Lab: Sorting and limiting query results

Module 5: Grouping and Aggregating Data

Using aggregate functions (SUM, AVG, COUNT, etc.)
Grouping results with GROUP BY
Filtering groups with HAVING

Lab: Aggregating and grouping data

Module 6: Using Multiple Tables

Joining tables using INNER, OUTER, and CROSS JOIN
Combining result sets with UNION, INTERSECT, EXCEPT

Lab: Joining and merging data from multiple tables

Module 7: Using Views and Stored Procedures

Understanding pre-written queries and database objects
Creating and executing views and stored procedures

Lab: Working with stored queries

Module 8: Common Functions

Using text, date, and NULL functions
Formatting and converting data types

Lab: Applying SQL functions in queries

Appendix (Optional): Modifying Data

Introduction to INSERT, UPDATE, and DELETE statements (time permitting)

Why Choose Us

Experience Querying SQL Databases using T-SQL through Bilginç IT Academy's live and interactive virtual classroom environment, accessible from your home, office, or any location. Connect with expert trainers in real time and bring the energy of classroom learning into the digital experience.

Live Instructor-Led Sessions: Join scheduled training sessions with your instructor and fellow delegates in real time.
Interactive Learning Experience: Take part in discussions, practical exercises, group activities, and Q&A sessions throughout the course.
Expert Trainer Network: Learn from experienced trainers with strong industry backgrounds and practical field expertise.
Over 30 Years of Training Expertise: Benefit from Bilginç IT Academy's long-standing experience in delivering professional training since 1995.
Flexible and Scalable Delivery: Access live virtual classrooms worldwide with flexible planning options for individual and corporate training needs.

Experience Querying SQL Databases using T-SQL in a focused classroom environment designed for high engagement and effective learning. Bilginç IT Academy's carefully selected training venues provide a professional setting where delegates can interact directly with expert trainers and peers.

Experienced Trainers: Learn from specialists with extensive field experience and real-world knowledge.
Professional Training Venues: Attend courses in comfortable, well-equipped classrooms designed to support effective learning.
Focused Classroom Experience: Benefit from limited class sizes that encourage discussion, interaction, and personalized support.
Quality-Driven Learning: Develop practical skills through structured, up-to-date, and professionally designed training content.

Meet your team's training needs with Bilginç IT Academy's onsite Querying SQL Databases using T-SQL solution, delivered at your office or preferred location. Align your team's development with your business goals through a training experience tailored to your organization.

Tailored Course Content: Adapt the training program to your organization's projects, team structure, and specific business requirements.
Time and Cost Efficiency: Reduce travel, accommodation, and operational costs while maximizing the value of your training investment.
Team-Focused Learning: Help your employees develop around the same knowledge base and strengthen collaboration across your organization.
Simplified Planning and Tracking: Manage the training process, participant development, and organizational requirements with greater control.

O. Y. - İş Zekası danışmanı - Mercedes-Benz Türk A.Ş.

Rated the training 5 stars.

F. G. - Senior Data Analyst - Mercedes-Benz Türk A.Ş.

Rated the training 5 stars.

S. G. - İŞ ANALİSTİ - BURGAN BANK

Rated the training 5 stars.

İ. Ö. - Analist - BURGAN BANK

Rated the training 5 stars.

G. G. - Kart ve Kampanya Sorumlusu - BURGAN BANK

Rated the training 5 stars.

A. D. - Operasyon Yöneticisi - BURGAN BANK

Rated the training 5 stars.

D. K. - Web Mobil Geliştirme Sorumlusu - BURGAN BANK

Rated the training 5 stars.

A. Ç. - Hazine Is Gelistirme Yoneticisi - BURGAN BANK

Rated the training 5 stars.

D. K. - Stajyer - BURGAN BANK

Rated the training 5 stars.

A. Ö. - Özel Ve Bireysel Bankacılık Hazine Satış - BURGAN BANK

Rated the training 5 stars.

H. İ. K. - stajyer - BURGAN BANK

Rated the training 5 stars.

Y. S. - Veri Yönetimi - BURGAN BANK

Rated the training 5 stars.

R. B. - Expert Project Manager - Mercedes-Benz Türk A.Ş.

Rated the training 5 stars.

A. S. - Business Consultant - Mercedes-Benz Türk A.Ş.

Rated the training 5 stars.

Y. P. - Groupama Sigorta & Emeklilik

This was the highest quality training I've received recently. Thank you.

İ. L. - Groupama Sigorta & Emeklilik

Our instructor had excellent command of the subject, eloquence, and delivery skills.

İ. S. - KOCAELİ BÜYÜKŞEHİR BELEDİYESİ

I think it was a very successful training. I believe we learned concrete and useful information related to our own work. It was much better than I expected. The instructor was very good. They provided a great training without boring or tiring us.

İ. H. - Assan Bilişim A.Ş.

Thanks to Bilginç IT Academy and our instructor. It was a very good training. Thank you.

M. Ç. T. - Groupama Sigorta & Emeklilik

In particular, our instructor's ability to convey the subject matter to us was truly excellent. Their energy never waned until the end of the training, which had a positive effect on us. Thank you.

D. T. - Naturel Kozmetik (Yves Rocher)

Our instructor was extremely knowledgeable about the subject and had excellent communication skills. Their teaching style was very simple, easy to understand, and enjoyable. Thank you.

S. D. - Groupama Sigorta & Emeklilik

He was a very good instructor, thank you.

K. T. - Groupama Sigorta & Emeklilik

The instructor had a strong command of the subject matter and the class, explaining the topics in a fluent, engaging, and understandable manner. We thank them and wish them continued success.

C. G. - BEDAŞ | Boğaziçi Elektrik Dağıtım A.Ş

It was an excellent and instructive training session.

Y. K. - Groupama Sigorta & Emeklilik

The instructor was knowledgeable in their field and conveyed the subject with enthusiasm. Therefore, we were very satisfied. Thank you.

D. G. - Türk Ekonomi Bankası (TEB)

Your instructors were highly professional in their field. Congratulations.

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+

Querying SQL Databases using T-SQL Training

Prerequisites

Who Should Attend

What You Will Learn

Training Outline

Module 1: Introduction to T-SQL

Module 2: Retrieving Data

Module 3: Filtering Rows

Module 4: Sorting Returned Rows

Module 5: Grouping and Aggregating Data

Module 6: Using Multiple Tables

Module 7: Using Views and Stored Procedures

Module 8: Common Functions

Appendix (Optional): Modifying Data

Why Choose Us