IT / Programming / Oracle / Oracle 19c / PL/SQL 3 - XML Integration

Oracle 19c - PL/SQL 3 - XML Integration

Details

ID 2757637
Classroom 3 days
Webinar 5 days
Method Lecture with examples and exercises.
Prequisite General database knowledge
Audience Programmers, developers

Services:

  • Lunch / Catering
  • Assistance for hotel / travel bookings
  • Comelio certificate
  • Flexible: Free cancellation up until 10 days before the training

Summary

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.

Training Dates

  • 2020-Nov-02 - Nov-06
  • 2021-Jan-11 - Jan-15
  • 2021-Mar-22 - Mar-26
  • 2021-May-31 - Jun-04

950 EUR +VAT

Location | Enrollment


Agenda

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

Trainer

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 ISBN 978-3-939701-40-8
  • Oracle, PL/SQL und XML ISBN 978-3-939701-49-1
  • XSLT, XPath und XQuery ISBN 978-3-939701-50-7
  • XML Schema ISBN 978-3-939701-54-5
Projects

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.

Research

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