Course Title
Transact-SQL Programming - Fast Track
Module	Content Type		Duration (mm:ss:00)
Module 0: Introduction
	Lecture	Full Module	10:23:00
Before You Begin The Demos
	Lecture	Before You Begin The Demos	7:42:00
Module 1: Introduction To T-SQL Programming
	Lecture	Intro & Agenda	1:29:00
	Lecture	Historical Information	3:07:00
	Lecture	Logical Flow of a SELECT Statement	3:13:00
	Demos	Demos: Logical Flow of a SELECT Statement	12:01:00
	Lecture	T-SQL Language Elements T-SQL Programmable Techniques/Objects	5:24:00
	Lecture	Query Optimizer Basics Understanding Execution Plans	6:41:00
	Demos	Demos: Query Optimizer Basics Understanding Execution Plans	15:11:00
	Lecture	TRUE, FALSE & UNKNOWN Dealing With NULLs	3:20:00
	Demos	Demos: TRUE, FALSE & UNKNOWN (NULLs)	8:34:00
	Lecture	Summary	1:55:00
		Total Duration	60:55:00
Module 2: Table Variables & Temporary Tables
	Lecture	Intro & Agenda Introduction Temporary Tables Local Temporary Tables Global Temporary Tables	8:46:00
	Demos	Demos: Temporary Tables	13:24:00
	Lecture	Table Variables	3:00:00
	Demos	Demos: Table Tables	7:25:00
	Lecture	Temporary Tables vs Table Variables Tempdb Considerations Summary	4:04:00
		Total Duration	36:39:00
Module 3: Views
	Lecture	Intro & Agenda Introduction Limitation & Characteristics	5:41:00
	Demos	Demos: Views Introduction	12:27:00
	Lecture	Modifying Data Through Views	1:32:00
	Demos	Demos: Modifying Data Through Views	11:57:00
	Lecture	View Options	2:53:00
	Demos	Demos: View Options	9:10:00
	Lecture	Indexed Views	2:26:00
	Demos	Demos: Indexed Views	10:30:00
	Lecture	Summary	1:14:00
		Total Duration	57:50:00
Module 4: Stored Procedures
	Lecture	Intro & Agenda Introduction Types of Stored Procedures Advantages Best Practices	10:05:00
	Demos	Demos: Stored Procedures	16:08:00
	Lecture	Summary	0:56:00
		Total Duration	27:09:00
Module 5: User Defined Functions
	Lecture	Intro & Agenda Introduction Uses & Benefits Scalar Functions Table Valued Functions Inline Table Valued UDFs Multi-Statement Table Valued UDFs Limitations/Characteristics Stored Procedures vs UDFs	16:18:00
	Demos	Demos: Scalar Functions	20:14:00
	Demos	Demos: Table Valued Functions	16:56:00
	Lecture	Summary	1:03:00
		Total Duration	54:31:00
Module 6: Triggers
	Lecture	Intro & Agenda Introduction FOR or AFTER Triggers INSTEAD OF Triggers Special Tables	12:41:00
	Demos	Demos: Server Triggers Database Triggers LOGON Triggers	9:40:00
	Demos	Demos: Object Level Triggers	18:52:00
	Lecture	Summary	1:04:00
		Total Duration	42:17:00
Module 7: Dynamic SQL
	Lecture	Intro & Agenda Introduction Use Cases Best Practices	8:12:00
	Demos	Demos: Introduction to Dynamic SQL	20:27:00
	Demos	Demos: Use Cases of Dynamic SQL	15:34:00
	Demos	Demos: SQL Injection	13:27:00
	Lecture	Summary	0:49:00
		Total Duration	58:29:00
Module 8: Transactions & Concurrency
	Lecture	Intro & Agenda Data Modification Concurrency/Locking Architecture Isolation Levels Deadlocks Transactions Best Practices	31:23:00
	Demos	Demos: Dirty Reads Non-Repeatable Reads Phantom Reads Deadlocks	32:36:00
	Lecture	Summary	1:11:00
		Total Duration	65:10:00
Module 9: Error Handling
	Lecture	Intro & Agenda TRY/CATCH Blocks XACT_ABORT Useful Techniques	3:48:00
	Demos	Demos: Error Handling	11:43:00
	Lecture	Summary	0:54:00
		Total Duration	16:25:00
Module 10: Wrap Up
	Lecture	Full Module	2:46:00
		Total Course Duration (mm:ss:00)	440:16:00
		Total Course Duration: 7 hours 33 minutes
		Total Lecture Time: 2 hours 45 minutes
		Total Demo Time: 4 hours 35 minutes
		Yeah, demos are the real value