Enable Technology


Transact SQL

Course Overview

In this two day intensive course you will learn how to create queries to retrieve, add, update, and report from your SQL Server database. You will sort and aggregate data, use built-in functions, create stored procedures, subqueries, table operators, set operators, conditional operators, views, indexes, and explore SQL Server error handling features.

The course is particularly suitable for Data Analysts or candidates involved in retrieving and reporting business and management information. No prior SQL knowledge is assumed.

Duration: 2 day course

Course Content

Getting Started with SQL Server 2012
Overview of SQL Server
Work with SSMS

Working with T-SQL
Overview of T-SQL
Work with T-SQL Statements
Manage SQL Server Constraints

Writing SELECT Queries
Write SELECT Statements
Assign Aliases Using Queries
Write CASE Expressions

Working with SQL Data Types
Work with String and Numeric Data Types
Work with Date and Time Data Types
Work with Binary Data Types
Work with the XML Data Type

Sorting and Filtering Data
Sort the Queried Data
Filter the Queried Results
Work with Predicates
Perform Advanced Filtering

Querying Data from Multiple Tables
Combine Data Using Simple Joins
Create Queries Using Join Algorithms
Modifying Data
Insert Data
Update Data
Delete Data
Merge Data

Working with SQL Server Built-in Functions
Create Queries Using Built-in Functions
Create Queries to Test Nullability
Group and Aggregate Data

Programming in T-SQL
Work with Variables and Batches
Control Program Flow
Manage Triggers
Work with Data Access Technologies

Implementing Stored Procedures
Manage Stored Procedures
Work with Dynamic SQL

Working with Subqueries and Table Expressions
Work with Subqueries
Work with Table Expressions

Working with Set Operators, Conditional Operators, and Window Functions
Work with Set Operators
Work with Window Functions
Configure User-Defined Functions (UDF)
Work with Advanced Functions

Working with PIVOT, UNPIVOT, and Grouping Sets
Work with PIVOT and UNPIVOT
Work with Grouping Sets

Managing Error Handling and Transactions
Implement Error Handling
Manage Transactions

Querying SQL Server System Metadata
Work with System Databases
Work with SSPs and SMOs
Work with System Catalog Views

Optimizing Query Performance
Manage Query Plans
Configure Indexes
Manage Views
Analyze Data from Query Plans

Email us about this courses

Telephone on 01952 938014