Querying Microsoft SQL Server

4.8(45,337 Ratings)

Duration

3 Days

Upcoming Batch

19 October 2026 - 21 October 2026

Batch Options

4 hours & 8 hours

Language

English/ Arabic

Course Overview

55317A is the updated version of the retired legacy MOC course 20461. This three-day course teaches students how to use basic Transact-SQL statements and other languages to query modern editions of Microsoft SQL Server and Azure SQL Server. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development, and Business Intelligence. By using demonstrations and hands-on labs, attendees will learn to perform these tasks using SQL Server, Azure Data Studio, and other database tools.

Audience Profile

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. Report writers, business analysts, application developers, and SQL users who want to familiarize themselves with SQL Server will also benefit from this material..

At Course Completion

Query, sort, and filter data in database tables
Query external data sources
Query SQL Server and Azure SQL Server programmatically
Optimize query performance
Modify data using Transact-SQL
Work with XML and JSON formatted data
Use stored procedures and functions
Use SQL Server tools like SSMS and Azure Data Studio
Use Linked Servers
Use PolyBase

Course Content

6 modules · 19 topics

01Querying data with SQL Server Management Studio3 topics

Introduction to SSMS
SSMS querying options
Managing SSMS queries

02Querying data with Azure Data Studio3 topics

Introduction to Azure Data Studio
Azure Data Studio querying options
Managing Azure Data Studio queries

03Basic Transact-SQL Queries3 topics

Using the SELECT statement
Working with table columns
Working with table rows

04Advanced Transact-SQL Queries4 topics

Using Unions and Joins
Using Subqueries
Using Common Table Expressions (CTEs)
Grouping data

05Optimizing Query Performance3 topics

Identifying performance issues
Altering tables and queries
Using Indexes

06Modifying data with INSERT, UPDATE, and DELETE3 topics

Using INSERT
Using UPDATE
Using DELETE

Schedule Dates

4 upcoming batches

Session Type

Physical sessions run at our training facility.

Querying Microsoft SQL Server
Batch Dates	Duration	Batch Options	Language
19 October 2026 - 21 October 2026Next	3 Days	4 hours & 8 hours	English/ Arabic
25 January 2027 - 27 January 2027	3 Days	4 hours & 8 hours	English/ Arabic
26 April 2027 - 28 April 2027	3 Days	4 hours & 8 hours	English/ Arabic
26 July 2027 - 28 July 2027	3 Days	4 hours & 8 hours	English/ Arabic

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

Request More Information

FAQs

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

19 October 2026 - 21 October 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.