Course description: DB2 for LUW pureXML

Note: This is a self-paced online course. This course usually requires 20 hours to complete. Once you receive your access information, you will have access to this course for 1 year.

DB2 9 is the next-generation hybrid data server with optimized management of both XML and relational data. This DB2 9 pureXML workshop guides you through the essential XML features of DB2 9 that enable information as a service. This workshop provides a quick primer on XML fundamentals before diving into how XML is handled by DB2 9. Topics covered include: XML Business Motivation, XML Basics, XML Storage, XQuery, SQL/XML, XML Indexing, Performance and Optimization, XML Schema Management, Decomposition, Full-text Search, and the Developer Workbench.

This innovative self-paced online format is available from IBM Training and gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. Once you have accessed the course, instructor help is available via the course forum Monday through Friday; questions will be responded to within 24 hours. The course is available 24 hours a day

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 the course materials.

View this course in other countries

Training Paths that reference this course are:

• XML

Back to top

IBM Education Advantage Program eligibility:

• Yes - IBM Education Pack - online account

Back to top

Anyone who needs an introduction to the XML capabilities implemented in DB2 9

Back to top

Knowledge of relational database concepts

Back to top

• Describe various uses for XML technologies
• Describe how XML data is stored and referenced in DB2 9
• Use the XQuery language
• Use the SQL/XML language
• Create indexes on XML data
• Optimize the performance of XML queries
• Use XML schemas to validate and decompose XML documents
• Perform full-text searches on XML data
• Use the DB2 Developer Workbench

Back to top

Motivation for Using XML

• Identify various uses for XML
• Describe some of the standards and protocols that use XML
• Differentiate between XML storage methods used traditionally and those used in DB2 9
• Describe the native XML data server innovation by IBM
• Explain the DB2 9 architecture
• Rank the performance of DB2 9 and earlier relational databases

XML Basics

• Describe XML and its uses
• Explain how XML data can be represented
• Create well-formed XML documents
• Use XML namespaces
• Identify the results of XPath and XQuery statements
• Describe SQL/XML and XSL
• Describe the use of XML schemas
• Compare the two major XML parsers, DOM and SAX

XML Storage

• Describe how XML data is stored in DB2 9
• Create XML-enabled databases and columns
• Compare and contrast StringIDs and PathIDs
• Explain how the various indexes in DB2 9 are used
• Use host variables to retrieve data from an XML column
• Insert, delete, update, import, and export XML data
• Describe the use of the XDS object

Using XQuery

• Describe the need for XQuery
• Use the XQuery data model to explain how XML data is stored and retrieved
• Create data types using the built-in XML schema types
• Use XPath expressions in XQuery statements
• Create XQuery statements that use FLWOR expressions
• Compare data values by using XQuery
• Perform logical operations in XQuery on sequences and nodes
• Define namespaces in XQuery statements

SQL/XML

• Describe the various functions in SQL/XML
• Use SQL/XML publishing functions to create tagged XML data
• Use the XMLQUERY function
• Use the XMLEXISTS function
• Use the XMLTABLE function
• Describe XMLTABLE paths
• Use the XMLNAMESPACES function
• Use the XMLCAST function
• Use the XMLVALIDATE function
• Use the IS VALIDATED predicate

XML Indexing in DB2 9

• Describe how XML data is stored and referenced in DB2 9
• Create an index on an XML column
• Use various data types in XML indexes
• Explain the casting process for XML data being inserted into indexes
• Compare indexes that use XML schemas with those that do not

XML - Best Practices, Performance, and Optimization

• Configure table spaces to use optimal page sizes
• Use snapshot monitor counters and event monitors to check index usage
• Describe the XML operators in DB2 9
• Interpret query execution plans
• Improve the performance of SQL/XML statements
• Ensure XQuery functions are used properly
• Determine which indexes can be used for a particular query
• Use namespaces with indexes

XML Schema Management

• Describe the XML schema repository
• Explain the concept of XML schema documents
• Register XML schemas
• Add schema documents to XML schemas
• Drop XML schemas
• Describe document type definitions
• Validate XML data using an XML schema

XML Decomposition

• Describe XML decomposition
• Compare the advantages and disadvantages of XML decomposition
• Describe annotated XML schemas
• Explain the decomposition process
• Use the different decomposition annotations
• Identify which decomposition annotations are required in a specific situation
• Validate XML data during decomposition

XML Full-Text Searches in DB2 9

• Describe the purpose of the Net Search Extender
• Administer the text index used by the Net Search Extender
• Configure a database for full-text searches
• Perform searches on specific parts of XML documents

The DB2 Developer Workbench

• Describe the basic concepts in the Developer Workbench
• Create XML queries and SQL scripts
• Annotate XML schemas
• Register XML schemas
• Create stored procedures

Back to top

HW/SW CONFIGURATION

The minimum hardware and software required to launch the course are:

• Reliable HIGH-SPEED INTERNET connection (min 200 kbps up and down)
• Windows 2000 or XP or Vista
• Computer with soundcard
• Headset or computer speakers
• Internet Explorer 5.01 or later, or Firefox 1.0 or later

Network Speed Test

http://clpext.moppssc.com/index.php?option=com_wrapper&view=wrapper&Itemid=8

User: clp

Pass: ibmeduc

For example, a speed test against the server with a slow connection of 140 Kbps download and 28 Kbps upload took 14 minutes to load a 30min recording before the video began. Extrapolate from this result to estimate approximately how fast your network internet access would be.

High-speed broadband internet access is the recommended configuration for this course.

Keyboard Configuration

If you use a different character keyboard, you may experience errors when entering passwords. If possible, change your language/country settings for your keyboard to USA, which allows you to enter characters as in a QWERTY keyboard.

Back to top