SQL 2014 Developer: Partitions, Queries, XML

This free online course on Microsoft SQL Server 2014 Developer covers the fundamental topics necessary to build, manage and maintain databases. The course takes learners through the processes needed to efficiently perform various management tasks on databases. You will also be introduced to the new and advanced features available. Start this course to update your SQL Server knowledge today.

What You Will Learn In This Free Course

Partitions

In this module, you will be introduced to the various concepts of partitioning. This module analyzes the challenges faced by database designers and compares techniques for the various SQL server. Also, it outlines the syntax for defining the partition function and explores catalogue view as well as some of the catalogue views available for retrieving partition information.

Complex Querying

In this module, you will be introduced to the concepts of complex querying and the functions used for ranking grouped data. This module also illustrates how to write correlated subqueries as well as analyzes the common table expression (CTE) and the terms used.

Coding Techniques

In this module, you will be introduced to the various concepts of coding techniques and the structure used for working with multiple data. This module also analysis the various ways to improve Queries, as well as simple processes used when working with complex queries.

Working with XML

In this module, you will be introduced to the concepts of working with the XML data type along with the XML schema collections. This module also illustrates the various ways data querying on XML are carried out as well as the best practices.

Course assessment