SQLM_3


Transact-SQL Programming – Fast Track

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

Programming with Transact-SQL is an essential skill if you are developing applications for SQL Server, or even if you are just querying data from SQL Server. Irrespective of your role – Developer, Database Administrator, Data Architect, Data Analyst, Business Intelligence, Data Scientist, or just a power user – T-SQL programming skills are critical for you to be successful. This 15-hour video course gives you a strong foundational skill with T-SQL programming and loads of practical examples. You will learn about T-SQL language elements, logical flow, Query Optimizer, Execution Plans, Table Variables, Temporary Tables, Views, Stored Procedures, User Defined Functions, Triggers, Dynamic SQL, Transactions & Concurrency & Error Handling. 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 program with T-SQL.

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 Programming

    • Historical Information
    • Logical Flow of a SELECT Statement
    • T-SQL Language Elements
    • T-SQL Programmable Techniques/Objects
    • Query Optimizer Basics
    • Understanding Execution Plans
    • TRUE, FALSE & UNKNOWN
    • Demos

    3. Table Variables & Temporary Tables

    • Introduction
    • Temporary Tables
    • Table Variables
    • Temporary Tables vs Table Variables
    • Tempdb Considerations
    • Demos

    4. Views

    • Introduction
    • Limitations
    • Modifying Data Through Views
    • View Options
    • Indexed Views
    • Demos

    5. Stored Procedures

    • Introduction
    • Types of SPs
    • Advantages
    • Best Practices
    • Demos

    6. User Defined Functions (UDF)

    • Introduction
    • Uses & Benefits
    • Types
    • Limitations/Characteristics
    • Stored Procedures vs UDFs
    • Demos

    7. Triggers

    • Introduction
    • FOR or AFTER Triggers
    • INSTEAD OF Triggers
    • Special Tables
    • Demos

    8. Dynamic SQL

    • Introduction
    • Use Cases
    • Best Practices
    • Demos

    9. Transactions & Concurrency

    • Data Modification
    • Concurrency Architecture
    • Isolation Levels
    • Concurrency Problems vs Isolation Levels
    • Deadlocks
    • Transactions
    • Best Practices
    • Demos

    10. Error Handling

    • TRY/CATCH Blocks
    • XACT_ABORT
    • Useful Techniques
    • Demos

    11. Wrap Up

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