Querying Data with Transact-SQL 55366

Module 1Introduction to Transact-SQL

• What is Transact-SQL
• The SELECT statement
• The WHERE clause
• Sorting results
• Calculations and CASE expressions

Module 2Joining Tables

• The JOIN clause
• Inner, outer, self, and cross joins

Module 3Filtering and Sorting Results

• ORDER BY clause
• WHERE clause filtering
• Limiting rows returned
• NULL handling

Module 4SQL Server Data Types

• String and temporal data types
• Data type usage best practices

Module 5Inserting, Updating, and Deleting Data

• Insert new records
• Update existing data
• Delete data safely

Module 6Using SQL Server Functions

• Function types in SQL Server
• Data conversion functions
• Logical functions
• Handling NULLs

Module 7Aggregating Data

• Aggregation methods
• GROUP BY and HAVING clauses
• Filtering aggregated results

Module 8Subqueries

• Scalar, multi-valued, and correlated subqueries
• Using EXISTS with subqueries

Module 9Table Expressions

• Views
• Table-valued functions
• Derived tables
• Common table expressions (CTEs)

Module 10Combining Data Sets

• UNION, INTERSECT, and EXCEPT
• APPLY operator

Module 11Window Functions

• Understanding and implementing window functions

Module 12PIVOT and Grouping Sets

• Data pivoting
• Grouping sets for advanced aggregations

Module 13Stored Procedures

• Executing stored procedures
• Input/output parameters
• Creating simple procedures
• Using dynamic SQL

Module 14Programming Features in T-SQL

• Loops and conditions

Module 15Error Handling

• SQL Server error handling methods
• Structured exception handling

Module 16Transactions

• Transaction concepts
• Implementing transactions in T-SQL