MOC 55366AC Querying Microsoft SQL Server with Transact-SQL

Course Description

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.

  • Basic understanding of relational databases.
  • Basic Windows knowledge.
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 have basic Windows navigation skills.

Course Summary

Next Public Course Dates

UK & Europe:

  • 2 - 6 October 2023
  • 16 - 20 October 2023
  • 4 - 8 December 2023

US & Canada:

  • 25 - 29 September 2023
  • 23 - 27 October 2023
  • 13 - 17 November 2023
  • None
  • 5 Days
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite
  • This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals.

Course Modules

  • Introduction to Transact-SQL
  • Joining tables with Transact-SQL
  • Filtering and sorting results
  • SQL Server data types
  • Inserting, updating and deleting data
  • Using SQL Server functions with Transact-SQL
  • Aggregating data with Transact-SQL
  • Implement subqueries with Transact-SQL
  • Create queries that use table expressions
  • Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data
  • Implement window functions in queries
  • Use PIVOT and grouping sets in queries
  • Use stored procedures in queries
  • Implement programming features in Transact-SQL
  • Add error handling to queries
  • Use transactions in queries

Upcoming Course Dates

UK & Europe:

US & Canada:

Book This Course

Other Training Areas of Interest

Get Notified of Upcoming Classes

Want to know when the next class will be offered? Sign up for notifications!

      To discuss your project requirements, send us a message

        For a free assessment, quick quote or training information, send us a message

          To book this course, please fill in your details and submit the form.

            To book this course, please fill in your details and submit the form.

              To discuss your training requirements or book a class, drop us a line