MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Using XML and XQuery Effectively with SQL Server

Course Summary

This course covers SQL Server's integration with XML technologies including the XML data type, XQuery implementation, XML Schema support, and XML index performance considerations. It also covers different ways of integrating XML with related SQL Server fe

  • +

    Course Syllabus

    ● XML Intro - The XML Data Type
        ◦ Introduction
        ◦ Overview of XML Support in SQL Server
        ◦ Details of the XML Data Type
        ◦ XML-Specific Technologies Supported by SQL Server
        ◦ Summary
    ● XML Schema Support
        ◦ Introduction
        ◦ XML Schema Collections - Definition
        ◦ Defining and Using XML Schema Collections
        ◦ XML Schema Metadata, Storage, Retrieval
        ◦ XML Schema Collection Permissions
        ◦ XML Schema Support Limitations
        ◦ Versioning XML Schemas through Collections
        ◦ Summary
    ● XQuery Introduction
        ◦ Introduction - XQuery Input and Output
        ◦ XQuery Schema Support and Static Type Checking
        ◦ Sequences
        ◦ Parts of an XQuery Program
        ◦ XPath and FLWOR
        ◦ FLWOR - for and let
        ◦ FLWOR - constructors
        ◦ XQuery Functions and Operators. Summary
    ● XQuery: Using XQuery with XML data type methods
        ◦ Introduction. The xml.exist method
        ◦ The the xml.value method
        ◦ The xml.query method
        ◦ The xml.nodes method
        ◦ SQL Server internal use of XML
        ◦ The xml.modify method
        ◦ Summary
    ● XQuery Performance and XML Indexes
        ◦ Introduction
        ◦ XQuery processing in SQL query plans. Querying unindexed XML
        ◦ The primary XML index
        ◦ Secondary XML indexes
        ◦ XQuery performance tricks and tips
        ◦ Summary
    ● Hybrid Applications: Using XML and Relational Together
        ◦ Introduction
        ◦ Types of database data and XML usage
        ◦ Data type choice for large data in database applications
        ◦ Hybrid Applications - SELECT... FOR XML
        ◦ SELECT... FOR XML - SQL Server 2005 Enhancements
        ◦ Using OpenXML for decomposition
        ◦ Using SQLCLR with XML
        ◦ Using XQuery in conjunction with Full-Text Search
        ◦ XML Usage and SQL Server support for hybrid apps. Summary


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top