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

The SQL 2014 Developer P3: Partitions, Queries and XML course is the third and last 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 3 of this series are related to the partitions, queries and XML. 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 P3: Partitions, Queries and XML 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 knowledgebase to the students working with SQL Server 2014. Show and hide more

1. Chapter 01 - Partitions
   • Topic A: Partitioning - Part 1 00:00:30
   • Partitioning - Part 2 00:19:13
   • Partitioning - Part 3 00:00:23
   • Topic B: Creating Partition Tables - Part 1 00:00:25
   • Creating Partition Tables - Part 2A 00:13:21
   • Creating Partition Tables - Part 2B 00:15:42
   • Creating Partition Tables - Part 3 00:00:26
   • Topic C: Querying Partitions - Part 1 00:00:17
   • Querying Partitions - Part 2 00:13:44
   • Querying Partitions - Part 3 00:00:22
   • Topic D: Managing Partitions - Part 1 00:00:18
   • Managing Partitions - Part 2 00:16:47
   • Managing Partitions - Part 3 00:00:17
2. Chapter 02 - Complex Querying
   • Topic A: Complex Querying - Part 1 00:00:21
   • Complex Querying - Part 2A 00:10:57
   • Complex Querying - Part 2B 00:10:36
   • Complex Querying - Part 3 00:00:21
   • Topic B: Rankings - Part 1 00:00:20
   • Rankings - Part 2 00:14:06
   • Rankings - Part 3 00:00:14
   • Topic C: SubQueries - Part 1 00:00:20
   • SubQueries - Part 2 00:20:22
   • SubQueries - Part 3 00:00:18
   • Topic D: Common Table Expressions - Part 1 00:00:27
   • Common Table Expressions - Part 2 00:16:32
   • Common Table Expressions - Part 3 00:00:15
3. Chapter 03 - Coding Techniques
   • Topic A: Complex Data and Structures - Part 1 00:00:20
   • Complex Data and Structures - Part 2A 00:11:30
   • Complex Data and Structures - Part 2B 00:13:21
   • Complex Data and Structures - Part 3 00:00:32
   • Topic B: Efficient Queries - Part 1 00:00:36
   • Efficient Queries - Part 2A 00:14:26
   • Efficient Queries - Part 2B 00:20:34
   • Efficient Queries - Part 3 00:00:53
   • Topic C: Complex Queries - Part 1 00:00:40
   • Complex Queries - Part 2 00:15:44
   • Complex Queries - Part 3 00:00:20
4. Chapter 04 - Working with XML
   • Topic A: XML Data Type - Part 1 00:00:33
   • XML Data Type - Part 2A 00:11:09
   • XML Data Type - Part 2B 00:16:00
   • XML Data Type - Part 3 00:00:34
   • Topic B: XML Schemas - Part 1 00:00:30
   • XML Schemas - Part 2 00:16:33
   • XML Schemas - Part 3 00:00:23
   • Topic C: Querying XML - Part 1 00:00:24
   • Querying XML - Part 2 00:19:21
   • Querying XML - Part 3 00:00:26
   • Topic D: Best Practices - Part 1 00:00:27
   • Best Practices - Part 2 00:06:35
   • Best Practices - Part 3 00:00:34
Show and hide more