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

Twitter

Facebook

YouTube

Our site uses cookies only to personalise content and analyse traffic. We do not use cookies for advertising. Policy