Data Private Public

Querying Microsoft SQL Server with Transact-SQL (55366AC)

5 days
Microsoft SQL ServerMicrosoftDataSQL

Learn to query, modify, aggregate, and manage Microsoft SQL Server data with Transact-SQL, including joins, subqueries, functions, and transactions safely.

Talk to a Learning ConsultantRegister for a Public ClassRequest a Private Class

Register or Request Training

Price per student
$2,935.10
Guaranteed to run
Select a date
Please select a class.
Interested in a private class? Click Here
  • Private class for your team
  • Live expert instructor
  • Online or on‑location
  • Customizable agenda
  • Proposal responses same day as request
Request Proposal

Course Overview

Build practical skills for querying and managing data with Transact-SQL in Microsoft SQL Server. Through instructor-led training, you will learn to retrieve, filter, sort, combine, modify, and aggregate data using effective T-SQL queries.

The course also covers subqueries, table expressions, window functions, stored procedures, programming logic, error handling, and transactions. It is designed for novice database developers, database administrators, business intelligence developers, report creators, and application developers.

Course Benefits

  • Write single-table and multi-table SELECT queries.
  • Filter, sort, and limit query results.
  • Combine related data with joins, subqueries, table expressions, and set operators.
  • Insert, update, and delete SQL Server data.
  • Use built-in, aggregate, and window functions to transform and analyze data.
  • Apply GROUP BY, HAVING, PIVOT, and grouping sets.
  • Create and execute stored procedures with parameters and dynamic SQL.
  • Use loops and conditional logic in T-SQL.
  • Implement structured error handling and transactions for reliable query execution.

Delivery Methods

Public Class
Live expert-led online training from anywhere. Guaranteed to run .
Private Class
Delivered for your team at your site or online.

Course Outline

  1. Introduction to Transact-SQL
    1. What Transact-SQL is
    2. The SELECT statement
    3. The WHERE clause
    4. Sorting results
    5. Calculations and CASE expressions
  2. Joining Tables
    1. The JOIN clause
    2. Inner, outer, self, and cross joins
  3. Filtering and Sorting Results
    1. The ORDER BY clause
    2. Filtering with the WHERE clause
    3. Limiting rows returned
    4. Handling NULL values
  4. SQL Server Data Types
    1. String and temporal data types
    2. Data type usage best practices
  5. Inserting, Updating, and Deleting Data
    1. Inserting new records
    2. Updating existing data
    3. Deleting data safely
  6. Using SQL Server Functions
    1. Function types in SQL Server
    2. Data conversion functions
    3. Logical functions
    4. Handling NULL values
  7. Aggregating Data
    1. Aggregation methods
    2. GROUP BY and HAVING clauses
    3. Filtering aggregated results
  8. Subqueries
    1. Scalar, multivalued, and correlated subqueries
    2. Using EXISTS with subqueries
  9. Table Expressions
    1. Views
    2. Table-valued functions
    3. Derived tables
    4. Common table expressions
  10. Combining Data Sets
    1. UNION, INTERSECT, and EXCEPT
    2. The APPLY operator
  11. Window Functions
    1. Understanding and implementing window functions
  12. PIVOT and Grouping Sets
    1. Data pivoting
    2. Grouping sets for advanced aggregations
  13. Stored Procedures
    1. Executing stored procedures
    2. Input and output parameters
    3. Creating simple procedures
    4. Using dynamic SQL
  14. Programming Features in T-SQL
    1. Loops and conditions
  15. Error Handling
    1. SQL Server error-handling methods
    2. Structured exception handling
  16. Transactions
    1. Transaction concepts
    2. Implementing transactions in T-SQL

Class Materials

Each student receives a comprehensive set of materials, including course notes and all class examples.

Class Prerequisites

Experience in the following is required for this Microsoft SQL Server class:

  • Basic understanding of relational database concepts.
  • Basic Windows navigation skills.

Prerequisite Courses

Courses that can help you meet these prerequisites:

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.

Talk to a Learning Consultant