Description
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.
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
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
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
Module 2: Table Variables & Temporary Tables
- Introduction
- Temporary Tables
- Table Variables
- Temporary Tables vs Table Variables
- Tempdb Considerations
- Demos
Module 3: Views
- Introduction
- Limitations
- Modifying Data Through Views
- View Options
- Indexed Views
- Demos
Module 4: Stored Procedures
- Introduction
- Types of SPs
- Advantages
- Best Practices
- Demos
Module 5: User Defined Functions (UDF)
- Introduction
- Uses & Benefits
- Types
- Limitations/Characteristics
- Stored Procedures vs UDFs
- Demos
Module 6: Triggers
- Introduction
- FOR or AFTER Triggers
- INSTEAD OF Triggers
- Special Tables
- Demos
Module 7: Dynamic SQL
- Introduction
- Use Cases
- Best Practices
- Demos
Module 8: Transactions & Concurrency
- Data Modification
- Concurrency Architecture
- Isolation Levels
- Concurrency Problems vs Isolation Levels
- Deadlocks
- Transactions
- Best Practices
- Demos
Module 9: Error Handling
- TRY/CATCH Blocks
- XACT_ABORT
- Useful Techniques
- Demos
Module 10: Wrap Up
Reviews
There are no reviews yet.