Infrastructure at your Service

Oracle DBA basics

dbi InSite Workshops

You never worked with Oracle and start with Oracle databases administration? Our two-days dbi InSite workshop course will exactly fit your needs. Through various practical trainings, exercises and live demos, you will learn the basics of the Oracle database. At the end of this workshop course, you will be able to manage the everyday tasks related to your Oracle databases (create, administer, backup, manage high availability, etc.) on your servers or in a Cloud Service

Training’s dates

2 days
CHF 1800.- *

Trainers

  • Joël Cattin
    Joël Cattin
  • David Schmitt
    David Schmitt

(*) Prices are to be considered per participant and without VAT

SOUG (Swiss Oracle User Group) The members of the SOUG (Swiss Oracle User Group) benefit from a 5 % reduction.

Training objectives

  • Understand the basics of the Oracle database architecture
  • Create and configure Oracle databases
  • Understand database security: privileges and roles
  • Administer Oracle databases with usual tasks
  • Understand Oracle network protocols
  • Be ready with Oracle Recovery Manager (backup & recovery) and Oracle Data Guard (high availability)

Topics

  • Oracle database file types: spfile, control file, data file, redo log file
  • Storage, process and memory structures
  • Oracle Database Creation Assistant (DBCA)
  • Oracle Network Infrastructure (OracleNet, listener)
  • Oracle Data Pump Export/Import utility
  • Oracle backup & recovery with RMAN
  • Oracle high availability with Data Guard

Method

  • Presentation with countless practical exercises and trainings
  • Case studies, live demos, discussions
  • Networking during coffee break, lunch, and apéro on last day (included in price, except for on-site workshop courses)

Target groups

  • Database administrators (DBA) as well as network, system, and application administrators responsible for or supporting Oracle databases

Related Trainings & Events

Language & documentation

  • Workshop in English, French or German
  • Documentation: content details, scripts, case study solutions as PDF file (in English)

More information on dbi services:

 

dbi InSite Workshop on-site - request & information

You want dbi services to hold an "on-site" workshop inside your organisation? You have special requirements, e. g. regarding the content, the duration, the date, or the number of participants?
We have good news for you: Our dbi InSite Workshops can be flexibly adapted to your needs! Please just fill in the form below and we will come back to you as soon as possible. You may also use this form to inquire on the future dates of our dbi InSite Workshops.





Please contact me via :

E-mailPhone

Where did you know dbi services ?