Oracle Database 10g: Use XML for SQL and PL/SQL Developers

Oracle provides PL/SQL developers with XML tools, which work inside the Oracle Database. In this course, students learn to use XML technology with PL/SQL for Application Development. This course covers the XML features and utilities available for the Oracle Database 10g Release 2, that can be used to develop PL/SQL applications.

The focus of this course is Oracle XML DB including packages supporting Oracle XML DB. Students learn to store, retrieve, search, generate and manipulate XML data in the Oracle Database. This course emphasizes XQuery, a language designed to query XML data from both XML files and from relational databases. Students also learn how to optimize the performance of XPath and XQuery expressions. This course covers importing and exporting XML data in Oracle XML DB.

Learn To:

• Use Oracle XML DB Repository
• Search and Retrieve XML Data
• Manage XML Storage in Oracle XML DB
• Manipulate and Generate XML Data
• Use XQuery
• Use PL/SQL APIs for XML

Audience

• Application Developers
• Database Administrators
• Developer
• End Users
• PL/SQL Developer

Course Topics Introducing XML for Application Developers

• Oracle XML DB basic concepts, features and terminology

Oracle XML DB Repository

• Overview of Oracle XML DB Repository
• Creating and Accessing Resources
• Managing Oracle XML DB Versioning
• Accessing Oracle XML DB repository data using standard Internet protocols

Managing XML Storage

• Choosing Native XML Storage
• Unstructured versus structured storage
• Using XMLType view for relational data
• Using hybrid storage mapping
• Using out-of-line storage
• Storing collections in out-of-line tables
• Specifying SQL constraints
• Adding constraints on repetitive elements

Advanced XML Schema

• Inheritance in the XML Schema
• Managing cyclical definitions in XML Schema
• XML Schema Evolution

XQuery

• XQuery: Introduction
• XQuery Data Model
• Using XMLQuery(), XMLTable(), and ora:view functions
• Using XQuery Expressions
• Using XQuery functions and operators

Searching and Retrieving XML Data

• Retrieve XML data
• Querying Database: Relational Data
• Querying Database: XMLType Data
• Querying Database: CLOB Data
• Searching an XML Document
• Using XPath based Search
• Using Full Text Search

Advanced XQuery

• Using XQuery to Generate XML
• Using XQuery to Transform XML
• Using XQuery For Querying XML
• XQuery Support in SQL*Plus
• Using XQuery with PL/SQL: Binding Dynamic Variables
• Using Namespace with XQuery

Manipulating and Generating XML Data

• Using SQL functions to update XML data
• Using DBMS_XMLSTORE
• Generating XML using new SQL/XML functions
• Generating XML using DBMS_XMLGEN package

Understanding and Optimizing XPath and XQuery Rewrite

• Overview of XPath Rewrite
• XPath rewrite benefits
• Instances where XPath rewrite occur and does not occur
• XPath rewrite process
• Detecting XPath Rewrite
• XPath rewrite of SQL Functions
• XQuery Rewrite
• Tuning the performance of XQuery Expressions

PL/SQL API for XML Type

• Introducing PL/SQL APIs for XMLType
• Document Object Model(DOM)
• Using DBMS_XMLDOM to create a DOM document.
• Using DBMS_XMLPARSER to access the contents and structure of XML documents
• Using DBMS_XSLPROCESSOR for transforming an XML documents

Importing/Exporting XML Data

• Loading XMLType data using SQL*Loader
• Importing and exporting XMLType data
• Creating XMLType Queue
• Enqueue and dequeue XML messages

Course Objectives

• Explain the basic concepts of Oracle XML DB
• Use Oracle XML DB Repository
• Manage XML Storage in Oracle XML DB
• Use XQuery
• Search and Retrieve XML Data
• Manipulate XML Data
• Generate XML Data
• Tune the performance of XPath and XQuery expressions
• Use PL/SQL APIs for XML
• Import and Export XML Data