Upon Request Courses

Using XML Databases and XQuery

This two-day course offers a custom-designed, hands-on approach to XML databases.

Dates & Times

Request

Call (518) 786-1181 or contact us for customized, individual or group training.

Course Outline

Corporate and NYS discounts do not apply for this course.

Based on the University at Albany’s Center for Technology in Government’s ten years of research and practice in the use of XML and MicroKnowledge’s 25 years of experience in delivering high-quality technical training.

Day One covers the basics needed to understand XML and relational data and how XML can be used as an alternative or supplement for your database needs. It will examine XML within non-relational databases (such as eXist) and relational databases (such as Oracle, SQL Server).

Day Two focuses on XQuery and how to gather the same type of information you would want from a relational database query. Learn to execute XQuery statements using FLWOR to pull the needed data from the XML database. Additional topics include summarizing data, using strings and dates, structuring XML output, and joining separate XML databases.

The course will give you a strong understanding of XML databases, along with hands-on experience in putting that knowledge to work in the “real world.” In addition, a comprehensive XQuery book, supplemental SQL/XML guide and all sample files will be provided to you on a flash drive as part of your registration and attendance.

This course builds upon our Introductory XML class, “Using XML for Website Management” and our SQL and Access classes. Students should have a basic understanding of XML and database concepts prior to taking this class.

Includes:
Comprehensive reference manual designed specifically for this class
Complimentary USB drive with included training files
Follow-up support by email or phone for an unlimited period

Day 1

Lesson 1: XML Review

  • What is XML?
  • Overview of XML technologies
  • How XML structures content

Lesson 2: Relational Databases and XML

  • Comparison of relational databases and XML
  • Overview of setup and use of XML
  • When to use

Lesson 3: XML Database

  • Creating an XML database
  • Working with collections
  • Modifying the XML database
  • Making the XML connection
  • Data entry in an XML database

Lesson 4: SQL/XML

  • Comparing SQL and Xquery
  • Converting relational databases to XML
  • Using SQL/XML functions
  • Transition to XQuery

Day 2

Lesson 5: XQuery

  • What is XQuery?
  • FLWOR
  • Basic XQuery statement

Lesson 6: Retrieving Data from an XML Database

  • Selecting records
  • Specifying columns
  • Creating well structured XML
  • Ordering information
  • Summarizing data
  • Wildcard Searches

Lesson 7: Using Strings and Dates

  • Working with strings
  • Working with dates

Lesson 8: Other Functions

  • Joining XML recordsets
  • Adding HTML tags to output

Software used during the class - Altova's XMLSpy.