IT Technical & End User
Course Listings

For further information, or to make a telephone booking, or to receive a competitive quotation for an in-house course, you can call Pentland Training now on 0800 328 2766.

All of our training courses can be delivered on your own site, at Pentland Training facilities, or at an off-site venue.

Hot Topics

3-day ITIL Foundation

5-day PRINCE2™ Practitioner

4-day Business Analysis

3-day Project Management Fundamentals

Course Title:
Introduction to XML for ORACLE

Duration: 5 days

Course Overview
This course provides a comprehensive introduction to Extensible Markup Language (XML). XML is a new technology and is a powerful language used to encapsulate data into XML files. XML is particularly useful for integrating and passing data between Business-to-Business applications or between disparate systems. This course covers the complimentary technologies that are used with XML, such as XSL and CSS for producing content as well as Schemas and DTDs for validation.

This course also looks at how XML is used within Oracle. Covering areas such as the Oracle Development Kit, SQLX functions, Oracle9i XML DB and XSQL Pages Publishing Framework

Throughout this course, extensive hands-on exercises, performed under the expert tuition of an experienced instructor, provide delegates with practical experience.

Target Audience


All web developers or application developers who need to know about XML, particularly within an Oracle environment.
Systems managers and consultants should also be aware of XML, its associated technologies and the benefits that it can produce for organisations.

Course Objectives


By the end of the course attendees will be able to:

• Develop applications and solutions using Extensible Markup Language (XML)
• Understand the need for XML and its uses.
• Write well-formed XML documents and understand how XML documents are created.
• Use Document Type Definitions (DTD’s) to validate their XML documents
• Have an understanding of parsing and validating XML documents.
• Use XML Schemas to validate XML documents
• Bind XML content in HTML pages
• Design templates to present information (content) in a uniform way using XSL.
• Be able to use various XML tools and utilities.
• Transform XML using XSLT
• Store XML in an Oracle9i Database
• Retrieve stored XML
• Generate XML using XSQL, the database and JDeveloper
• Perform SQL operations on XML

Course Content


Introduction
• What is XML?
• Background and History of XML
• XML versus HTML
• The uses and applications of XML.

Composing XML Documents
• Syntax and composition.
• XML Spy
• Defining structure
• Valid and Well Formed documents.
• Parsing and validating XML documents
• Namespaces and their uses

Data Binding
• Creating a data island
• Table data binding
• Single-record data binding
• Using Paging
• Hierarchical record sets

Document Type Definitions (DTD’s)
• Internal and External DTD’s
• Document Type Declaration
• Element Type Declaration
• Attribute List Declaration
• General Entities
• Parameter Entities
• Notations

XML Schemas
• The Rules of XML Schemas
• XML Schema Tags
• Simple Data Types
• Using Patterns
• Useful Functions
• Allowing Choices of Elements
• Handling Attributes
• Handling Empty Elements

XSL Transformation
• What is Transformation?
• When is it needed?
• Cascading Style Sheets and XML
• Extensible Style sheet Language (XSL)
• XSL Syntax and composition.
• Defining Simple Types and Complex Types
• Using SAXON to transform XML documents
• Transforming an XML document into an HTML document using XSL.
• Transforming XML documents into XML documents with a different structure.
• Transforming element based to attribute based XML (and vice versa)

XPath
• What is XPath
• Using XPath Expressions
• Using XPath Functions
• Describing Location Path

XML Developer’s Kit
• What is XDK?
• The XDK Components
• Parsers
• Class Generators
• TransX Utility

XSQL
• Using XSQL Pages
• Session Parameters
• Cookies
• Including Parameters
• Include XSQL files and XML files
• Perform DML

Oracle9i XML DB
• What is XML DB?
• The XMLType Data Type
• XML Schema Support
• XML Repository
• Internal Protocol Support
• Versioning

Generating XML
• SQLX Functions
• SQL Functions

Storing XML in the Database
• What is XMLType?
• XMLType Tables
• Storage Options
• Loading Data into XMLType

Querying XML
• Selecting XML Data from XMLType Tables
• Using Oracle Text for Searching
• Creating Indexes for Oracle Text

SQL Operations on XML
• Transforming XML Using SQL
• Validating XML Using SQL
• Updating XML
• Creating Indexes on XMLType Columns

Accessing XML Through URLs
• What are DBUriTypes?
• DBUriType Functions
• Using DBUriType in SQL
• SYS_DBURIGEN() Function
• Using DBUriType in a Browser

Enter your email address to register for our newsletter: