Oracle Database 10g: Use XML for SQL and PL

Oracle University | Chiamaci: 800 672 253
Oracle Database 10g: Use XML for SQL and PL/SQL Developers
Duration: 3 Days
Description
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
Amministratore di database
Application Developers
Database Administrators
Developer
End Users
PL/SQL Developer
Sviluppatore PL/SQL
Sviluppatori di applicazioni
Utente finale
Prerequisites
Prerequisiti obbligatori
Oracle Database 10g: Program with PL/SQL
Oracle 10g: XML Fundamentals
Prerequisiti suggeriti
Experience in basic use of Oracle RDBMS, including SQL DDL and DML, and PL/SQL
XML Fundamentals
Course Objectives
Explain the basic concepts of Oracle XML DB
Use Oracle XML DB Repository
Manage XML Storage in Oracle XML DB
Copyright © 2009, Oracle. Tutti i diritti riservati.
Pagina 1
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
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
Copyright © 2009, Oracle. Tutti i diritti riservati.
Pagina 2
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
Copyright © 2009, Oracle. Tutti i diritti riservati.
Pagina 3