The Oracle database system is widely used in larger and smaller organisations; sometimes as a black-box system to which no one has access. But in most cases fortunately as a data source used by application developers. Regardless of your job and background, basic knowledge of the Oracle system is required to work with it effectively!

This course:

• gives an overview of the Oracle RDBMS architecture;
• examines the physical and logical Oracle objects, and their relationship - tablespaces, tables, indexes, views, synonyms, ...
• describes the general and syntactical characteristics of the Oracle RDBMS: security, locking, data utilities;
• gives some basic rules concerning application performance.

• Oracle architecture
  Oracle instance and Oracle database • Oracle Client/server architecture
• Data definition and Oracle Objects
  Oracle logical object structure • link with physical structure • DDL statements
• Application development
  overview 3GL and 4GL
• Catalog
  catalog • performance tables
• Security concepts
  type privileges • roles
• Basic utilities
  export/import • loader • scenarios
• Locking
  lock types • versioning'
• Performance and Tuning
  explain utility

Live instructor-led training, with plenty of opportunities for hands-on exercises and discussion

Delivered as a live, interactive training: available in-person or online, or in a hybrid format. 
Training can be implemented in English, Dutch, or French.
If interested in organising this training internally, get in touch with us; we can even customise it to meet your specific needs.

General knowledge of informatics and some familiarity with database systems and SQL (see course SQL and relational databases fundamentals).

Analysts, (DevOps) developers, and (starting) database administrators who are going to use Oracle. Everybody who wants a thorough overview of the Oracle RDBMS.