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