Oracle DBA 1 - Core competences

In this 4-day classroom ABIS course, the physical and logical properties of the Oracle database system are thoroughly explained and practically practiced. Useful for anyone who will start working as a (junior) Oracle DBA - but also for analysts, DevOps developers, .... Prior knowledge of SQL, and basic knowledge of Oracle databases is recommended.

The database administrator (DBA) plays a key role in the data management process. The DBA is the scriptwriter and director in the design, implementation and maintenance of database structures; and is partly responsible for setting up and maintaining a high-performance database system. This course therefore offers a thorough technical and logical overview of the Oracle database management system. The training is primarily aimed at application DBAs.

This course:

  • gives you a clear overview of the various tasks of an Oracle DBA;
  • provides you with a thorough technical overview of the physical and logical structure of the applicational Oracle objects;
  • provides an overview of the standard tools and utilities to monitor and manage these objects;
  • indicates how to set up these objects with a view to security.

Schedule a training?

Delivered as a live, interactive training: available in-person or online, or in a hybrid format. 
Training can be implemented in English, Dutch, or French.
If interested in organising this training internally, get in touch with us; we can even customise it to meet your specific needs.

REQUEST IN-COMPANY TRAINING

 

Public training calendar

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

Database administrators (junior role); other users who perform part of the DBA's duties; application developers in a DevOps environment; Oracle system administrators who want to gain insight into the logical Oracle object structures.

Background

Some familiarity with Oracle as relational database system, with the application development process, and with SQL (see Oracle fundamentals course and SQL fundamentals).

You can test for yourself to see if you have enough background by filling out the on-line self-test SQL Intermediate' and the on-line self-test 'Oracle fundamentals'.

Main topics

  • The Oracle system:

    instances • databases • overview

  • Physical structure of Oracle objects:

    files • segments • extents • blocks

  • Logical structure of Oracle objects:

    databases • table spaces • rollback segments • tables • partitions • views • synonyms • indexes • object dependent

  • Management of Oracle objects:

    Oracle catalog views • use of the catalog for monitoring • reorganisation techniques

  • Access control:

    creation of new users • creation of ''roles'' • characteristics and control on the given privileges • set-up of scenarios

  • Backup and recovery procedures:

    introductory concepts

  • Oracle utilities:

    import/export • loader • utilities for the calculation of statistics and object validation • scenarios

Training method

Live instructor-led training, with plenty of opportunities for hands-on exercises and discussion

Certificate

At the end of the course session, the participant receives a 'Certificate of Completion'.

Duration

4 days.

Course leader

Kris Van Thillo (ABIS).


SESSION INFO AND ENROLMENT