Introduction to T-SQL

Part Of The On-Demand Courses


  • How to write queries that involve multiple tables and summary queries
  • How to modify data and understand the logical programming aspects of T-SQL
This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

Course Description

This course is designed to get you developing with T-SQL very quickly. First, you will learn the structure of a SQL Server database, then you will dive into how to query the tables. Next, we will cover sorting and filtering the results.


Click here for a downloadable PDF



Module 00 | Getting Started
15m 49s total


Module 00A | Getting Started
15m 49s


Module 01 | Introduction to SQL Server Databases
24m 31s total


Module 01A | Introduction to SQL Server Databases/div>

24m 31s


Module 02 | SQL Server Management Studio (SSMS)
26m 09s total


Module 02A | SQL Server Management Studio (SSMS)
26m 09s


Module 03 | The SELECT Statement
40m 55s total


Module 03A | The SELECT Statement
40m 55s


Module 04 | Expressions
92m 54s total


Module 04A | Concatenating Columns
09m 56s


Module 04B | Mathematical Expressions
15m 37s


Module 04C | Other Functions
51m 54s


Module 04D | Working with NULLs, DISTINCT and TOP
16m 07s


Module 05 | Indexes
16m 52s total


Module 05A | Indexes
16m 52s


Module 06 | The WHERE Clause
30m 29s total


Module 06A | The WHERE Clause
30m 29s


Module 07 | Complex WHERE Clauses
27m 21s total


Module 07A | Complex WHERE Clauses
27m 21s


Module 08 | Using a Sub-Query to Filter Data
36m 41s total


Module 08A | Using a Sub-Query to Filter Data
36m 41s


Module 09 | Joining Tables
34m 18s total


Module 09A | Joining Tables
34m 18s


Module 10 | Outer Joins
33m 15s total


Module 10A | Outer Joins
33m 15s


Module 11 | Other Query Patterns
39m 36s total


Module 11A | Other Query Patterns
39m 36s


Module 12 | Aggregate Queries
26m 23s total


Module 12A | Aggregate Queries
26m 23s


Module 13 | Modifying Data
39m 34s total


Module 13A | Create Tables
05m 18s


11m 59s


Module 13C | UPDATE Statement
16m 37s


Module 13D | DELETE Statement
06m 20s


Module 14 | T-SQL Programming
32m 10s total


Module 14A | Variables
06m 24s


Module 14B | Conditional Logic
13m 09s


Module 14C | Looping
05m 31s


Module 14D | Stored Procedures
07m 46s



Training Content Manager

As a Training Content Manager, Consultant and Trainer with Pragmatic Works, Manuel uses his extensive knowledge of the BI Stack (SSRS, SSIS, SSAS etc.) to deliver exciting and engaging content. He also has experience with T-SQL, DAX, Power Platform and Azure Data Services. Manuel, however, is known for his impressive knowledge of the Microsoft Power BI tool. A native of Puerto Rico, He graduated from the University of Central Florida and loves being involved in the world of business intelligence. Manuel is a thought leader in the BI community.

System Requirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014
  • AdventureWorks2008R2 or AdventureWorks2012 databases installed on the instance
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance

What to Know Before Class

Previous SQL Server knowledge is not required. Ideally, students should be proficient using the Windows operating system and performing typical tasks like uploading or zipping files.


Manuel is incredible at breaking down the material to its most simple elements and explaining it so well that even a beginner SQL developer candidate can understand SQL programming. Thank you, Manuel...!!

Scott D.

Thank you so much. You are the best platform for learning resources there is :)

Yashvanth C.

Very good instructor, the pace was excellent, he made the subject matter interesting.


Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required