home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - OS/390 - z/OS » UNIX - Linux - AIX » Windows » VMwareDatabases, transaction systems and middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence and data warehouseApplication development » Methods and techniques » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
Oracle database administration for DB2 DBAs

Intended for

Analysts, programmers and database administrators who are going to use Oracle. Everyone -with a DB2 background- who wants to gain an insight into the Oracle RDBMS.

Background

General IT knowledge and familiarity with DB2 - level application development- are required (see course Using DB2 for z/OS).

Training method

Classroom instruction with exercises.

Course leader

Kris Van Thillo.

Duration

3 days.

Schedule

datelanguageplacepriceremarks
02/11/2010NWoerden1350 EUR
20/12/2010ELeuven1350 EUR
Legend
  • You can enrol by clicking on the dates in the calendar.
  • N: Dutch; F: French; E: English; No code: language depends on the participants.
  • All prices are VAT excluded.
  • Countries:
    Belgium 
    Netherlands 
    Elsewhere 

Objectives

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.

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