Migrating to Oracle
Training Class
© 2007-2016
by Burleson Corporation
* Understand SQL Developer
Migration tools and the Oracle Migration Workbench .
* See real world examples
for migrating to Oracle.
* Save hours of time
by recognizing potential Oracle migration pitfalls.
* Learn the risks for
each methods of migrating to Oracle.
* Avoid tedious and
risky manual Oracle migrations.
* Migrate to Oracle with minimum
downtime and hassle.
* Understand how to
convert T-SQL and C to PL/SQL
* Migrate course
content is customized to your specific learning needs, offering for migrating
from MySQL, MS SQL (SQL Server) and DB2.
|
|
This migration to Oracle course examines all
of the common processes involved when you migrate to Oracle, training with an eye on
working secrets and tips for migrations with minimum unplanned downtime.
This Oracle migration training course is special because
it is taught by a veteran Oracle Certified DBA with many years of full-time experience.
This course is designed for practicing
database professionals who have basic experience with relational databases. Prior
experience with Oracle is not required, but experience in Oracle concepts is
beneficial.
|
This course was designed by Donald K. Burleson, an acknowledged
leader in Oracle database administration. Author of more than
30 database books, Burleson was chosen by Oracle Press to write
five authorized editions, including Oracle High-Performance SQL
tuning. Burleson also served as the Editor for the
premier book
Migrating
to Oracle by Rampant TechPress. Burleson Corporation instructors offer
decades of real world DBA experience in Oracle features, and they
will share their Oracle secrets in this intense Oracle Migration
training class.
Course Duration
This is an
intensive 3-day Migrating to Oracle from other relational databases.
The course topics are customized to meet your needs and can focus on migrating
from Sybase, migrating to Oracle from SQL Server (MS-SQL) and migrating to
Oracle from DB2.
Migrating to Oracle
Class
3-Day Training Syllabus
Copyright © 2016 by
Donald K. Burleson
|
DAY
1
Introduction to Database Migration
Overview of database migration
Manual
procedures for migration
The Oracle Workbench
Migration
Basic Training for Planning the Migration
Database Architecture differences and Oracle 10g
SQL differences and Oracle SQL
Stored Procedures and
Oracle PL/SQL
Why Oracle Migration Workbench is the
Preferred Method
Overview of the Oracle Migration
Workbench
Introduction to the Oracle Migration Workbench (OMWB)
Oracle Migration
Workbench and Oracle APEX Workbench
Oracle SQL Developer
Architecture of
the Oracle Migration Workbench
Installation for Oracle Migration Workbench and the APEX Migration Workbench
Pre-requisites
Installation Procedures
Oracle
Migration Workbench
Oracle APEX Migration
Oracle SQL Developer
Install the Plugin for the Oracle Migration
Workbench
Configuration
Tasks for Oracle Migration Workbench
Building the Source and Target Models
Choose between Online and
Offline Data Capture Advantages of
Online Capture Method
Disadvantages of Online
Capture Method
Advantages of Offline Capture
Method
Disadvantages of Offline Capture Method
Which is the best method for your environment?
DAY 2
How to Perform Online Capture with
Oracle Migration Workbench
Automation Process
Configuration Parameters
Oracle SQL Developer Migration Workbench
Online
Capture with SQL Developer
Quick Migration with SQL Developer
How to Perform Offline Capture with
Oracle Migration Workbench
Offline Capture with SQL
Developer and Oracle Migration Workbench
Scripts for use with Microsoft SQL
Server
Bcp scripts for offline capture
Scripts
for use with Sybase Adaptive Server
Scripts for use with IBM DB2 UDB
Scripts for use with mySQL
Scripts for use with Informix
|
|
The steps of mapping the Source Model
to Target Database
Building the Source Model with Oracle Migration
Workbench
Building the Source Model with SQL Developer Migration Workbench
Using the Oracle Migration Workbench Editors
Tablespace
Discovery Editor
Code Parser Editor
Mapping the new
Source Model to the Target Model Problem Resolution
Complete the
initial migration
Understanding SQL Developer and
Oracle Migration Workbench utilities
Using Oracle Migration
Workbench Verification tool
Using Oracle Migration Workbench Editors
Using Oracle APEX Migration with Workbench Migration
How to configure
plugins with Migration Workbench
Oracle Migration Testing
Data Verification
Testing
Performance Tuning
User Acceptance
Testing
Quality Assurance (QA) Testing
DAY 3
Manual database migration
Loading Oracle tables
Punching table data for loading into
Oracle
Using SQL*Loader to load rows
Migrating
indexes to Oracle
Overview of Oracle
index types
MySQL to Oracle create index syntax
SQL Server to
Oracle create index syntax
Migrating to PL/SQL
- Removing process logic with advanced
SQL (e.g. using "order by" to replace a sort, using CASE to replace an IF
statement, using rollup and cube for aggregation)
- Boolean logic, IF
statements
- Loops - while, for repeat until
- Calling Java from
PL/SQL
- I/O conversion (utl_file, etc.)
- Creating built-in
functions in PL/SQL
- Using the Oracle API's within foreign applications
Optional Oracle Migration Topics:
MS-SQL SL Server SQL to Oracle SQL
Migrating MySQL SQL to Oracle SQL
Migrating DB2 SQL to Oracle SQL
Changing C programs to access Oracle
Changing PHP programs to access Oracle
|
This is a BC Oracle training
course (c) 2007-2016
|
| |
|
