Objectives

  • Understand the basics of Oracle database architecture (files and memory structures)
  • Install and configure Oracle databases
  • Understand database security (users, privileges and roles)
  • Administer Oracle databases with common tasks
  • Understand the components of the Oracle network layer (Oracle Net Services)
  • Understand the different backup techniques (Data Pump, RMAN)
  • Discover the different high availability solutions

Method

  • Presentations, practical exercises, case studies and question-oriented demonstrations
  • Discussion and networking during breaks and lunch (included)

Target groups

  • This Oracle DBA basics course is designed for Database Administrators (DBAs), Network Administrators, System Administrators and Application Administrators responsible for Oracle databases or their maintenance.

Prerequisites

  • Knowledge of the principles of a relational database system
  • Basic knowledge of the SQL language
  • Good knowledge of Linux operating systems

Combined offer: Oracle Basics Workshop + Oracle DBA Essentials Workshop = CHF 3’990.- instead of CHF 4’500.-
5% discount for SOUG, SwissPUG and DOAG members.

Trainers

Thumbnail [150x150]

David Schmitt

Consultant

Thumbnail [150x150]

Joël Cattin

Senior Consultant