IBM - Oracle to DB2 Enablement Workshop

PROKODA Gmbh
In Düsseldorf

1.390 
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
0221/... Mehr ansehen

Wichtige informationen

Beschreibung

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...

Wichtige informationen
Veranstaltungsort(e)

Wo und wann

Beginn Lage
auf Anfrage
Düsseldorf
Kanzlerstraße 4, 40472, Nordrhein-Westfalen, NRW, Deutschland
Plan ansehen
auf Anfrage
Düsseldorf
Monschauer Str. 7, 40549, Nordrhein-Westfalen, NRW, Deutschland

Häufig gestellte Fragen

· Voraussetzungen

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

Themenkreis

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

Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen