MCTS - Microsoft SQL Server 2008, Database Development - 70-433 - Objective List Part 6 (Working with XML Data)

• Retrieve relational data as XML
  
  • FOR Clause (Transact-SQL)
  • Using FOR XML and OPENXML to Publish and Process XML Data
  • Basic Syntax of the FOR XML Clause
  • Constructing XML Using FOR XML
  • Using RAW Mode
  • Using AUTO Mode
  • Using EXPLICIT Mode
  • Using PATH Mode
  • TYPE Directive in FOR XML Queries
  • Nested FOR XML Queries
  • Adding Namespaces Using WITH XMLNAMESPACES
  • WITH XMLNAMESPACES (Transact-SQL)
  • xml Data Type Methods
• Transform XML data into relational data
  
  • OPENXML
  • Using OPENXML
  • Querying XML Using OPENXML
  • Specifying Metaproperties in OPENXML
  • sp_xml_preparedocument (Transact-SQL)
  • sp_xml_removedocument (Transact-SQL)
• Query XML data
  
  • XQuery Language Reference
  • xml Data Type Methods
  • query() method
  • XQuery Basics
  • XQuery Expressions
  • Modules and Prologs (XQuery)
  • XQuery Functions against the xml Data Type
  • Additional Sample XQueries Against the xml Data Type
  • Examples of Bulk Importing and Exporting XML Documents
  • Sequence and QNames (XQuery)
  • Expression Context and Query Evaluation (XQuery)
  • Atomization (XQuery)
  • Effective Boolean Value (XQuery)
  • Type System (XQuery)
  • Error Handling (XQuery)
  • Comments in XQuery
  • XQuery and Static Typing
  • Primary Expressions (XQuery)
  • Path Expressions (XQuery)
  • Sequence Expressions (XQuery)
  • Arithmetic Expressions (XQuery)
  • Comparison Expressions (XQuery)
  • Logical Expressions (XQuery)
  • XML Construction (XQuery)
  • FLWOR Statement and Iteration (XQuery)
  • Ordered and Unordered Expressions (XQuery)
  • Conditional Expressions (XQuery)
  • Quantified Expressions (XQuery)
  • SequenceType Expressions (XQuery)
  • Validate Expressions (XQuery)
  • Introduction to Using XPath Queries (SQLXML 4.0)
  • Specifying a Location Path (SQLXML 4.0)
  • Sample XPath Queries (SQLXML 4.0)
  • XPath Data Types (SQLXML 4.0)
  • Specifying Axes in XPath Queries (SQLXML 4.0)
  • Specifying Arithmetic Operators in XPath Queries (SQLXML 4.0)
  • Specifying Relational Operators in XPath Queries (SQLXML 4.0)
  • Specifying Explicit Conversion Functions in XPath Queries (SQLXML 4.0)
  • Specifying Boolean Functions in XPath Queries (SQLXML 4.0)
  • Specifying XPath Variables in XPath Queries (SQLXML 4.0)
• Manage XML data
  
  • xml (Transact-SQL)
  • query() Method (xml Data Type)
  • value() Method (xml Data Type)
  • exist() Method (xml Data Type)
  • modify() Method (xml Data Type)
  • nodes() Method (xml Data Type)
  • Binding Relational Data Inside XML Data
  • Guidelines for Using xml Data Type Methods
  • Implementing XML in SQL Server
  • Typed XML Compared to Untyped XML
  • Indexes on XML Data Type Columns
  • Full-Text Index on an XML Column
  • Primary XML Index
  • Secondary XML Indexes
  • Creating XML Indexes
  • Modifying XML Indexes
  • Dropping XML Indexes
  • CREATE XML SCHEMA COLLECTION (Transact-SQL)
  • ALTER XML SCHEMA COLLECTION (Transact-SQL)
  • DDL for Managing XML Schema Collections in the Database
  • Permissions on an XML Schema Collection.
  • Viewing a Stored XML Schema Collection