Transact-SQL Querying – Fast Track (Video Course)

If you work with SQL Server, querying data using T-SQL is certainly an integral part of your work. Irrespective of your role – Developer, Database Administrator, Data Architect, Data Analyst, Business Intelligence, Data Scientist, or just a power user – T-SQL querying skills are critical for you to be successful. This video course gives you a strong foundational skill with T-SQL querying and loads of practical examples that you can start using right away. You will learn about T-SQL language elements, logical flow, Query Optimizer, all the types of logical and physical joins, apply operator, set operators, sub-queries, tables expressions, ranking functions, aggregations and pivoting. Yes, very comprehensive coverage in a fast-track mode, packed with loads of real-world demos. Along the way, you will learn about a few T-SQL enhancements in different versions of SQL Server. Wherever relevant, query tuning is discussed with examples. At the end of the course, you will be able to write accurate and performant T-SQL code.

Please note that from the website here, you can only make an individual subscription. For team/corporate subscription (for a group of people), please Click Here.
Read Terms of Use

Instructor: Amit R S Bansal

Total Duration: 6 hrs 40 Mins

Total Lecture Time: 2 hrs 10 mins

Total Demo Time: 4 hrs 30 mins (Yeah, demos are the real value)

Level: Intermediate to Advanced (Level 200 to 300)

Delivery Format: Video Course. Stream anywhere, anytime, any device, as many times.

Pre-Requisite: Just basic experience with SQL Server.

Course Outline & Duration Breakup – View Online | Download

Pricing, Discounts & Bundles

Regular Price: $499 USD (Yearly Subscription)

Discounted Price: $149 USD (Lifetime Access)

Best Deal: Get all three Fast-Track Courses in $249 USD (Add all three Fast-Track Courses in the cart and apply code: HAPPY2021. It’s a STEAL. Limited Period Only. Lifetime Access.)


Course Outline

Module 0: Introduction

  • Before You Begin
  • Modules
  • Demo Setup
  • What Not To Expect
  • What To Expect
  • How To Get The Best Out Of This Course

Module 1: Introduction To T-SQL Querying

  • Historical Information
  • Logical Flow of a SELECT Statement
  • T-SQL Language Elements
  • TOP Clause
  • Query Optimizer Basics
  • Understanding Execution Plans
  • Demos
  • Summary

Module 2: Joins

  • CROSS Join
  • INNER Join
  • OUTER Joins
  • Other Join Types
  • Physical Join Types
  • APPLY Operator
  • Demos
  • Summary

Module 3: Set Operators

  • Caveats
  • Demos
  • Summary

Module 4: Subqueries

  • Introduction
  • Types of Subqueries
  • Classification
  • Limitations / Side Effects
  • Demos
  • Summary

Module 5: Table Expressions

  • Derived Tables
  • Common Table Expressions
  • Demos
  • Summary

Module 6: Ranking Functions

  • RANK
  • Caveats
  • Demos
  • Summary

Module 7: Aggregations

  • OVER Clause
  • Running Aggregations
  • Grouping Sets
  • Grouping_ID
  • Demos
  • Summary

Module 8: Pivoting

  • Demos
  • Summary

Module 9: Wrap Up

Sample Content


Why ‘Transact-SQL Querying – Fast Track’ Video Course?

Important Links


Click Here

Corporate Subscription

Click Here

Testimonials (Across The Globe)

Click Here

Corporate Feedback

Click Here

LinkedIn Recommendations

Click Here

About Amit Bansal

Click Here

Amit Bansal’s Profile

Click Here

Why Amit Bansal?

Click Here

Why Video Course

Click Here

Terms of Use

Click Here


Social Media Links, Our Forums & Free Learning Resources

Free Videos

Click Here


Click Here

LinkedIn Page

Click Here

LinkedIn Group

Click Here

Facebook Page

Click Here

Telegram Forum

Click Here


Other Learning Solutions

Hands-On-Labs Learning Solution

Click Here

More Video Courses

Click Here

Learning Kits

Click Here

Electronic Books (PDFs)

Click Here


More Testimonials

T-SQL Querying Video Course

Microsoft made a beautiful illustration of Amit Bansal’s original pic. Thanks Microsoft for all the encouragement.