Oracle 10g: XML Fundamentals

3 Day Course
Hands On
Official Oracle Curriculum
Code OC10GXML

This course has been retired. Please view currently available Oracle 12c Training Courses.

Modules

Hide all

Introduction (7 topics)

  • Discuss the Goals of the Course
  • Describe the Course Environment and Data
  • Describe an XML document
  • Edit an XML Document
  • View an XML Document in a Browser
  • Explain the XML Standards covered in this course
  • List Oracle Product Support for XML

Introducing the XML Document (5 topics)

  • Describe the XML Document structure
  • List the components of an XML document
  • Create an XML document
  • Create well-formed XML documents
  • Checking XML Document Syntax

Validating XML with a Document Type Definition (DTD) (3 topics)

  • Describe and Read a DTD
  • Using an external and an internal DTD
  • Validating XML documents using a DTD

Using XML Namespaces (3 topics)

  • Describe the need for XML Namespaces
  • Describe the syntax for XML Namespaces
  • Apply XML Namespaces to elements and attributes

Validating XML using XML Schema (4 topics)

  • Create an XML Schema
  • Declare XML Schema data types
  • Validating XML documents with an XML Schema
  • Compare XML Schema with a DTD

Navigating XML Documents using XPath (3 topics)

  • Describe XPath
  • Use XPath expressions; Use XPath functions
  • Describe location path

Transforming XML using XSL Transformations (XSLT) (7 topics)

  • Describe XSL and XSL Transformations (XSLT)
  • Transform an XML document using XSLT
  • Use Common Elements of XSLT
  • Create XSLT Templates
  • Sort and Filter an XML Document
  • Describe Recursion
  • Using Simple XSL Formatting Objects (XSL:FO)

XSQL Pages Publishing Framework (3 topics)

  • Describe the Oracle XSQL Pages Framework
  • Create XSQL Pages
  • Use XSQL Pages

Advanced XSQL Pages (5 topics)

  • Using Cursors in XSQL Pages
  • Employ XSQL pages for session variable
  • Employ XSQL pages for cookies
  • Performing DML operations using XSQL Pages
  • Inserting data from an XML Document

Introducing Oracle 10g XML Database (XML DB) (6 topics)

  • Describe Oracle XML DB
  • Describe XMLType
  • Describe XML Schema support
  • Describe XML Repository
  • Describe Internet Protocol support
  • Describe Versioning

Generating XML from an Oracle 10g Database (3 topics)

  • Describe SQL/XML (SQLX)
  • Using SQL/XML Functions in SQL
  • Generating XML using Native Oracle SQL Functions

Managing XML Data in an Oracle10g Database (6 topics)

  • Describe XMLType
  • Create objects of XMLType; Describe storage options
  • Load data into XMLType
  • Retrieve data from XMLType columns
  • Using XMLType methods
  • Using XPath functions on XMLType data

Creating XMLType Views (4 topics)

  • Creating Non-Schema-Based XMLType views
  • Creating XML Schema-Based XMLType views
  • Creating XMLType Views from XMLType Tables
  • Performing DML on XMLType Views

Executing SQL operations on XML (5 topics)

  • Transform XML using SQL
  • Perform DML on XML
  • Using UpdateXML() Function
  • Deleting Using the existNode() Function
  • Creating Indexes on XMLType columns

Accessing XML through URLs (2 topics)

  • Using the DBUri Servlet to obtain database data in XML format
  • Using the DBUri Servlet to obtain a row or column of data in XML format

Sections