home 
 
 
 
ennl
 
Home
A propos
Services
Cours
Ressources
Contacts
MyABIS
C
Tous les coursbalkjeGénéralités » Introduction HW & SW » Soft skills » Cycles completsSystèmes d’exploitation » MVS - z/OS » UNIX - Linux - AIX » Mac OS X » iPad et iPhone iOSBases de données et middleware » Relational databases & SQL » DB2 for z/OS » DB2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Big data et analyticsDéveloppement d’applications » Méthodiques et techniques » TOGAF » PRINCE2 » Agile et Scrum » Les langages de programmation » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesGestion de système » ITIL » SecuritybalkjeEn pratiqueInscriptions 
Cette page n'est pas disponible en français.
Oracle database administrator certification track (OCA)

Objectives

By obtaining an Oracle certificate, you demonstrate a thorough knowledge of the Oracle environment. Obtaining this certificate requires effort and a thorough preparation. A preparation that focuses on obtaining the certificate, but in which we want to teach the participants above all a practical understanding of the Oracle database system. Since certification should never be the only goal!

So, ABIS presents this track for Oracle, preparing for the Oracle Database 11g Administrator Certified Associate (OCA) certificate. This track will prepare for the 2 exams that you will need to take to get OCA certified: Oracle Database 11g: SQL Fundamentals Iand Oracle Database 11g: Administration I

In this course, the participants will become familiar with:

  • Technical aspects of Oracle: architecture, networking, storage, utilities, backup and recovery,...
  • Oracle Security, Auditing
  • Application aspects: Oracle objects, transactions, undo management, performance,...
  • Oracle maintenance tools: overview and context

All aspects will be examined in detail, putting them also into practice through different exercises and cases.

Main topics

This certification track handles both Oracle DBA topics and SQL.

  • Architectural overview of Oracle Database: product stack • instance architecture • memory structures • process structures
  • Installing and Creating a Database: tools for administering a database • database installation using DBCA
  • Instance Management: set initialization parameters • stages of startup and shutdown • using alert log and trace files • data dictionary
  • Oracle Networking: configuring listeners • shared server architecture
  • Oracle Storage: tablespaces • datafiles • segments • extents • blocks • space management
  • Oracle Security: creating users • grant and revoke privileges • create and manage roles and profiles • database auditing
  • DDL and Schema Objects: tables • data types • constraints • indexes • views • synonyms • sequences • PL/SQL objects
  • DML and Concurrency: DML statements • transactions • locking • undo management
  • Writing queries: filtering • sorting • functions • grouping • joins • subqueries • set operators
  • Backup and Recovery "basics": instance recovery • preparing database for recoverability • flash recovery area • types of backups • RMAN basics • data recovery advisor
  • Moving data: SQL*Loader • external tables • datapump
  • The AWR and the Alert System: automatic workload repository • database advisory framework • alert system
  • Performance Tuning: managing memory • fixing invalid/unusable objects

The implementation is done on an Oracle Database installed on a Linux system using SQL*PLUS and SQL Developer.

 

Intended for

Starting DBAs who want to prepare for Oracle certification, but who also want to learn how to manage an Oracle database in practice.

Background

Participants should be familiar with the basics of relational databases and SQL (see ABIS course SQL and relational databases fundamentals).

Training method

For this track, ABIS is using a blended learning approach. Course participants will combine e-learning and self-study with classroom instructor-led training sessions.

  • The self-study/e-learning will be based on e-learning modules on the internet, combined with literature from books and course handouts, all provided by ABIS.
  • The classroom training sessions allow us to assess acquired knowledge, to clarify poorly-understood topics, to deepen insight into the subjects studied, and to provide for additional practices and labs. And on the final day of the track, we prep you for the actual certification exam!

All parts/modules of the certification track are well aligned, in form and content. The provided sequence of topics is well defined and described in detail. Instructors are available during classroom sessions, as well as for questions during self-study/e-learning. Assessment of the technical concepts acquired is achieved using different test methods.

Participants use their own PC - on which a virtual course environment is installed - for the entire blended learning track. This will allow them to use this course environment throughout any stage of this blended learning track.

For more information on the training approach used, please consult Blended learning.

Course leader

Kris Van Thillo, Sandy Schillebeeckx.

Duration

10 days for classroom sessions with a typical elapsed time of 8 weeks.

Schedule

Vous pouvez vous inscrire en cliquant sur une date
dateduréelang.  lieu  prix
04 Sep10?Leuven  (BE)4750 EUR  (excl. TVA) 
31 Oct10NWoerden  (NL)4750 EUR  (exempte de TVA) 

Reviews

     
Goede cursus, tempo ligt hoog. Veel nieuwe stof in korte tijd! Goede uitleg docente! (, )
     
Goed verzorgd, goed overbrengen van stof. (, )
     
Zeer leerzame cursus, kwalitatief goede uitleg en op niveau. Goede balans tussen theorie en praktijk opdrachten (, )
 
Nogmaals bedankt voor de fijne en enthousiast gegeven cursus. (, )
     
Prima cursus - goede inhoud (, )
     
Super georganiseerd. Eerst zelf leren dan de test maken is een goeie combinatie. Oefeningen tijdens de trainingen waren goed. (, )