SQLM_2


Transact-SQL Querying – Fast Track

Trainer(s): Amit Bansal
Provider: SQLMaestros
Duration: 6 Hours 40 Mins
Subtitles: No
Price: USD 149
Type: Video Course
Subscription Period: Lifetime Access

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.

Modules

    1. Introduction

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

    2. 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

    3. Joins

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

    4. Set Operators

    • UNION
    • UNION ALL
    • INTERSECT
    • EXCEPT
    • Caveats
    • Demos
    • Summary

    5. Subqueries

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

    6. Table Expressions

    • Derived Tables
    • Common Table Expressions
    • Demos
    • Summary

    7. Ranking Functions

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

    8. Aggregations

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

    9. Pivoting

    • PIVOT
    • UNPIVOT
    • Demos
    • Summary

    10. Wrap Up

Note: This recorded class is available in the format of a video course. Content is presented in modular videos. Learn more.