Introduction to T-SQL

Target Audience

This course starts with the very basics through to intermediate and is aimed at anyone who has little to no experience with T-SQL.

Required Knowledge

No prior knowledge needed.

Purpose of the Course

The purpose of this course is to provide a firm grounding in T-SQL querying, leaving all attendees with a firm understanding of the structure of a T-SQL query and with the confidence to write good T-SQL code against their servers.

Topics Covered

Basic SQL Statements
Data Manipulation
Joins
Aggregation

Conditional Statements
Sub & Derived Queries
Window Functions
Data Access Objects

Course Modules

Module 1: What is SQL Server?

Brief History of MS SQL Server
Version Overview
Edition Summary
What is T-SQL?

Module 5: Aggregation

Group By
Having
Rollup
Cube
Pivot

Module 2: Basic T-SQL Commands

SELECT / FROM / WHERE
IN / LIKE / BETWEEN
ORDER BY
System Functions
String and Data Manipulation

Module 6: Conditional Logic

NullIf
Case Statement
If Statement
While

Module 3: Modifying Data

INSERT
UPDATE
DELETE
OUTPUT
INTO

Module 7: Sub & Derived Queries

Definitions
IN
EXISTS
NOT

Module 4: Joins

INNER / OUTER
Cartesian
APPLY
UNION
INTERSECT / EXCEPT

Module 8: Window Functions

Row Number
Ranking
Cumulative Aggregation
Offset

Module 9: Data Access Objects

Variables
Temporary Tables
Views
Stored Procedures
Functions

Book Course

Sign up for email alerts

Stay current with our latest insights