Every registration supports local education. TrainUp Gives Back
Logo

Your Career Training Marketplace

Questions? Call Toll-Free: 1-866-540-9677

  • Instant Access ImageInstant Access
    From Anywhere
  • Unlimited Viewing ImageUnlimited
    Viewing
  • calendar Image 6-12 Months
    To Complete

Description

XML has been integrated into SQL Server 2012 so that XML data can be stored within databases using the xml data type. SQL Server 2012 also allows for relational data already stored in a database to be changed to XML, and for data to be loaded as XML using various methods. You can query this data using the XQuery language within the XML data type methods. SQL Server 2012 also provides support for using FOR XML to extract relational data from a database in XML format and the use of OPENXML to generate relational views from XML. This course demonstrates how to use the xml data type, XML schema collations, and how to load XML data and how to create XML indexes. It also explores how to retrieve data using FOR XML, process XML data using OPENXML, and how to query data using the XQuery language. This course is one of a series in the SkillSoft learning path that covers the objectives for the exam 70-461: Microsoft SQL Server 2012: Querying. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

Learning Objectives
  • Describe the considerations involved in storing XML data directly within SQL Server 2012
  • Recognize how to implement XML data storage in SQL Server 2012
  • Describe the characteristics of indexes
  • Recognize how to handle XML data in different scenarios
  • Recognize how XPath is used
  • Recognize how to query XML data using XQuery
  • Recognize the modes that can be specified for a FOR XML clause
  • Distinguish between regular and nested XML queries
  • Retrieve and convert data using the OPENXML statement
  • Use SQL Server 2012's XML integration features
  • Recognize how to manage XML data in SQL Server 2012
  • Control how XML-related queries are returned
  • Audience

Get the latest industry news, recommended courses, & promotions from TrainUp.com sent straight to your inbox.