The relational database, such as SQL Server 2012, has been around for decades going back to E.F. Codd and his designs. Since then, many applications have been built upon this concept. In 1999, the internet was gaining momentum. Around the same time, a new hierarchical concept for storing data was introduced: eXtensible markup language or XML. As the internet gained more prominence to its current ubiquitous standing, XML took on increasing significance for moving data around. Subsequently, it became equally important for relational and hierarchical data to be somewhat interchangeable between online data-based applications and services. This course introduces XML in relation to SQL Server and how to work with XML data in SQL Server 2012. This course is one of a series in the Skillsoft learning path that covers the objectives for the Exam 70-464: Developing Microsoft SQL Server Databases. This series may also cover SQL Server 2014 features and functionalities as required by the exam objectives. This exam is one of the requirements for the MCSE: Data Platform certification path.
Learning Objectives
Storing XML Data
- describe the advantages of using XML data storage in SQL Server 2012
- identify how to work with XML data in a given scenario
- describe the characteristics of XML indexes in SQL Server 2012
Querying XML Data
- recognize how to query relational data as XML in SQL Server 2012
- recognize how to query XML data using XQuery() in SQL Server 2012
- describe how to shred XML data in SQL Server 2012
- store and query XML data in SQL Server 2012