Oracle DBA 1 - Core competences

The database administrator (DBA) plays an important role in the data management process. The DBA is the planner and the producer during the design, the implementation and the maintenance of physical database structures.

At the end of this course, the participant will be able:

  • to describe the physical and logical characteristics of the Oracle database;
  • to execute scenarios for the management, monitoring and support of database management tasks;
  • to guide the set-up of new Oracle database environments.

Schedule

datedur.lang.locationprice 
31 Mar4Woerden 2100 EUR (exempt from VAT)
SESSION INFO AND ENROLMENT

Intended for

Database administrators, everyone who takes part in the DBA process and application developers.

Background

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

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

Classroom instruction and a few labs.

Duration

4 days.

Course leader

Kris Van Thillo.

Reviews

Cursus is uitstekend bevallen. Veel geleerd en een duidelijk inzicht ontwikkeld over hoe Oracle in elkaar zit

 
  (, )

Een zeer pittige cursus waarbij (ik niet als de eerste) toch wat meer praktijk in plaats van theorie had willen zien

 
  (, )

prima cursus, had meer oefeningen verwacht zodat de stof meer gaat leven

 
  (, )

zeer goed

 
  (, )

Zeer goed uitgelegd. De stof werd aangenaam/visueel gebracht. Als je deze stof in online books bekijkt, is dit droog.

 
  (, )

Ik ben zeer tevreden over de cursus. Heel goed uitgelegd en op een boeiende manier overgebracht.

 
  (, )

Also interesting

Enrollees for this training also took the following courses:


SESSION INFO AND ENROLMENT