55366 Querying Data with Transact-SQL

Introduction:

How many bad business decisions could be avoided if your data was accurate, timely, and easy to query? Nearly 82% of organizations admit to basing decisions on out-of-date data, leading to costly mistakes. The Querying Data with Transact-SQL training course builds the skills you need to work confidently with Microsoft SQL Server.

Through hands-on, instructor-led training, you’ll learn to query single and multiple tables, filter and sort results, join related data, use built-in functions, and work with stored procedures and transactions. You’ll also master subqueries, table expressions, aggregations, and error handling, ensuring you can retrieve and manage data accurately, securely, and efficiently.

Objectives:

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

Course Outline:

Module 1: Introduction to Transact-SQL

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

Module 2: Joining Tables

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

Module 3: Filtering and Sorting Results

ORDER BY clause
WHERE clause filtering
Limiting rows returned
NULL handling

Module 4: SQL Server Data Types

String and temporal data types
Data type usage best practices

Module 5: Inserting, Updating, and Deleting Data

Insert new records
Update existing data
Delete data safely

Module 6: Using SQL Server Functions

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

Module 7: Aggregating Data

Aggregation methods
GROUP BY and HAVING clauses
Filtering aggregated results

Module 8: Subqueries

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

Module 9: Table Expressions

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

Module 10: Combining Data Sets

UNION, INTERSECT, and EXCEPT
APPLY operator

Module 11: Window Functions

Understanding and implementing window functions

Module 12: PIVOT and Grouping Sets

Data pivoting
Grouping sets for advanced aggregations

Module 13: Stored Procedures

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

Module 14: Programming Features in T-SQL

Loops and conditions

Module 15: Error Handling

SQL Server error handling methods
Structured exception handling

Module 16: Transactions

Transaction concepts
Implementing transactions in T-SQL

Enroll in this course

$2,975.00 – $2,995.00

Select a start date for your 5 Days course

EventDates

2023-09-18 09:00:00_2023-09-22 17:00:00
2023-12-18 09:00:00_2023-12-22 17:00:00
2024-03-04 09:00:00_2024-03-08 17:00:00
2024-06-24 09:00:00_2024-06-28 17:00:00
2024-09-23 09:00:00_2024-09-27 17:00:00
2024-12-09 09:00:00_2024-12-13 17:00:00
2025-09-22 09:00:00_2025-09-26 17:00:00
2025-12-01 09:00:00_2025-12-05 17:00:00

Clear

Questions About This Course?

Need Help Finding The Right Training Solution?

Our training advisors are here for you.