SQL 2014 Developer P3: Partitions, Queries and XML

Category
Databases
Level
Beginner
Lessons
49
Duration
5h 09m 00s
Last Updated: 2018-11-18
Prior to taking this course it is recommended you take part 1 and part 2:
SQL 2014 Developer P1: T-SQL and .NET Code
SQL 2014 Developer P2: VS 2012 and Data Types

When you start this course, you will develop an understanding of the architecture of tables and indexes within SQL 2014. You will review how they have changed to accommodate partitioning and gain an understanding of the tools you will need to move forward. You will go over partition boundaries and the practice of mapping partitions to file groups as well as the creation of partition tables.

After reviewing the basic creation of partitions, you will then develop an understanding of querying and managing partitions. You will address complex querying as well as correlated subqueries, where they are used, how they affect performance, and the appropriate times to replace them. We will then explore complex data, structures, and identify how we can implement efficient queries.

Lastly, we will be covering XML Data Type and the steps needed to ensure performance gains, with the proper use of XML indexes on XML columns. We will use this knowledge to address XML schemas, querying, and review the best practices when implementing partitions in SQL 2014.
ting partitions in SQL 2014.
Category
Databases
Level
Beginner
Lessons
49
Duration
5h 09m 00s
SQL 2014 Developer P3: Partitions, Queries and XML - Module 01 - Partitions
SQL 2014 Developer P3: Partitions, Queries and XML - Module 02 - Complex Querying
SQL 2014 Developer P3: Partitions, Queries and XML - Module 03 - Coding Techniques
SQL 2014 Developer P3: Partitions, Queries and XML - Module 04 - Working with XML
Frank Tillinghast
Frank TillinghastMicrosoft Certified Solution Developer