IBM - Oracle to DB2 Enablement Workshop

Kurs

In Düsseldorf

Preis auf Anfrage

Beschreibung

  • Dauer

    2 Tage

  • Beginn

    auf Anfrage

IBM - Oracle to DB2 Enablement Workshop : This basic course is for database administrators, database application designers, and database application programmers have the mission to convert a database and applications from an Oracle environment to DB2 would all benefit from attending this course.. This course is appropriate for those using DB2 in a z/Linux.. Gerichtet an: This basic course is for database administrators, database application designers, and database application programmers have the mission to convert a database and applications from an Oracle environment to DB2 would all benefit from attending this course.. This course is appropriate for those using DB2 in a z/Linux environment._x000D_. The purpose of this course is to teach enabling an Oracle database to a DB2 for Linux, UNIX, and Windows Version...

Standorte und Zeitplan

Lage

Beginn

Düsseldorf (Nordrhein-Westfalen, NRW)

Beginn

auf AnfrageAnmeldung möglich
Düsseldorf (Nordrhein-Westfalen, NRW)

Beginn

auf AnfrageAnmeldung möglich

Hinweise zu diesem Kurs

You should be able to: Discuss relational database concepts Code SQL Understand the basics of a programming language Understand the basic of stored procedure, function, and trigger in Oracle or DB2 These skills can be developed by attending: DB2 Family Fundamentals DB2 SQL Workshop DB2 Stored Procedures Programming Workshop

Fragen & Antworten

Ihre Frage hinzufügen

Unsere Berater und andere Nutzer werden Ihnen antworten können

Wer möchten Sie Ihre Frage beantworten?

Geben Sie Ihre Kontaktdaten ein, um eine Antwort zu erhalten

Es werden nur Ihr Name und Ihre Frage veröffentlicht.

Meinungen

Erfolge dieses Bildungszentrums

2020

Sämtlich Kurse sind auf dem neuesten Stand

Die Durchschnittsbewertung liegt über 3,7

Mehr als 50 Meinungen in den letzten 12 Monaten

Dieses Bildungszentrum ist seit 15 Mitglied auf Emagister

Themen

  • Java
  • C
  • C+
  • C++
  • SQL
  • C#
  • Basic
  • PL SQL
  • Linux
  • Windows
  • IBM DB2
  • IBM

Inhalte

KURSZIEL
IBM - Oracle to DB2 Enablement Workshop : This basic course is for database administrators, database application designers, and database application programmers have the mission to convert a database and applications from an Oracle environment to DB2 would all benefit from attending this course. _x000D_

_x000D_

This course is appropriate for those using DB2 in a z/Linux environment._x000D_

_x000D_

The purpose of this course is to teach enabling an Oracle database to a DB2 for Linux, UNIX, and Windows Version 9.7 environment. The workshop introduces DB2 and Oracle basic architecture, basic DB2 operations, DB2 9.7 Oracle compatibility features, enablement tools, and enablement process. _x000D_

_x000D_

Lectures and machine labs are used to explain how to enable Oracle database objects, tables, views, stored procedures, packages, triggers, and so on. Data movement and application conversion (C/C++, Java, Perl, and so on) are also explained. _x000D_

_x000D_

Learn how to utilize the facilities of the IBM Data Movement Tool, DB2 Command Line Process (CLP), DB2 Command Line Process Plus (CLPPlus) to extract DDL and PL/SQL code for Oracle database objects, perform minor changes if required, and enable the database object in a DB2 9.7 environment.

ZIELGRUPPE
This basic course is for database administrators, database application designers, and database application programmers have the mission to convert a database and applications from an Oracle environment to DB2 would all benefit from attending this course. _x000D_

_x000D_

This course is appropriate for those using DB2 in a z/Linux environment._x000D_

_x000D_

The purpose of this course is to teach enabling an Oracle database to a DB2 for Linux, UNIX, and Windows Version 9.7 environment. The workshop introduces DB2 and Oracle basic architecture, basic DB2 operations, DB2 9.7 Oracle compatibility features, enablement tools, and enablement process. _x000D_

_x000D_

Lectures and machine labs are used to explain how to enable Oracle database objects, tables, views, stored procedures, packages, triggers, and so on. Data movement and application conversion (C/C++, Java, Perl, and so on) are also explained. _x000D_

_x000D_

Learn how to utilize the facilities of the IBM Data Movement Tool, DB2 Command Line Process (CLP), DB2 Command Line Process Plus (CLPPlus) to extract DDL and PL/SQL code for Oracle database objects, perform minor changes if required, and enable the database object in a DB2 9.7 environment.

KURSINHALT
Kursziele
  • Start a DB2 instance
  • Stop a DB2 instance
  • Retrieve DB2 licensing and version information
  • Create the SAMPLE database
  • Configure a DB2 instance and database
  • Connect to a DB2 database and run SQL
  • Use IBM Optim Database Administrator to operate a database
  • Create a target database for Oracle enablement
  • Check DDL files extracted by the IBM Data Movement Tool
  • Modify the DDL files to fit a physical database design for an enablement project
  • Perform an interactive deployment with the IBM Data Movement Tool
  • Create database objects using a script
  • Move data from Oracle to DB2
  • Create DB2 objects using DB2 Command Line Plus (CLPPLus)
  • Check and correct unsupported syntax in the extracted DDL
  • Resolve the side effects of syntax change
  • Enable a Java program that connects to an Oracle database and issues a SELECT statement
  • Enable a Java program that calls a function
Themenübersicht
Agenda
Day 1
  • Welcome
  • Unit 1: Breaking free from Oracle with DB2 9.7
  • Unit 2: DB2 Fundamentals and Technology
  • Exercise 1: DB2 Fundamentals and Technology
  • Unit 3: Enablement Strategy and Tools
  • Unit 4: Enabling Database Structure
  • Exercise 2: Enable Database Structure
  • Unit 5: Moving Data to DB2
  • Exercise 3: Data Movement and Command Line Plus
Day 2
  • Unit 6: PL/SQL Enablement
  • Exercise 4: Enable PL/SQL Objects
  • Unit 7: Application Enablement
  • Exercise 5: Application Enablement
  • Unit 8: Other Enablement Topics
  • Exercise 6: Other Enablement Topics
  • Unit 9: New Features of DB2 9.7
  • Unit 10: Variety Solutions of DB2 9.7
Hinweise
Course material will be in English.


VORRAUSSETZUNG
You should be able to:
  • Discuss relational database concepts
  • Code SQL
  • Understand the basics of a programming language
  • Understand the basic of stored procedure, function, and trigger in Oracle or DB2
These skills can be developed by attending:
  • DB2 Family Fundamentals
  • DB2 SQL Workshop
  • DB2 Stored Procedures Programming Workshop

IBM - Oracle to DB2 Enablement Workshop

Preis auf Anfrage