SQL 2014 Developer: Partitions, Queries and XML

Learn about SQL Server 2014 Developer along with data types and partitioning methods in this free online course.

Published by

Saved For Later

Confident you have the skills to certify without completing the course content?

Learning Outcomes

In this free course, you will learn how to:

Describe the techniques for the various versions of SQL Server
Discuss the native CLR data types found in the .NET framework
Explain the basis of data type precedence and how to deal with multinational data
Explain the actions required when data are stored as XML and index strategies for XML data
Define the key terms and syntax for defining a partition
Identify the many languages such as those used with Visual Studio and .NET
Recall the principles of using common table expressions and when to use CTEs and CTE syntax
Define the concept of working with complex queries and queries needed to extract data
Compare the differences between typed and untyped XML, and how to register and build schemes

Published by

Positive learner ratings

Learners Courses

Earn credentials that matter: Anyone can say they’re learning. A CPD-accredited Alison Certificate proves you followed through.
Get an edge over others: Add your Certificate to your CV, LinkedIn, and Alison Profile to strengthen job applications and promotion opportunities.
Show you’re serious about growth: A Certificate signals initiative, commitment, and a willingness to keep learning; qualities employers actively look for.