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.

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. Join a Public course as an individual delegate or arrange a dedicated Private / In-house online training program exclusively for your organization.

Delivery Method: Online Instructor-Led
Participation Model: Public / Private (In-house)
Live and Interactive Training: Connect with your instructor in real time and actively participate through discussions, Q&A sessions, practical exercises, and group activities.
Flexible Participation: Join the training from your home, office, or any location with a suitable internet connection.
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 professional training experience since 1995.
Worldwide Access: Join our live virtual classrooms from anywhere in the world or arrange a dedicated online training program for your organization.

Experience Querying SQL Databases using T-SQL in a professional face-to-face classroom environment. Classroom Based training can be delivered as a Public course open to individual delegates or as a dedicated Private / In-house class exclusively for your organization.

Delivery Method: Classroom Based
Participation Model: Public / Private (In-house)
Face-to-Face Learning: Interact directly with your instructor and fellow delegates in an engaging classroom environment.
Experienced Trainers: Learn from specialists with extensive industry experience and practical real-world knowledge.
Professional Training Environment: Attend training in comfortable, well-equipped classrooms designed to support effective learning.
Practical Learning: Depending on the course, reinforce your knowledge through hands-on exercises, scenarios, case studies, and instructor-led activities.

Arrange Querying SQL Databases using T-SQL as a dedicated Onsite training program for your organization. Bilginç IT Academy trainers can deliver the training at your office or another location of your choice, with the program planned around your team's requirements and business objectives.

Delivery Method: Onsite
Participation Model: Private (In-house)
Training at Your Preferred Location: Organize the training at your company's office or another location selected by your organization.
Tailored Course Content: Adapt the training program to your projects, team structure, existing skill levels, and specific business requirements.
Team-Focused Learning: Develop your team around a shared knowledge base while strengthening internal collaboration and knowledge transfer.
Flexible Scheduling: Plan the training dates, location, and program according to your organization's operational requirements.
Worldwide Onsite Delivery: Bilginç IT Academy trainers can travel internationally to deliver dedicated training programs at your preferred location.

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. The language used was very simple, easy to understand, and very 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