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
- 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
- Introduction
- Temporary Tables
- Table Variables
- Temporary Tables vs Table Variables
- Tempdb Considerations
- Demos
- Introduction
- Limitations
- Modifying Data Through Views
- View Options
- Indexed Views
- Demos
- Introduction
- Types of SPs
- Advantages
- Best Practices
- Demos
- Introduction
- Uses & Benefits
- Types
- Limitations/Characteristics
- Stored Procedures vs UDFs
- Demos
- Introduction
- FOR or AFTER Triggers
- INSTEAD OF Triggers
- Special Tables
- Demos
- Introduction
- Use Cases
- Best Practices
- Demos
- Data Modification
- Concurrency Architecture
- Isolation Levels
- Concurrency Problems vs Isolation Levels
- Deadlocks
- Transactions
- Best Practices
- Demos
- TRY/CATCH Blocks
- XACT_ABORT
- Useful Techniques
- Demos
2. Introduction To T-SQL Programming
3. Table Variables & Temporary Tables
4. Views
5. Stored Procedures
6. User Defined Functions (UDF)
7. Triggers
8. Dynamic SQL
9. Transactions & Concurrency
10. Error Handling
11. Wrap Up
Note: This recorded class is available in the format of a video course. Content is presented in modular videos. Learn more.