Oracle fundamentals - mentored workshop

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.

Schedule

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested? Please let us know.

Intended for

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

Background

General, theoretical/conceptual knowledge of the Oracle Database environment is required; the theoretical fundaments 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:

  • Selftraining using standard ABIS course materials
  • Selftraining using e.g. available commercial publication, internet content, ...
  • Training using formal third party sources, eg. 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.

Main topics

Typical workshop content

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

Training method

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.

Duration

Our environment is available for 4 weeks (elapsed) - approximately 3 days will be required to complete this workshop.

Course leader

ABIS


SESSION INFO AND ENROLMENT