Oracle fundamentals course
In this three-day ABIS course, the basic characteristics of the Oracle database system are thoroughly presented in detail, and put into practice. Extremely useful for anyone who will eventually start working with Oracle - analysts, developers, administrators, ....
Prior knowledge of SQL is recommended.
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. A database administrator provides systems management, access control, auditing, performance analysis. 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;
- describes the general and syntactical characteristics of the Oracle RDBMS: security, locking, utilities;
- gives some basic rules concerning application performance.
Schedule a training?
Delivered as a live, interactive training: available in-person or online, or in a hybrid format. Training can be implemented in Dutch, English, or French.
REQUEST IN-COMPANY TRAINING |
Public training calendar | |||||
---|---|---|---|---|---|
date | dur. | lang. | location | price | |
26 May | 3 | web based | 1785 EUR (excl. VAT) | ||
26 May | 3 | Woerden | 1785 EUR (exempt from VAT) | ||
SESSION INFO AND ENROLMENT |
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 • versioning''
- Performance and Tuning:
- explain utility
Training method
Classroom instruction with practical exercises.
Certificate
At the end of the course session, a 'Certificate of Completion' is handed to the participant.
Duration
3 days. This course can be extended with the module 3GL application development (day 4).
Course leader
Sandy Schillebeeckx (ABIS), Kris Van Thillo (ABIS).
Reviews
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, ) |
Inhoud en vorm waren zeker OK. Ook geweldig goed gegeven door de instructeur
| (Eric Verswyvel, HZIV, ) |
Also interesting
Enrollees for this training also took the following courses:
SESSION INFO AND ENROLMENT |