Oracle fundamentals course
This course:
- gives an overview of the Oracle RDBMS architecture;
- examines the physical and logical Oracle objects, and their relationship;
- describes the general and syntactical characteristics of the Oracle RDBMS: security, locking, utilities;
- gives some basic rules concerning application performance.
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 contact ABIS.
Intended for
Analysts, programmers and database administrators who are going to use Oracle. Everybody who wants a thorough overview of the Oracle RDBMS.
Background
General knowledge of informatics and some familiarity with database systems and SQL (see course SQL and relational databases fundamentals). You can test for yourself to see if you have enough background by filling out the online self-test.
Main topics
- 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 • vVersioning'
- Performance and Tuning:
- explain utility
Training method
Classroom instruction with practical exercises.
Duration
3 days. This course can be extended with the module 3GL application development (day 4).
Course leader
Koen De Backer, Sandy Schillebeeckx, Kris Van Thillo.
Reviews
4.3/5 (based on 28 evaluations; the most recent ones are shown below)
|
The mastery of the trainer is very good
| (Padala Bhanuprakash, ING België, ) |
I liked the entry level; the course content was not too complex or too easy.
| (Mike, ) |
Trainers patience and involvement
| (N.N., ING - Hullenbergweg, ) |
I found the course excellent.
| (Colin, ) |
exactly what I expected -
| (Natalia Borodina, ING - Financial Plaza, ) |
Inhoud en vorm waren zeker OK. Ook geweldig goed gegeven door de instructeur
| (Eric Verswyvel, HZIV, ) |
Goed basis overzicht van Oracle
| (Fabian, ) |
Zoals altijd een goede cursus van Abis.
| (Kris Poels, Cegeka groep, ) |
Click here to see more comments...
Gives a GOOD overview on Oracle (DB) fundamentals!
| (Steven van Mastrigt, ING - Haarlerbergpark, ) |
Veel geleerd, was goed te volgen
| (Ellen, ) |
goede informatie, snelheid en kunde van de lesgever
| (Richard, ) |
De cursus geeft een prima inleiding in de basics van Oracle.
| (N.N., ) |
Also interesting
Enrollees for this training also took the following courses:
SESSION INFO AND ENROLMENT |