XML Fundamentals (D64794) – Outline

Detailed Course Outline

Introduction

• Course Objectives
• Course Goals
• Database schemas used in this course
• The Purchase Order XML schema purchase orderxsd used in the XML DB Course
• Appendices Used in This Course
• Class Account Information
• Course Environment
• Entering SQL Statements Using

Introducing the XML Document

• Extensible Markup Language
• Advantages of Using XML
• XML Standards
• Document Object Model
• Oracle XML Support
• Using XML in Oracle JDeveloper
• Building XML Applications with Oracle Technology
• Creating an Application and Project in JDeveloper

Validating XML with a Document Type Definitions (DTDs)

• What Is a Document Type Definition?
• Why Validate an XML Document?
• General DTD Rules
• The Contents of a DTD
• Referencing the DTD
• Element, Attribute, and Entities Declarations
• Complete DTD: Example
• Validating XML Against a DTD

Modularizing XML with Namespaces

• What Is an XML Namespace?
• Why Use XML Namespaces
• Declaring XML Namespaces
• XML Namespace prefixes
• Example of XML Namespace Declarations
• Scope of XML Namespace Declarations
• Invoking the ShowXmlNS Tool

Validating XML Documents

• What is an XML Schema?
• The Benefits of XML Schemas
• XML Schema Versus DTD
• Validating an XML Document with an XML Schema Document
• Referencing an XML Schema with the schemaLocation Attribute
• Components of an XML Schema
• Creating an XML Schema Document in JDeveloper
• Creating an XML Document from an XML Schema

Navigating XML Documents by Using XPath

• What Is XML Path Language?
• The XPath Model
• XPath Expressions
• The Location Path Expression
• Location Steps in XPath Expressions
• XPath Axes and Node Test Types
• XPath Functions
• Testing XPath Expressions

Transforming XML by Using XSL Transformations

• What Is XSL?
• XSL Transformations
• The XSLT Stylesheet
• Using an XSLT Stylesheet with an XML Document
• Viewing the Transformed Document
• Creating and Applying Template Rules
• Conditional Processing with and
• Using Modes

Working With XQuery

• What is XQuery?
• Applications of XQuery
• XQuery Terminology and Data Model
• Conversion of XML into a Query Data Model
• XQuery Syntax Rules
• XQuery Support in JDeveloper
• XQuery Expressions, Functions, and Operators
• Using FLWOR Expressions

Introduction to Oracle XML DB

• What Is Oracle XML DB?
• Oracle XML DB Benefits
• When to Use Oracle XML DB?
• How Is Oracle XML DB Implemented?
• Oracle XML DB: Features
• Using the XMLType
• XMLType Storage Models
• XML Schema Support in Oracle Database 12c