Transact SQL (T-SQL) Training in Dublin, Ireland

This course provides a comprehensive introduction to Transact-SQL (T-SQL), the proprietary extension of SQL used by Microsoft SQL Server. The training is ideal for database professionals, data analysts, and developers seeking to master the querying and programming capabilities of T-SQL. Participants will gain hands-on experience writing queries, managing data, and building stored procedures and functions to support real-world database applications.

T-SQL Fundamentals and Query Basics

• Introduction to SQL Server and T-SQL
• SQL Server architecture overview
• Tools for T-SQL (SSMS, Azure Data Studio)
• Writing Basic T-SQL Queries
• SELECT statements and syntax
• Filtering with WHERE clause
• Sorting and Aliasing
• Data Types and Expressions
• Built-in functions (String, Date, Numeric)
• NULL handling and expressions
• Hands-On Lab

Working with Joins, Aggregations, and Subqueries

• Querying Multiple Tables
• INNER, LEFT, RIGHT, FULL JOINs
• CROSS JOIN and SELF JOIN
• Combining Results with UNION, INTERSECT, EXCEPT
• Aggregation and Grouping
• GROUP BY and HAVING clauses
• Using Aggregate Functions (SUM, AVG, COUNT, etc.)
• Subqueries and Derived Tables
• Scalar and Correlated Subqueries
• Using CTEs (Common Table Expressions)
• Hands-On Lab

Programming Constructs, Transactions, and Stored Procedures

• Programming with T-SQL
• Variables and Control-of-Flow Statements (IF, WHILE, CASE)
• Error Handling (TRY...CATCH)
• Transactions and Concurrency
• BEGIN, COMMIT, ROLLBACK
• Isolation levels and locks overview
• Stored Procedures and User-Defined Functions
• Creating and executing procedures
• Input/output parameters
• Scalar and Table-valued Functions
• Hands-On Lab