Oracle 11g: XML Fundamentals

Duration : 2 Days (16 Hours)

Oracle 11g: XML Fundamentals Course Overview:

The Oracle 11g: XML Fundamentals course is designed for developers and IT professionals beginning to learn about XML. It covers topics such as creating logical and physical documents, XSLT, XPath, data types, elements, attributes, namespaces, validation, JSON, XLink, and XQuery. By the end of the course, students will have a good understanding of XML fundamentals and be able to create and manipulate XML documents for application development.

Intended Audience:

  1. Database administrators
  2. Developers
  3. System analysts
  4. Individuals with a basic knowledge of application development and SQL
  5. Those with a basic understanding of Oracle 11g databases and database principles
  6. Individuals experienced in developing applications that store and retrieve data from Oracle databases.

Learning Objectives of Oracle 11g: XML Fundamentals:

1. Develop an understanding of the XML standards and gain an overview of the XML technology.
2. Learn to extract, store, and retrieve data in the XML Path Language (XPath).
3. Construct usable XML documents with the help of the XML Schema definition (XSD).
4. Transform XML documents using XSLT stylesheets, and generate an XML based report for database queries.
5. Familiarize oneself with the elements of Oracle database support for XML.
6. Illustrate the different methods of accessing and manipulating XML data within the database.
7. Utilize the XQuery language to query XML documents efficiently.
8. Handle XML documents in an Object-Relational database with the help of SQL and PL/SQL functions.
9. Analyze the advantages of the hierarchical XML storage (HXML) feature of Oracle database.
10. Get an overview of the content of an XML document.

 Module 1: Introducing XML Terminology
  • Extensible Markup Language
  • XML Standards
  • Document Object Model
  • Simple API for XML
  • Building XML Applications with Oracle Technology
  • XML in Service Oriented Architecture
  • Creating an Application and Project in JDeveloper
  • Extensible Markup Language
  • Example: A Simple XML Document
  • XML Document Structure
  • The XML Declaration
  • Components of an XML Document
  • A Well-Formed XML Document
  • Comparing XML and HTML
  • Creating XML Document in JDeveloper
  • Understanding the Document Type Definition
  • General DTD Rules
  • The Contents of a DTD
  • Example of a Simple DTD Declaration
  • Referencing the DTD
  • Element Declarations
  • Attribute Declarations
  • Entities in XML
  • 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
  • What is an XML Schema?
  • The Benefits of XML Schemas
  • XML Schema Versus DTD
  • An Example XML Schema Document
  • 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
  • Defining XML Path Language
  • The XPath Model
  • XPath Expressions
  • The Location Path Expression
  • XPath Axes
  • Operators in XPath Expressions
  • XPath Functions
  • Testing XPath Expressions
  • Defining XSL
  • XSL Transformations
  • The XSLT Stylesheet
  • Using an XSLT Stylesheet with an XML Document
  • Creating an XSL File in JDeveloper
  • Creating Template Rules
  • Template Rules and Priorities
  • Specifying Output Formats
  • Defining Oracle XML DB
  • Using XML DB
  • Oracle XML DB Features
  • Understanding the XMLType
  • XML Schema Support in Oracle Database 11g
  • Overview of XML DB Repository

Oracle 11g: XML Fundamentals Course Prerequisites:

A basic understanding of XML concepts and structure is assumed in order to follow this Oracle 11g: XML Fundamentals Training. No prior experience with Oracle Database is expected. However, experience with basic database concepts and SQL would be helpful.

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability


  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention


  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Certified Trainers.
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.