Querying Microsoft SQL Server with Transact-SQL

4.6(45,336 Ratings)

Duration

5 Days

Upcoming Batch

16 November 2026 - 20 November 2026

Batch Options

4 hours & 8 hours

Language

English/ Arabic

Querying Microsoft SQL Server with Transact-SQL

This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.

About This Course

Audience Profile

This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and basic Windows navigation skills.

At Course Completion

Create single table SELECT queries
Create multiple table SELECT queries
Filter and sort data
Insert, update, and delete data
Query data using built-in functions
Create queries that aggregate data
Create subqueries
Create queries that use table expressions
Use UNION, INTERSECT, and EXCEPT on multiple sets of data
Implement window functions in queries
Use PIVOT and GROUPING SETS in queries
Use stored procedures in queries
Add error handling to queries
Use transactions in queries

Target Audience

Business Intelligence Specialists: BI specialists seeking to optimize data retrieval and reporting processes took the course for advanced T-SQL techniques.
System Administrators: Admins responsible for server maintenance attended to better manage SQL Server performance and security.
Project Managers: Managers overseeing data-centric projects participated to understand the technical aspects of SQL querying.
ERP Consultants: Consultants working with enterprise resource planning systems attended to enhance their ability to manage and query ERP databases.

Course Content

7 modules · 27 topics

01Introduction to Transact-SQL6 topics

What is Transact-SQL
The SELECT statement
The WHERE clause
Sorting results
Calculations
CASE expressions

02Joining tables with Transact-SQL4 topics

The JOIN clause
Inner joins
Outer joins
Self joins and cross joins

03Filtering and sorting results4 topics

Implement the ORDER BY clause
Filter data with the WHERE clause
Limit the number of rows returned by a query
Implement NULL logic

04SQL Server data types3 topics

Understand data types?
Implement string data types
Implement temporal data types

05Inserting, updating and deleting data3 topics

Insert new records
Update existing records
Delete data

06Using SQL Server functions with Transact-SQL4 topics

Understand function types in SQL Server
Convert data using functions
Implement logical functions
Work with NULL data using functions

07Aggregating data with Transact-SQL3 topics

Implement aggregation in SQL Server
Group records in SQL Server
Filter aggregated data

Schedule Dates

4 upcoming batches

Session Type

Physical sessions run at our training facility.

Querying Microsoft SQL Server with Transact-SQL
Batch Dates	Duration	Batch Options	Language
16 November 2026 - 20 November 2026Next	5 Days	4 hours & 8 hours	English/ Arabic
22 February 2027 - 26 February 2027	5 Days	4 hours & 8 hours	English/ Arabic
24 May 2027 - 28 May 2027	5 Days	4 hours & 8 hours	English/ Arabic
30 August 2027 - 03 September 2027	5 Days	4 hours & 8 hours	English/ Arabic

Can’t find a suitable date? Request a schedule that fits your team.

Request More Information

FAQs

What is the duration of the Querying Microsoft SQL Server with Transact-SQL course?

The duration of the course is typically 5 days. This includes intensive hands-on training and practical exercises to ensure comprehensive understanding and application of T-SQL

What are the prerequisites for enrolling in this course?

Participants should have a basic understanding of relational databases and SQL. Familiarity with Microsoft Windows operating system and its core functionality is also recommended.

Are there any exams involved in the course?

There may not be formal exams, but there will be practical assignments and assessments throughout the course to evaluate your understanding and application of the material.

What are the career benefits of completing this course?

Completing this course can open up various career opportunities such as Database Developer, Database Administrator, Data Analyst, and SQL Developer. It enhances your ability to manage and manipulate databases efficiently.

Where are the in-person classes held in Dubai?

In-person classes are usually held at dedicated training centers or corporate offices located in central business districts such as Dubai Internet City, Dubai Knowledge Village, or Business Bay. It’s best to check with the training provider for the exact location.

This course includes:

Soft copy of Courseware
Certificate of Course Completion
Experienced and Professional Trainer
Lab and Exercises During Training
Sample Questions for Exam Preparation
Mock Test on the Last Day of Training
Exam Registration Guidance
5-Star Training Environment

Upcoming Batch

16 November 2026 - 20 November 2026

View all batch dates

How We Deliver

Select the method that best suits your needs.

Online Instructor-Led Training Classroom Training Onsite Training Overseas Training

Request More Information

First Name *Please enter your first name.

Last Name

Email Address *Please enter a valid email address.

Phone Number *Please enter your phone number.

Country

Message

Your information is secure and never shared.

How We Deliver

Flexible Training Options to Meet Your Needs

Choose how you learn — live online, in-classroom, at your workplace, or internationally. CounselTrain delivers certified IT training across the UAE in the format that fits your team.

Select the method that best suits your needs.