55366AC SQL Server

Querying Microsoft SQL Server with Transact-SQL

Name: Querying Microsoft SQL Server with Transact-SQL
Price: 2995 CAD
Availability: InStock

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 Modules

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