Why take this course?
After completing this course, you will be able to
- Understand how XML data is stored in DB2
- Retrieve and modify XML data using the XML-related built-in functions in DB2
- Access and update XML data in application programs
- Understand XPath expressions and how they can be used to access XML data in DB2
- Define XML indexes that facilitate data retrieval
- Understand how XML columns interact with DB2 utilities
- Manipulate XML columns using the LOAD utility, the UNLOAD utility, and file reference variables
- Understand and use XML schemas.
DB3010 Duration - 3 Days : Fee - $ 1,997.00 (CAD)
Audience
Application programmers, database administrators, systems administrators, and systems programmers who will be involved in developing, maintaining, or enhancing systems that will use XML in DB2Prerequisites
The student should be knowledgeable of the features of the DB2 Data BaseMajor topics covered
- XML data type
- XML catalog tables
- XML functions for building XML documents
- XML functions for accessing XML data
- XPath expressions and functions
- Working with XML data in application programs
- XML and file reference variables
- XML indexes and performance
- DB2 utilities and XML
- Using the UNLOAD utility with XML data
- Using the LOAD utility with XML data
- The DB2 XML schema repository
- Stored procedures for managing the schema repository