Take this
course

Test Prep / Software Exams

SQL Server 2012 (70-464): Storing and Querying XML Data in SQL Server

XML provides rules for encoding documents in a machine-readable format. XML is being used extensively to interchange structured documents between systems. XML stands for Extensible Markup Languages. It is a plain-text, Unicode-based metalanguage. XML helps to store and query data and this relieves us of shredding XML data into the SQL Server format. This course will offer an in depth look at storing and querying XML data in SQL Server.

Description

XML provides rules for encoding documents in a machine-readable format. XML is being used extensively to interchange structured documents between systems. XML stands for Extensible Markup Languages. It is a plain-text, Unicode-based metalanguage. XML helps to store and query data and this relieves us of shredding XML data into the SQL Server format. This "Storing and Querying XML Data in SQL Server" LearnSmart course will offer an in depth look at storing and querying XML data in SQL Server. It will be paired with demos that offer a real world look at the concepts that will be discussed, as well as being paired with knowledge checks that will help test your knowledge of the material covered throughout the course.


Topics Covered Include:
-Storing XML Data in SQL Server
-Querying XML Data in SQL Server

Full details

Curriculum

  • Course Orientation
    Course Orientation
    1:54
    Storing and Querying XML Data in SQL Server: Supplemental Materials
    "Take advantage of all our extra downloadable supplemental materials. This .zip file includes PDF versions of our Script, PPT Slides, Quiz Questions, and vocabulary tools to better enhance your understanding for this ""SQL Server 2012 (70-464): Storing and Querying XML Data in SQL Server"" Course."
  • Storing XML Data in SQL Server
    Course Introduction
    0:47
    XML
    2:16
    XML and Schemas
    2:31
    XML Data Storage and Schemas
    3:14
    SHOW ME Demonstration: Creating XML Schema Collection
    2:56
    Storing XML Data and Schemas
    3:22
    Implementing SQL Indexes
    3:20
    SHOW ME Demonstration: Implementing XML Indexes
    1:49
    Knowledge Check
    0:35
  • Querying XML Data in SQL Server
    Querying XML Data
    3:46
    SHOW ME Demonstration: Using FOR XML Queries
    1:58
    XQuery and WQuery Methods
    3:14
    SHOW ME Demonstration: Using XQuery Methods in a DDL Trigger
    1:37
    Shredding XML
    1:52
    SHOW ME Demonstration: Shredding XML
    1:56
    Best Practices
    1:08
    Knowledge Check
    0:45
    Conclusion
    1:17

Skills

  • Database Management
  • Database Management System (DBMS)
  • SQL Server

Similar Courses

More Courses by this Instructor