Skip Navigation LinksHome > Vendors > >

D72723 - Oracle Database 11g: Use XML DB

Overview

This course introduces students to Oracle XML DB, a feature of the Oracle Database. Students learn to store, retrieve, generate, and manipulate XML data in Oracle Database 11g.

Students learn about the different storage models for storing XML documents in Oracle XML DB. Students query XMLType data by using SQL/XML standard functions and XQuery. Students generate and manipulate XML data and learn to use Oracle XML DB Repository. In addition, students access and manipulate repository resources using protocols such as SQL, and PL/SQL. Students learn to manage changes in an XML schema after registering it with Oracle XML DB. Students also learn how to import and export XML data.

Oracle SQL Developer is the major development tool in this course. SQL*Plus is also available as an optional tool.

Learn To:

  • Store and retrieve XML Data in Oracle XML DB
  • Generate XML Data from relational data in the database
  • Use XQuery to query, generate, and transform XML data
  • Manipulate XML Data in Oracle XML DB
  • Use Oracle XML DB Repository
  • Export and Import XMLType Data

Objectives

Upon completing this course, the learner will be able to meet these overall objectives:
  • Explain the basic concepts of Oracle XML DB
  • Store XML Data in Oracle XML DB
  • Retrieve XML Data in Oracle XML DB
  • Create and use indexes on XML data
  • Generate XML from relational data in the database
  • Use XQuery to query, generate, and transform XML data
  • Manipulate XML Data in Oracle XML DB
  • Manage changes to an XML schema that is registered in Oracle XML DB
  • Use Oracle XML DB Repository
  • Export and import XMLType data using Oracle Data Pump

Content

Module 1: Introduction to Oracle XML DB and XML Review
Module 2: Storing XML Data in Oracle XML DB
Module 3: Using XML Schema with Oracle XML DB
Module 4: Partitioning XMLType Tables and Columns
Module 5: Retrieving XML Data in Oracle XML DB
Module 6: Indexing XMLType Data
Module 7: Generating XML Data
Module 8: Transforming and Manipulating XML Data
Module 9: Working With the Oracle XML DB Repository
Module 10: Using Native Oracle XML DB Web Services
Module 11: Exporting and Importing XML Data
Module 12: Workshop

Audience

  • End Users
  • Application Developers
  • Database Administrators
  • Forms Developer
  • Developer
  • Support Engineer
  • Technical Consultant
  • PL/SQL Developer

Prerequisites

  • Experience in basic use of Oracle RDBMS, including SQL DDL, and DML, and PL/SQL
  • Basics of XML
  • XML Fundamentals
  • Oracle Database: SQL Fundamentals I
  • Oracle Database: SQL Fundamentals II

Certification

This course is not associated with any Certification.

Schedule

Show Schedule for: