SQL 2014 Developer P1: T-SQL and .NET Code

Course Curriculum

Chapter 1: Chapter 01 – Views

Lecture 1: Topic A: Introduction to Views – Part 1

Lecture 2: Introduction to Views – Part 2

Lecture 3: Introduction to Views – Part 3

Lecture 4: Topic B: Tools for Creating Views – Part 1

Lecture 5: Tools for Creating Views – Part 2

Lecture 6: Tools for Creating Views – Part 3

Lecture 7: Topic C: View Examples – Part 1

Lecture 8: View Examples – Part 2

Lecture 9: View Examples – Part 3

Lecture 10: Topic D: Updating Data Using a View – Part 1

Lecture 11: Updating Data Using a View – Part 2

Lecture 12: Updating Data Using a View – Part 3

Lecture 13: Topic E: Columns and Indexed Views – Part 1

Lecture 14: Columns and Indexed Views – Part 2

Lecture 15: Columns and Indexed Views – Part 3

Chapter 2: Chapter 02 – Stored Procedures

Lecture 1: Topic A: Introduction Stored Procedures – Part 1

Lecture 2: Introduction Stored Procedures – Part 2

Lecture 3: Introduction Stored Procedures – Part 3

Lecture 4: Topic B: Creating Stored Procedures – Part 1

Lecture 5: Creating Stored Procedures – Part 2

Lecture 6: Creating Stored Procedures – Part 3

Lecture 7: Topic C: Returning Data From – Part 1

Lecture 8: Returning Data From – Part 2

Lecture 9: Returning Data From – Part 3

Chapter 3: Chapter 03 – Stored Procedures Continued

Lecture 1: Topic A: Testing and Debugging – Part 1

Lecture 2: Testing and Debugging – Part 2

Lecture 3: Testing and Debugging – Part 3

Lecture 4: Topic B: Execute with Result Sets – Part 1

Lecture 5: Execute with Result Sets – Part 2

Lecture 6: Execute with Result Sets – Part 3

Lecture 7: Topic C: Creating Triggers – Part 1

Lecture 8: Creating Triggers – Part 2A

Lecture 9: Creating Triggers – Part 2B

Lecture 10: Creating Triggers – Part 3

Chapter 4: Chapter 04 – Functions

Lecture 1: Topic A: Overview and Scalar Functions – Part 1

Lecture 2: Overview and Scalar Functions – Part 2

Lecture 3: Overview and Scalar Functions – Part 3

Lecture 4: Topic B: Inline Table-Valued Functions – Part 1

Lecture 5: Inline Table-Valued Functions – Part 2

Lecture 6: Inline Table-Valued Functions – Part 3

Lecture 7: Topic C: Multi-Statement – Part 1

Lecture 8: Multi-Statement – Part 2

Lecture 9: Multi-Statement – Part 3

Lecture 10: Topic D: Views and Stored Procedures – Part 1

Lecture 11: Views and Stored Procedures – Part 2

Lecture 12: Views and Stored Procedures – Part 3

Chapter 5: Chapter 05 – Transactions

Lecture 1: Topic A: Transaction Concepts – Part 1

Lecture 2: Transaction Concepts – Part 2A

Lecture 3: Transaction Concepts – Part 2B

Lecture 4: Transaction Concepts – Part 3

Lecture 5: Topic B: Applications and Transactions – Part 1

Lecture 6: Applications and Transactions – Part 2

Lecture 7: Applications and Transactions – Part 3

Lecture 8: Topic C: Creating Explicit Transactions – Part 1

Lecture 9: Creating Explicit Transactions – Part 2A

Lecture 10: Creating Explicit Transactions – Part 2B

Lecture 11: Creating Explicit Transactions – Part 3

Lecture 12: Topic D: Structured Error Handling – Part 1

Lecture 13: Structured Error Handling – Part 2A

Lecture 14: Structured Error Handling – Part 2B

Lecture 15: Structured Error Handling – Part 3

Chapter 6: Chapter 06 – Common Language Runtime

Lecture 1: Topic A: Introduction to SQL CLR – Part 1

Lecture 2: Introduction to SQL CLR – Part 2

Lecture 3: Introduction to SQL CLR – Part 3

Lecture 4: Topic B: Writing SQL CLR Code – Part 1

Lecture 5: Writing SQL CLR Code – Part 2A

Lecture 6: Writing SQL CLR Code – Part 2B

Lecture 7: Writing SQL CLR Code – Part 3

Lecture 8: Topic C: Using SQL CLR Code – Part 1

Lecture 9: Using SQL CLR Code – Part 2A

Lecture 10: Using SQL CLR Code – Part 2B

Lecture 11: Using SQL CLR Code – Part 3

Lecture 12: Topic D: SQL CLR Code Modules – Part 1

Lecture 13: SQL CLR Code Modules – Part 2

Lecture 14: SQL CLR Code Modules – Part 3

Lecture 15: Topic E: SQL CLR Security – Part 1

Lecture 16: SQL CLR Security – Part 2

Lecture 17: SQL CLR Security – Part 3