SQL Server 2008 Database Development (70-433) Part 1

—Introduction 0m 54s
—The SELECT Statement 4m 36s
—The WHERE Clause 4m 1s
—Nested SELECT Statement 19m 29s
—The UPDATE and DELETE Statements 7m 48s
—The MERGE Statement 2m 49s
—MERGE Statement Demo 10m 51s
—The GROUP BY and HAVING Statements 7m 33s
—What We Covered 1m 29s

—Data Integrity 4m 29s
—Enforcing Data Integrity 7m 10s
—Primary Key Constraint Violation 2m 18s
—Selecting Two-Column Primary Key 6m 6s
—UNIQUE Constraints 7m 24s
—FOREIGN KEY Constraints 8m 58s
—CHECK Constraints 10m 5s
—CHECK Constraints Using GUI 2m 38s
—Constraints: Enabling and Disabling 1m 14s
—Triggers in SQL Server 2008 2m 35s
—DML Triggers 2m 15s
—Creating a Trigger 6m 20s
—Testing Triggers 4m 3s
—Constraints vs. Triggers 3m 15s
—Terminology 0m 54s
—What We Covered 0m 45s

—User-Defined Function Basics 15m 46s
—Creating User-Defined Function 2m 47s
—User-Defined Function Benefits 5m 33s
—Schema Binding 1m 50s

—Introduction 1m 12s
—Common Table Expressions 6m 54s
—Recursion Example 5m 32s
—Rank Functions - ROW_NUMBER Function 4m 41s
—Rank Functions - NTILE Function 13m 12s
—Other Rank Functions 3m 31s
—Built-In Functions 6m 40s
—Terminology 2m 39s

—Introduction 2m 4s
—Stored Procedure Basics 1m 15s
—Types of Stored Procedures 1m 28s
—Creating and Modifying a Simple Stored Procedure 5m 59s
—Benefits of Stored Procedures vs. Transact-SQL 4m 50s
—Creating a More Complicated Stored Procedure 9m 23s
—Modifying a More Complicated Stored Procedure 2m 25s
—Creating a Stored Procedure from a Template 1m 20s
—Stored Procedures vs. Functions 1m 48s
—Table Value Parameters 8m 8s
—Terminology 1m 10s
—What We Covered 1m 2s

—Introduction 1m 26s
—Syntax Errors 6m 58s
—Handling Database Engine Errors 11m 1s
—Retrieving Error Information 12m 54s
—Error Severity 1m 55s
—RAISERROR 10m 14s
—Creating a New Error Message 2m 15s
—sys.message Catalog View 1m 9s
—Transactions 11m 15s
—Using Debugger 8m 24s
—Terminology 0m 54s
—What We Covered 2m 16s