home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
C
All CoursesbalkjeGeneral » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » Mac OS X » iPad and iPhone iOSDatabases and middleware » Relational databases & SQL » DB2 for z/OS » DB2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Big data and analyticsApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical informationRegistration 
Oracle DBA 1 - Core competences

Objectives

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.

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

 

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).

Training method

Classroom instruction and a few labs.

Course leader

Kris Van Thillo, YottaXpert.

Duration

4 days.

Schedule

You can enrol by clicking on a date
datedur.lang.  location  price
12 Jun4ELeuven  (BE)2000 EUR  (excl. VAT) 
16 Nov4NWoerden  (NL)2000 EUR  (exempt from VAT) 
11 Dec4?Leuven  (BE)2000 EUR  (excl. VAT) 

Global score

   
4.2/5 (based on 56 evaluations)

Reviews

     
prima cursus als basis (, )
     
te diep in detail voor een basiscursus (, )
     
Als DB2 DBA zeer goed volgbaar. Veel herkenbaarheid met DB2, maar ook zeer leerzaam om de verschillen tussen de twee dbms'en te leren. (, )
     
heel goed, wel veel stof te verwerken op relatief korte tijd. (, )
     
Pittig tempo, maar goed te volgen! (, )
     
zeer goed (, )
     
goede en duidelijke uitleg (, )
     
Zeer goede cursus met heldere uitleg en voorbeelden. (, )
     
prima cursus, had meer oefeningen verwacht zodat de stof meer gaat leven (, )
     
Ik ben zeer tevreden over de cursus. Heel goed uitgelegd en op een boeiende manier overgebracht. (, )

Refresh this page to see other comments.