Querying Microsoft SQL Server with Transact-SQL

Course Number: 55366AC
Days: 5
Price: $2,895.00

 

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.

 

Prerequisites

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 Topics

Module 1: Introduction to Transact-SQL
Module 2: Joining tables with Transact-SQL
Module 3: Filtering and sorting results
Module 4: SQL Server data types
Module 5: Inserting, updating and deleting data
Module 6: Using SQL Server functions with Transact-SQL
Module 7: Aggregating data with Transact-SQL
Module 8: Implement subqueries with Transact-SQL
Module 9: Create queries that use table expressions
Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data
Module 11: Implement window functions in queries
Module 12: Use PIVOT and grouping sets in queries
Module 13: Use stored procedures in queries
Module 14: Implement programming features in Transact-SQL
Module 15: Add error handling to queries
Module 16: Use transactions in queries