NEED HELP? TALK TO AN EXPERT (904) 638-5743

Introduction to T-SQL

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • 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

Outline

 

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

 

Module 13B | INSERT and SELECT INTO
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

Instructor

MANUEL QUINTANA

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.

REVIEWS

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.

Anonymous

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