IT / Programming / Oracle / Oracle 19c / PL/SQL 3 - XML Integration
| ID | 2757637 |
|---|---|
| Classroom | 3 days 9:00-16:30 |
| Webinar | 5 days 9:00-12:30 |
| Method | Lecture with examples and exercises. |
| Prequisite | General database knowledge |
| Audience | Programmers, developers |
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.
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
Overview of DOM and the PL/SQL package DBMS_XMLDOM - produce, process and manipulate XML documents - use of XPath
Processing XML with XSLT, use parameters - overview of XSLT and the PL/SQL package DBMS_XSLPROCESSOR
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
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
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
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.
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.
He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.
