Oracle fundamentals - mentored workshop
In this 3-day ABIS mentored lab, the basic characteristics of the Oracle database system are thoroughly practiced. Extremely useful for anyone who will eventually start working with Oracle and already has basic conceptual Oracle knowledge. 'Lab-only' (hands-on) implementation. Prior knowledge of SQL, and of course Oracle, is necessary.
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.
Schedule a training?
Training can be implemented in English, Dutch, or French.
| DEMANDER FORMATION EN ENTREPRISE |
Calendrier publique des formations
Il n'y a pas de sessions publiques à ce moment. Nous organisons volontiers un cours en entreprise ou une session publique supplémentaire (en cas d'un nombre suffisant de participants). Intéressé? Contactez-nous.
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 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.
Main topics
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
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.
Certificate
At the end of the workshop, the participant receives a 'Certificate of Completion'.
Duration
Our environment is available for 4 weeks (elapsed) - approximately 3 days will be required to complete this workshop.
Course leader
| INFO SESSION ET INSCRIPTION |