Benefits

• 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

Outline

• 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

Required Prerequisites

• Basic understanding of relational databases.
• Basic Windows knowledge.