What is Oracle's DBA Training

Training - ORACLE database administration

You are here: Start> Seminars> Oracle Administration

 
  • Live online or presence
  • 4REAL
    4REAL © stands for a new generation of advanced training: heterogeneous and customizable training for a sustainable transfer of learning into the work environment.

After the "ORACLE database administration" seminar, you will know the structure of an ORACLE database system and know how to install, manage and analyze it using the tools available. The seminar is a good basis for daily work as a DBA.

Our learning platform LearningHub @Cegos is part of this face-to-face seminar. In addition to the digital seminar documents, the training is enriched with additional learning formats and media. In order to achieve a sustainable transfer of knowledge in everyday work, the seminar is implemented according to our 4REAL process model.

This seminar is part of the ORACLE DBA qualification plan.

Who should attend:

target group

The "ORACLE database administration" training course is aimed at prospective database administrators as well as application developers, system administrators and consultants who take on tasks in the DBA area.

requirements

The "ORACLE database administration" training requires basic knowledge of relational databases, preferably ORACLE, as well as knowledge of SQL in accordance with sem. 4051 ORACLE and SQL.

Architecture:

  • Definitions of terms
  • Logical and physical structure
  • ORACLE installation
  • What's new in current versions

Software architecture:

  • ORACLE process structure
  • Data Dictionary and Data Dictionary Views
  • Globalization support

Database installation:

  • Manually or via the DBCA (database configuration assistant)

Database administration:

  • SGA
  • Administration of an instance
  • Initialization parameters and SPFILE
  • Starting and stopping an instance
  • Management of control files, redolog files
  • Storage structures: block, extent, segment, tablespace
  • Creation and administration of big file and small file tablespaces
  • Undo management
  • Fast recovery area
  • statistics

Privacy:

  • User administration and schema concept
  • Allocation of system and object privileges
  • The role concept
  • User profiles
  • Password encryption and password files

Backup and recovery:

  • Backup and recovery strategies
  • Archiving
  • Flashback Database
  • Flashback table
  • Recyclebin

Network files:

  • SQL * Net
  • Setting up the client and server
  • Connection establishment

Tips and Tricks:

  • Performance problems
  • reorganization
  • Storage problems
  • Network problems
  • Connection of databases in the cloud

Tools:

  • SQL * Plus
  • SQL Developer
  • SQL * loader
  • Data Pump Export / Import

Training method

Lecture, demonstrations on the system and discussion. You can use your own exercise database to try out and consolidate what you have learned in practical exercises.

Note


The current ORACLE version is used.

  • From Jun 21 to Jun 25, 2021
  • From 26 Jul to 30 Jul 2021
  • From 26 Jul to 30 Jul 2021
    Integrata Cegos GmbH Munich
    Luitpoldstrasse 3, 1st floor (Elisenhof)
  • From 16 Aug to 20 Aug 2021
    Integrata Cegos GmbH Hamburg
  • From 06 Sep to 10 Sep 2021
  • From 06 Sep to 10 Sep 2021
    Integrata Cegos GmbH Munich
    Luitpoldstrasse 3, 1st floor (Elisenhof)
  • From 04 Oct to 08 Oct 2021
    Integrata Cegos GmbH Frankfurt
  • From Oct 25 to Oct 29, 2021
  • From Oct 25 to Oct 29, 2021
    Integrata Cegos GmbH Düsseldorf
  • From 06 Dec to 10 Dec 2021
    Integrata Cegos GmbH Stuttgart
Training - ORACLE database administration

In-house seminars

Save time and money with Integrata's in-house seminars

You can also book all seminars from our open offer as in-house events. The focus is on your company and your employees. We offer you the opportunity to make individual requirements and adapt the content to your company.

The individual solution:

  • - Individual appointment
  • - Individual location, either in our training centers or on your own premises
  • - Upon request, individual content tailored to your needs


In-house seminars

The in-house package includes:

  • - Implementation as live online, hybrid or face-to-face training
  • - The implementation by field-tested and industry-experienced trainers

Additional costs may apply depending on the number of participants, accreditation or license fees. The price does not include, for example, room and entertainment costs, as well as additional costs for seminar materials.

Please do not hesitate to contact us and let us create your individual offer now.

Receive the program by email

The seminar program was further developed

You have chosen a date from the year, the seminar program has been further developed since then. Do you want to:

Consult the program of this training in or continue your booking

price

There are no additional delivery and shipping costs