This course currently has no scheduled classes. Call 1-800-IBM-TEACh (1-800-426-8322) for information about enrolling.
|Course code||3L131CE||Skill level||Intermediate|
|Duration||5.0 days||Delivery type||Instructor Led - Online Training
|Course type||Public only|
|Public price||CAD $3,575.00 plus tax|
This is an online course. Please do not make travel arrangements for this course.
After you receive confirmation that you are enrolled, you will be sent further instructions to access audio, video and remote labs.
This course is designed to introduce you to non-traditional ways of using DB2 to work with native XML data. It is also designed to enable database administrators to manage the DB2 - native XML environment.
You will query XML data stored in DB2 tables and create XML documents from traditional DB2 data. You will also access XML documents as though the documents were relational tables. This content is addressed in the first three days of class and can be taken by users or other personnel who only need to access XML data stored in DB2 tables.
In the last two days of class, you will store native XML data in DB2 and create XML indexes. You will analyze plan information for queries and take steps for improving query execution. The course also teaches how to manage the XML schemas and the techniques available for decomposing the XML documents.
The course can be taken as two separate parts Query XML data with DB2 9 - Instructor Led Online (3L121) or Manage XML data with DB2 9 - Instructor Led Online (3L141), but the first part is required and presumed for the second part. In both parts, IBM Optim Development Studio is used as a GUI environment after you learned how to handle the same actions through the basic commands.
The course materials address DB2 9.7 for Linux, UNIX, and Windows.
This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education.
Training Paths referencing this course are:
You should have:
It would be helpful to have an introductory knowledge of XML, XML-related concepts - but the course is designed not to assume any prior knowledge of XML and related matters.
Introduction to XPath
Introduction to XQuery
Updating and Transforming XML Documents
Introduction to Programming with XML
IBM Optim Development Studio and XML Queries
Compression for XML Data and XML Indexes
Optimization and performance
XML schema management
Optim Development Studio and XML Schemas
Partitioning and Clustering with XML Data