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)
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
Sample Content
Why ‘Transact-SQL Querying – Fast Track’ Video Course?
Important Links
FAQs | |
Corporate Subscription | |
Testimonials (Across The Globe) | |
Corporate Feedback | |
LinkedIn Recommendations | |
About Amit Bansal | |
Amit Bansal’s Profile | |
Why Amit Bansal? | |
Why Video Course | |
Terms of Use |
Social Media Links, Our Forums & Free Learning Resources
Free Videos | |
LinkedIn Page | |
LinkedIn Group | |
Facebook Page | |
Telegram Forum |
Other Learning Solutions
Hands-On-Labs Learning Solution | |
More Video Courses | |
Learning Kits | |
Electronic Books (PDFs) |
More Testimonials
Microsoft made a beautiful illustration of Amit Bansal’s original pic. Thanks Microsoft for all the encouragement.