SQL 2014 Developer: Partitions, Queries, XML
Learn about the advanced features of SQL Server 2014 Developer. Topics cover the fundamentals necessary to build, manage and maintain databases.
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
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.
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.
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.