This labs-only mentored workshop offers participants the possibility to put recently acquired often conceptual Oracle database knowledge into practice. Specifically tailored and integrated labs enable participants to extend their theoretical knowledge using this 'hands-on' lab approach. Mentored by ABIS specialists, participants are assisted in creating an individual learning experience.

This course - by means of mentored hands-on labs:

• 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.

Typical workshop content

• identifying and discovering the Oracle database system
  • instance - database
  • listener
• examining the logical and physical Oracle database architecture and structures using the Oracle catalog
  • database - tablespaces - files
  • tables - indexes
• creating application driven database objects
  • tablespaces - tables - indexes
  • views - synonyms - sequences
• creating application driven procedural objects
  • stored procedures and functions
  • triggers
• adding data to objects using available Oracle utilities - export/import, Oracle Loader
• guaranteeing secure access to your database environment
• introducing SQL performance related concepts

First step: a kick-off test evaluates participant acquired knowledge; based on the test results, an individually tailored training program is suggested.

The actual training program is implemented in individual format - online - an instructor is offline available. Participants are closely mentored with required contact moments scheduled.

At the end of the workshop, the ABIS instructor will suggest follow-up knowledge gathering activities.

Participants have a private (virtual) Oracle lab environment at their disposal, made available by ABIS.

Training can be implemented in English, Dutch, or French.

General, theoretical/conceptual knowledge of the Oracle Database environment is required; the theoretical foundations required to fully appreciate the Labs-Only workshop are not discussed in this workshop. Participants are assumed to have acquired this knowledge using alternate source available, for example:

• Self training using standard ABIS course materials
• Self training using e.g. available commercial publication, internet content, ...
• Training using formal third party sources, e.g. PluralSight, Udemy, Skillsoft, ...

ABIS technical consultants are available for offering advice as to what sources to consult prior to attending this labs-only mentored workshop.

Analysts, programmers and database administrators who are going to use the Oracle database environment, already having a basic yet mainly theoretical Oracle background.