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 (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
  • 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

Subscribe

Start Watching

Corporate Licensing

Sample Content


 

Why ‘Transact-SQL Programming – 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.