Kontakt

Oracle 19c - Object-Relational Features

Details

ID 2757638
Duration 2.0 days
Methods Lecture with examples and exercises.
Prerequisites Oracle SQL, PL / SQL
Target group Programmers, developers

Overview

Oracle´s Object-Relational Features are intended for programmers developing new applications or converting existing applications to run in the Oracle environment. The object-relational features are often used in content management, data warehousing, data/information integration, and similar applications that deal with complex structured data. The object views feature can be valuable when writing new C++, Java, or XML applications on top of an existing relational schema. This training assumes that you have a working knowledge of application programming and that you are familiar with the use of Structured Query Language (SQL) to access information in relational database systems. The various parts of this training a) introduce the key features and explain the advantages of the object-relational model, b) explain the basic concepts and terminology that you need to work with Oracle Objects, c) discuss collection datatypes and operations on collection datatypes, d) explain object views, which allow you to develop object-oriented applications without changing the underlying relational schema, and e) explains how to perform essential operations with objects and object types.

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.

Go to book catalog

Services

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

Content

General Concepts of PL/SQL and Oracle Objects
Overview of Object Orientation - Relational Mapping with PL/SQL - Object-Relational Structures
Object Types in PL/SQL and SQL
Introduction: basic principles of object types and objects, defining object types - PL/SQL objects in the Oracle database: create an object type, objects and SQL statements, objects in PL/SQL, object methods
Inheritance in PL/SQL
Inheritance and hierarchies in PL/SQL object types: Simple inheritance, overriding methods, substitution principle and dynamic binding, overloading, inheritance prevention - Abstraction: The principle of abstraction, substitution principle for abstraction, tables and inheritance, substitution principle for tables substitutability important SQL functions
PL/SQL Objects and PL/SQL Collections
Create collections using object types: use of VARRAYs, use of nested tables - Use of collections in tables: collection types, collections of primitive data type, DML operations - collections and objects in PL/SQL: use of collections and cursors, nested tables, collections, nested structures
Managment of Objects
Permissions and security: system privileges for PL/SQL object types, schema rights for PL/SQL object types - administration of objects: dependencies, synonyms, system views for objects
Object Views and OR-Mapping
Object Views and their use: general approach, nested structures - hierarchies and relationships, single-level hierarchies with collections, multilevel hierarchy with and without collections, relationships - working with Object Views: primary keys in views, NULL values??, references, inheritance, manipulation of data in views using SQL statements

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 SQL (Comelio Medien)
    978-3-939701-41-5
  • Oracle PL/SQL - Objektrelationale Techniken (Comelio Medien)
    978-3-939701-42-2
  • Oracle, PL/SQL und XML (Comelio Medien)
    978-3-939701-49-1

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.