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

The SQL 2014 Developer P2: VS 2012 and Data Types course is the second 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 2 of this series are related to the Visual Studio 2012 and focuses on the data types available in SQL Server 2014. 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 P2: VS 2012 and Data Types 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 series comprises of three courses which combine to give a complete and comprehensive knowledge base to the students working with SQL Server 2014. Show and hide more

1. Chapter 01 - Aggregrate, UDT, TVF and Modules
   • Topic A: Aggregates - Part 1 00:01:02
   • Aggregates - Part 2A 00:10:18
   • Aggregates - Part 2B 00:15:13
   • Aggregates - Part 3 00:00:19
   • Topic B: User Defined Types - Part 1 00:01:05
   • User Defined Types - Part 2 00:15:03
   • User Defined Types - Part 3 00:00:33
   • Topic C: Table and Functions - Part 1 00:00:26
   • Table and Functions - Part 2 00:09:26
   • Table and Functions - Part 3 00:00:24
   • Topic D: Managing Code Modules - Part 1 00:00:16
   • Managing Code Modules - Part 2 00:07:16
   • Managing Code Modules - Part 3 00:00:24
2. Chapter 02 - Data Tools
   • Topic A: Introduction Data Tools - Part 1 00:00:56
   • Introduction Data Tools - Part 2 00:18:02
   • Introduction Data Tools - Part 3 00:00:22
   • Topic B: Connected Database Development - Part 1 00:01:08
   • Connected Database Development - Part 2 00:18:35
   • Connected Database Development - Part 3 00:00:12
   • Topic C: Updating a Connected Database - Part 1 00:00:34
   • Updating a Connected Database - Part 2 00:15:31
   • Updating a Connected Database - Part 3 00:00:19
3. Chapter 03 - Schemas and Offline Development
   • Topic A: Creating New Objects with TSQL - Part 1 00:00:42
   • Creating New Objects with TSQL - Part 2 00:10:51
   • Creating New Objects with TSQL - Part 3 00:00:36
   • Topic B: Comparing Database Schemas - Part 1 00:01:08
   • Comparing Database Schemas - Part 2 00:08:27
   • Comparing Database Schemas - Part 3 00:00:53
   • Topic C: Offline Database Development - Part 1 00:00:40
   • Offline Database Development - Part 2 00:12:28
   • Offline Database Development - Part 3 00:00:21
   • Topic D: Database Project Settings - Part 1 00:00:33
   • Database Project Settings - Part 2 00:17:13
   • Database Project Settings - Part 3 00:00:20
4. Chapter 04 - APPLY, MERGE and Grouping Sets
   • Topic A: Using APPLY - Part 1 00:01:01
   • Using APPLY - Part 2 00:13:05
   • Using APPLY - Part 3 00:00:37
   • Topic B: MERGE Statement - Part 1 00:00:39
   • MERGE Statement - Part 2A 00:12:03
   • MERGE Statement - Part 2B 00:10:05
   • MERGE Statement - Part 3 00:00:20
   • Topic C: Creating Recursive Queries - Part 1 00:00:46
   • Creating Recursive Queries - Part 2 00:06:23
   • Creating Recursive Queries - Part 3 00:00:21
   • Topic D: Grouping Sets - Part 1 00:00:35
   • Grouping Sets - Part 2 00:10:49
   • Grouping Sets - Part 3 00:00:16
5. Chapter 05 - ROLLUP, CUBE and Pivot Queries
   • Topic A: ROLLUP and CUBE Operators - Part 1 00:00:24
   • ROLLUP and CUBE Operators - Part 2 00:10:49
   • ROLLUP and CUBE Operators - Part 3 00:00:24
   • Topic B: Creating Pivot Queries - Part 1 00:00:41
   • Creating Pivot Queries - Part 2 00:13:14
   • Creating Pivot Queries - Part 3 00:00:22
   • Topic C: Executing Dynamic SQL - Part 1 00:00:52
   • Executing Dynamic SQL - Part 2A 00:10:29
   • Executing Dynamic SQL - Part 2B 00:16:20
   • Executing Dynamic SQL - Part 3 00:00:26
6. Chapter 06 - Query Execution
   • Topic A: Complex Query Execution - Part 1 00:01:47
   • Complex Query Execution - Part 2A 00:10:01
   • Complex Query Execution - Part 2B 00:13:38
   • Complex Query Execution - Part 3 00:00:19
   • Topic B: Using Execution Plans - Part 1 00:01:04
   • Using Execution Plans - Part 2 00:14:43
   • Using Execution Plans - Part 3 00:00:27
   • Topic C: Execution Plan Operators - Part 1 00:00:31
   • Execution Plan Operators - Part 2 00:10:56
   • Execution Plan Operators - Part 3 00:00:21
   • Topic D: Common Join Operators - Part 1 00:00:30
   • Common Join Operators - Part 2 00:14:11
   • Common Join Operators - Part 3 00:00:42
7. Chapter 07 - Hierarchy and Columns
   • Topic A: Hierarchy ID Data Type - Part 1 00:02:02
   • Hierarchy ID Data Type - Part 2 00:10:01
   • Hierarchy ID Data Type - Part 3 00:00:18
   • Topic B: Exploring a Hierarchy - Part 1 00:00:10
   • Exploring a Hierarchy - Part 2 00:08:04
   • Exploring a Hierarchy - Part 3 00:00:23
   • Topic C: Sparse Columns - Part 1 00:00:48
   • Sparse Columns - Part 2 00:14:15
   • Sparse Columns - Part 3 00:00:43
   • Topic D: Column Sets - Part 1 00:00:54
   • Column Sets - Part 2 00:10:29
   • Column Sets - Part 3 00:00:40
8. Chapter 08 - Filtered, Streams, Sequences
   • Topic A: Filtered Indexes - Part 1 00:01:30
   • Filtered Indexes - Part 2 00:07:24
   • Filtered Indexes - Part 3 00:00:22
   • Topic B: FILESTREAM Storage - Part 1 00:01:17
   • FILESTREAM Storage - Part 2 00:19:57
   • FILESTREAM Storage - Part 3 00:00:15
   • Topic C: Adding Sequences to Queries - Part 1 00:01:27
   • Adding Sequences to Queries - Part 2 00:20:14
   • Adding Sequences to Queries - Part 3 00:00:31
9. Chapter 09 - Spatial Data Types
   • Topic A: Introduction to Spatial Data - Part 1 00:00:55
   • Introduction to Spatial Data - Part 2 00:11:45
   • Introduction to Spatial Data - Part 3 00:00:29
   • Topic B: Spatial Data in SQL Server - Part 1 00:00:32
   • Spatial Data in SQL Server - Part 2A 00:12:29
   • Spatial Data in SQL Server - Part 2B 00:09:37
   • Spatial Data in SQL Server - Part 3 00:00:18
   • Topic C: Manipulating Spatial Shapes - Part 1 00:00:18
   • Manipulating Spatial Shapes - Part 2 00:08:58
   • Manipulating Spatial Shapes - Part 3 00:00:17
   • Topic D: Interactions Between Objects - Part 1 00:00:13
   • Interactions Between Objects - Part 2 00:07:54
   • Interactions Between Objects - Part 3 00:00:28
Show and hide more