This course is not scheduled. Inquire about Onsite training at your facility.
Overview
| Course code | CV120 | Skill level | Basic |
|---|---|---|---|
| Duration | 2.0 days | Delivery type | Classroom
(Hands-on labs) |
| Course type | Public or Private on-site | ||
| Public price | USD $1,340.00 plus tax |
This course is the classroom version of the Instructor Led On line (ILO) course 3V120
This course is designed to introduce you to non-traditional ways of using DB2 for z/OS to work with native Extensible Markup Language (XML) data.
You query XML data stored in DB2 tables and create XML documents from traditional DB2 data. You access XML documents as though the documents were relational tables. This class can be taken by users or other personnel who only need to access XML data stored in DB2 tables.
View this course in other countries
Training Paths that reference this course are:
Audience
This is a basic course for:
- Users
- Database administrators
- Anyone interested in learning how to retrieve native XML data in DB2 for z/OS.
Prerequisites
You should have
- at least: an introductory knowledge of XML, XML-related concepts, and DB2 concepts
- a working knowledge of SQL
Skills taught
After completing this course, you should be able to:
- Use XPATH to retrieve documents from an XML column
- Use SQL/XML retrieval, publishing, and shredding functions
- Use IBM Data Studio to understand how to build XML queries and queries that contain SQL/XML
Course outline
The topics presented in the course include:
XML basics review and lab
- Why XML?
- What is XML?
- Namespaces
- Document Type Definitions (DTD)
- XML schema
- Well-formed XML documents
- What is Extensible Stylesheet Language (XSL)?
- XML parsers: Document Object Model (DOM) and Simple Application Programming Interface for XML (SAX)
- XML standards and architectural overview
Introduction to XPath and lab
- Types of XML nodes
- XPath terminology
- Path expressions, predicates, and examples
- Data model highlights
- Path expressions
- Comparisons and logical operators
- Combining sequences
- Constructor functions
- Other expressions
- Namespaces
SQL/XML and lab
- Retrieving XML data
- Publishing XML data
- Shredding XML data
Advances queries and lab
- Use of arithmetic calculations
- Querying XML data in different tables (XML joins)
- Joining relational and XML data
- Passing of parameters
IBM Data Studio and lab
- Use Integrated Query Editor (IQE) to create XML queries (XMLQUERY) and queries containing SQL/XML