Database5
Querying Microsoft SQL Server
Duration
3 Days
Upcoming Batch
19 October 2026 - 21 October 2026
Batch Options
4 hours & 8 hours
Language
English/ Arabic
Querying Microsoft SQL Server
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 topics01Querying 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 batchesSession TypePhysical sessions run at our training facility.
| Batch Dates | Duration | Batch Options | Language | Action |
|---|---|---|---|---|
| 19 October 2026 - 21 October 2026 | 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 InformationFAQs
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.
Online Instructor-Led Training
Learn from the comfort of your workplace or at home through live virtual sessions led by expert trainers.
Learn moreHighlights
Classroom Training
Participate in interactive, face-to-face training in our top 5-star training facilities in Dubai.
Learn moreHighlights
Onsite Training
Learn a customised curriculum in your workplace to ensure the most impact and team participation.
Learn moreHighlights
Overseas Training
Participate in our international training sessions and improve your abilities with world-class instructors.
Learn moreHighlights
Related Courses
Other courses in the same category that might interest you.
Database9
55246-A: SQL 2016 AlwaysOn High Availability
View Course
Database10
Designing Database Solutions for Microsoft SQL Server 2014 from Microsoft
View Course
Database15