Oracle - XML Integration

Details

ID 2757637
Duration 3.0 days
Methods Lecture with examples and exercises.
Prerequisites General database knowledge
Target group Programmers, developers

Overview

Oracle XML DB is the name for a set of Oracle Database technologies related to high-performance XML storage and retrieval. It provides native XML support by encompassing both SQL and XML data models in an interoperable manner. Oracle XML DB includes the following features: a) Support for the World Wide Web Consortium (W3C) XML and XML Schema data models and standard access methods for navigating and querying XML. The data models are incorporated into Oracle Database. b) Ways to store, query, update, and transform XML data while accessing it using SQL. c) Ways to perform XML operations on SQL data. d) A simple, lightweight XML repository where you can organize and manage database content, including XML, using a file/folder/URL metaphor. This training provides an overview incl. presentations and hands-on labs of how to use Oracle XML DB.

Dates

OPEN
IN-HOUSE

Zurzeit stehen keine offenen Termine zur Verfügung. Nutzen Sie alternativ die Inhouse‑Option.

Learn with customized examples and content—precisely tailored to your requirements.

Your benefits at a glance

  • Flexible preferred date
  • Customized content
  • Intensive exchange
  • High practical relevance

Comelio Media

Still looking for additional reading? Discover suitable specialist books in our catalog.

Services

  • Lunch / catering
  • Help with hotel / travel
  • Comelio certificate
  • Flexible: free cancellation up to one day before
Service-Kaffeekanne

Content

Relational Query Results in XML
ISO Standard SQL/XML and its functions: Simple queries, XML document features, complex queries, SQL/XML query processing - queries with DBMS_XMLGEN: Package structure, query processing, complex queries - Oracle-specific SQL functions: generation of simple elements, use of object and table types, creation of aggregates, XML document specification
XML Processing using PL/SQL and DOM
Overview of DOM and the PL/SQL package DBMS_XMLDOM - produce, process and manipulate XML documents - use of XPath
XML Processing using PL/SQL and XSLT
Processing XML with XSLT, use parameters - overview of XSLT and the PL/SQL package DBMS_XSLPROCESSOR
Storing XML in Oracle
Usage scenarios: Realization of Import and Export - Storage models: use of the file system, relational storage, object-relational storage, use of XMLType, De-/Serialization of objects
XML Schema - based XML
DBMS_XMLSCHEMA: register XML schema, generate storage structures and XML Schema, XML Schema evolution, catalog views - Schema-based storage: XML Schema and XML storage, advanced storage options
XML datatype XMLType
Using the PL/SQL package DBMS_XMLSTORE - XML Schema, XSLT, PL/SQL Transformation of XMLType, validation of XMLType - XMLType views: Generation of views with and without XML Schema

Instructor

Marco Skulschus (born in Germany in 1978) studied economics in Wuppertal (Germany) and Paris (France) and wrote his master´s thesis about semantic data modeling. He started working as a lecturer and consultant in 2002.

Publications

  • Oracle PL/SQL (Comelio Medien)
    978-3-939701-40-8
  • Oracle, PL/SQL und XML (Comelio Medien)
    978-3-939701-49-1
  • XSLT, XPath und XQuery (Comelio Medien)
    978-3-939701-50-7
  • XML Schema (Comelio Medien)
    978-3-939701-54-5

Projects

He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Research

He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining. He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Certificates

Marco Skulschus is "Oracle Certified Associate" and passed the ComptiaCTT+ examination.