Infrastructure at your Service

Homepage » Trainings » Oracle DBA essentials workshop

Oracle DBA essentials workshop

dbi InSite Workshops

You need to master the Oracle Database concepts, administration, and troubleshooting tasks? Our three-day dbi InSite workshop course will exactly fit your needs. Through various practical trainings, exercises and live demos, you will learn the essentials of the Oracle database – from the database concepts processes and mechanisms to the latest Oracle 19c features. At the end of this workshop course, you will be able to understand, create, administer, and troubleshoot Oracle databases.

Combined offer: Workshop Oracle Basics + Workshop Oracle DBA Essentials -> CHF 3’990.- instead of CHF 4’500.-

Training’s dates

Nyon 05-07.10.2020
Basel 03-05.11.2020
Zurich 03-05.11.2020
Bern 03-05.11.2020
On-site/Online On demand
3 days
CHF 2700.- *

Trainers

  • Jérôme Witt
    Jérôme Witt
  • Nicolas Penot
    Nicolas Penot

By booking a dbi services’ InSite workshop, the customer commits to respecting the Sales and Service General Conditions

(*) 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

  • Increase knowledge of the Oracle database architecture
  • Configure Oracle databases according to best practices
  • Secure the database (user management, privileges and roles)
  • Administer Oracle databases
  • Manage Oracle network protocols
  • Acquire knowledge in Oracle Enterprise Manager Database Console (Monitoring) and Oracle Recovery Manager
  • Maintenance management (patching)

Topics

  • Storage, process and, memory structures as well as Oracle Automatic Storage Management (ASM)
  • Oracle network infrastructure (Oracle Net, listener)
  • Maintenance strategy (datapatch, optach)
  • Space management
  • Oracle Automatic Diagnostic Repository (ADR)
  • Job Scheduler (DBA_SCHEDULER)
  • Oracle Data Pump export/import utility
  • Backup & recovery with RMAN
  • Oracle optimizer
  • Globalization support
  • Oracle Database Upgrade Assistant

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

Prerequisite Training to the Oracle DBA essentials

Related Trainings & Events

Language & documentation

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

Equipment

  • On-site training: As this training is provided on a Cloud platform, participants must be equipped with a laptop in order to access the Cloud infrastructure through an ssh client.

More information on dbi services:

dbi InSite Workshop - book now!

You want to book a dbi InSite Workshop or get more information on our IT trainings? Please fill in the entry form below. We will confirm your participation or come back to you as soon as possible. If, to our regret, the workshop is already fully booked, we will inform you on other dates or alternative solutions.

Training sessions :




Please contact me via :

E-mailPhone

Where did you know dbi services ?



dbi InSite Workshop on-site/online - request & information

You want dbi services to hold an "on-site" workshop (in your premises) or an online workshop for you ? 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 ?