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.