by Integrity Training | Released March 2019 | ISBN: 300000006A0169

The SQL 2014 Developer P1: T-SQL and .NET Code course is the first course in the three course series on SQL Server 2014. This series of courses is a comprehensive series covering all the intermediate to advanced level topics of SQL Server 2014. The topics covered in part 1 of this series are related to the Transact-SQL and .NET coding. The course covers the related sub-topics in a great detail and enables the students to implement the gained knowledge in their everyday tasks. The SQL 2014 Developer P1: T-SQL and .NET Code course covers the fundamental topics necessary to build, manage, and maintain databases in SQL Server 2014. The course enables the students to efficiently perform the management tasks on their databases and learn the new and advanced features available in SQL Server 2014. The course has two follow-up courses which combine to give a complete and comprehensive knowledgebase to the students working with SQL Server 2014. Show and hide more

1. Chapter 01 - Views
   • Topic A: Introduction to Views - Part 1 00:01:24
   • Introduction to Views - Part 2 00:14:03
   • Introduction to Views - Part 3 00:00:18
   • Topic B: Tools for Creating Views - Part 1 00:00:16
   • Tools for Creating Views - Part 2 00:10:04
   • Tools for Creating Views - Part 3 00:00:26
   • Topic C: View Examples - Part 1 00:00:15
   • View Examples - Part 2 00:19:59
   • View Examples - Part 3 00:00:29
   • Topic D: Updating Data Using a View - Part 1 00:00:41
   • Updating Data Using a View - Part 2 00:11:37
   • Updating Data Using a View - Part 3 00:00:38
   • Topic E: Columns and Indexed Views - Part 1 00:00:39
   • Columns and Indexed Views - Part 2 00:16:55
   • Columns and Indexed Views - Part 3 00:00:22
2. Chapter 02 - Stored Procedures
   • Topic A: Introduction Stored Procedures - Part 1 00:00:38
   • Introduction Stored Procedures - Part 2 00:17:03
   • Introduction Stored Procedures - Part 3 00:00:39
   • Topic B: Creating Stored Procedures - Part 1 00:00:27
   • Creating Stored Procedures - Part 2 00:18:37
   • Creating Stored Procedures - Part 3 00:00:25
   • Topic C: Returning Data From - Part 1 00:00:38
   • Returning Data From - Part 2 00:13:09
   • Returning Data From - Part 3 00:00:21
3. Chapter 03 - Stored Procedures Continued
   • Topic A: Testing and Debugging - Part 1 00:00:55
   • Testing and Debugging - Part 2 00:15:12
   • Testing and Debugging - Part 3 00:00:23
   • Topic B: Execute with Result Sets - Part 1 00:00:47
   • Execute with Result Sets - Part 2 00:09:28
   • Execute with Result Sets - Part 3 00:00:36
   • Topic C: Creating Triggers - Part 1 00:00:32
   • Creating Triggers - Part 2A 00:13:41
   • Creating Triggers - Part 2B 00:11:44
   • Creating Triggers - Part 3 00:00:33
4. Chapter 04 - Functions
   • Topic A: Overview and Scalar Functions - Part 1 00:00:34
   • Overview and Scalar Functions - Part 2 00:18:27
   • Overview and Scalar Functions - Part 3 00:00:47
   • Topic B: Inline Table-Valued Functions - Part 1 00:00:33
   • Inline Table-Valued Functions - Part 2 00:09:28
   • Inline Table-Valued Functions - Part 3 00:00:36
   • Topic C: Multi-Statement - Part 1 00:00:40
   • Multi-Statement - Part 2 00:14:18
   • Multi-Statement - Part 3 00:00:33
   • Topic D: Views and Stored Procedures - Part 1 00:00:26
   • Views and Stored Procedures - Part 2 00:17:42
   • Views and Stored Procedures - Part 3 00:00:18
5. Chapter 05 - Transactions
   • Topic A: Transaction Concepts - Part 1 00:01:25
   • Transaction Concepts - Part 2A 00:11:45
   • Transaction Concepts - Part 2B 00:16:16
   • Transaction Concepts - Part 3 00:00:48
   • Topic B: Applications and Transactions - Part 1 00:00:27
   • Applications and Transactions - Part 2 00:12:08
   • Applications and Transactions - Part 3 00:00:37
   • Topic C: Creating Explicit Transactions - Part 1 00:00:56
   • Creating Explicit Transactions - Part 2A 00:10:22
   • Creating Explicit Transactions - Part 2B 00:16:47
   • Creating Explicit Transactions - Part 3 00:00:25
   • Topic D: Structured Error Handling - Part 1 00:00:38
   • Structured Error Handling - Part 2A 00:10:47
   • Structured Error Handling - Part 2B 00:12:42
   • Structured Error Handling - Part 3 00:00:42
6. Chapter 06 - Common Language Runtime
   • Topic A: Introduction to SQL CLR - Part 1 00:00:58
   • Introduction to SQL CLR - Part 2 00:06:17
   • Introduction to SQL CLR - Part 3 00:00:17
   • Topic B: Writing SQL CLR Code - Part 1 00:01:09
   • Writing SQL CLR Code - Part 2A 00:10:34
   • Writing SQL CLR Code - Part 2B 00:11:07
   • Writing SQL CLR Code - Part 3 00:01:04
   • Topic C: Using SQL CLR Code - Part 1 00:00:19
   • Using SQL CLR Code - Part 2A 00:08:29
   • Using SQL CLR Code - Part 2B 00:12:24
   • Using SQL CLR Code - Part 3 00:00:26
   • Topic D: SQL CLR Code Modules - Part 1 00:00:20
   • SQL CLR Code Modules - Part 2 00:11:44
   • SQL CLR Code Modules - Part 3 00:00:36
   • Topic E: SQL CLR Security - Part 1 00:00:46
   • SQL CLR Security - Part 2 00:19:02
   • SQL CLR Security - Part 3 00:00:15
Show and hide more