-
Government of Canada Approved Supplier • CAITTS Standing Offer: E60ZH-140001/048/ZH • Book a Consultation
CONTACT US

55366 Querying Data 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.
Days 5
$3,295.00
Excl.HST
All Locations
All Categories
(GMT-05:00) Eastern Time (US & Canada)

Course Description

At Course Completion, you should be able to ? 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

Prerequisites

Students in this course should have the following knowledge: ? Basic understanding of relational databases. ? Basic Windows knowledge.

View/ Download course details

Download
Interested?

None of these dates work for you? 
Suggest another date and location!

Inquire

Related
Courses

Establish your skillset using vendor approved courses, and earn the certifications you need.
GET IN TOUCH

We would love to 
hear from you!

We’re here to make learning easy and enjoyable. Our dedicated training consultant is ready to guide you through a comprehensive solution tailored to your needs.

SEARCH

Sign Up for Our Newsletter!