• SQL
Training Course

SQL 2014 Developer P3: Partitions, Queries and XML

Browse All Courses > Databases

Have a question while you're learning?

Get in-depth explanations, tips, further insights, and more from Certified Experts. Our experts are vetted industry professionals eager to help you learn from their experiences.

Course Syllabus(49 Lessons)

SQL 2014 Developer P3: Partitions, Queries and XML - Module 01 - Partitions
Topic A: Partitioning - Part 1
3 lessons20m 06s
Topic C: Querying Partitions - Part 1
3 lessons14m 22s
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

Course Description

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.

Course Details

Level:
Beginner
Duration:
5h 09m 21s
Students:
15

Instructor

Frank Tillinghast
Frank TillinghastMicrosoft Certified Solution Developer

Share Course

  • LinkedIn

Ready to get started?

SEE HOW IT WORKS