Oracle database administration for Db2 DBAs

This 3-day ABIS training explains the Oracle database system to Db2 DBAs. Classroom training, interactive session. Focuses exclusively on Db2 users and specialists who will be working with Oracle. Knowledge of the Db2 system is therefore necessary.

This course compares the most important characteristics of the Oracle database system with Db2. The most important Oracle specifics are discussed in detail. At the end of this course, the participant will have a thorough overview of the most significant differences between Oracle and Db2.

At the end of this course:

  • the Db2 DBA understands the structure of the Oracle system;
  • the Db2 DBA has an insight into the logical and physical object structure of Oracle - and has an idea of ​​the differences between both systems;
  • the Db2 specialist has an idea of ​​the tools and utilities available in Oracle;
  • the Db2 specialist understands the difference between Db2 and Oracle locking behavior;
  • the participant has insight into Oracle security, Backup and Recovery, and SQL performance tuning.

Schedule a training?

Delivered as a live, interactive training: available in-person or online, or in a hybrid format. 
Training can be implemented in English, Dutch, or French.
If interested in organising this training internally, get in touch with us; we can even customise it to meet your specific needs.

REQUEST IN-COMPANY TRAINING

 

Public training calendar

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested? Please let us know.

Intended for

Analysts, programmers and database administrators who will use Oracle. Furthermore, anyone with sufficient Db2 background who wants to obtain a thorough insight of Oracle databases.

Background

General IT knowledge and familiarity with Db2 -at the level of application development- are required (see Db2 for z/OS fundamentals course).

You can test for yourself to see whether you have sufficient background by filling out the online self-test "Db2".

Main topics

  • The Oracle database system:
    • instance • database
  • Oracle physical object structure:
    • storage • tablespaces • segments, extents, blocks
  • Oracle logical object structure:
    • schema objects • generic schema observations • some object specifics (tables, indexes, views, partitions, ...)
  • Catalog:
    • catalog • performance tables
  • Security concepts:
    • logical vs physical security (integration with OS security mechanisms)
    • type privileges • roles
  • Undo management.
  • Basic utilities:
    • export/import • datapump • loader
    • backup/recovery
  • Locking in Oracle:
    • lock types • 'versioning' in Oracle vs explicit locking in Db2
  • Performance and tuning:
    • explain utility • trace
    • dynamic vs static SQL in Oracle

Training method

Live instructor-led training, with plenty of opportunities for hands-on exercises and discussion

Certificate

At the end of the course session, the participant receives a 'Certificate of Completion'.

Duration

3 days.

Course leader

Kris Van Thillo (ABIS).


SESSION INFO AND ENROLMENT