Transact-SQL Programming – Fast Track (Video Course)

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.

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: 7 hours 20 Mins

Total Lecture Time: 2 hrs 45 mins

Total Demo Time: 4 hrs 35 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
• Summary

Module 1: 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
• Summary

Module 2: Table Variables & Temporary Tables

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

Module 3: Views

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

Module 4: Stored Procedures

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

Module 5: User Defined Functions (UDF)

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

Module 6: Triggers

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

Module 7: Dynamic SQL

• Introduction
• Use Cases
• Best Practices
• Demos
• Summary

Module 8: Transactions & Concurrency

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

Module 9: Error Handling

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

Module 10: Wrap Up