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 (Yearly Subscription)

Best Deal: All-In-One Bundle Price (Fast-Track): $249 USD (Add all three Fast-Track Courses in the cart and apply code: HAPPY2021. It’s a STEAL. Limited Period Only. Yearly Subscription)

Subscribe

Start Watching

Corporate Licensing

 
 
 

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
  • TRUE, FALSE & UNKNOWN
  • 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

  • UNION
  • UNION ALL
  • INTERSECT
  • EXCEPT
  • 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

  • ROW_NUMBER
  • RANK
  • DENSE_RANK
  • NTILE
  • Caveats
  • Demos
  • Summary

Module 7: Aggregations

  • OVER Clause
  • Running Aggregations
  • CUBE and ROLLUP
  • Grouping Sets
  • Grouping_ID
  • Demos
  • Summary

Module 8: Pivoting

  • PIVOT
  • UNPIVOT
  • Demos
  • Summary

Module 9: Wrap Up

Subscribe

Start Watching

Corporate Licensing

Sample Content


 

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

Important Links

FAQs

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

Twitter

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.