This is the sixth post (first, second, third, fourth, fifth) in another collection of posts that have links to the different objectives covered in the 70-433 exam.
Working with XML Data (12 percent)
- 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
- 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
You can also find some information on preparing for your exams here, in the actual exam for 70-433. Also errata for the MS Press training kit
No comments:
Post a Comment