On-line training course catalogue

Migrate from SQL Server to Oracle Database 10g

Type of course: Classroom

Course details

Fee	£2100
Days	5
Course code	OR10GMSQL

We currently do not have public dates scheduled for this course.
If you have a requirement for this course, please contact us for the latest course information.

Print this page | Download as Word document |

Overview

Please note that Oracle courses running at London training centres are subject to a 5% surcharge.

This course is designed for the SQL Server DBA preparing to migrate to Oracle Database 10g. Students gain a conceptual understanding of the Oracle database architecture, design, and implementation through a compare and contrast approach. In class, participants apply best practice guidelines to plan for and perform the migration using Oracle Migration Workbench. The course also covers performing common database administration tasks in the Oracle database after the migration. The lesson topics are reinforced with structured hands-on practices.

This course is designed for

• Database Administrators
• Support Engineer
• Technical Consultant

Outline

• Installing Oracle Software and Creating the Oracle Database
• Database Architecture Comparison
• Managing the Oracle Instance
• Managing Database Storage Structures
• Administering Users
• Managing Schema Objects
• Planning a Migration
• Getting Started with Oracle Migration Workbench
• Performing a Database Migration Using Oracle Migration Workbench
• Application Migration Overview
• Migrating SQL Statements and Managing Transactions and Data Concurrency
• Migrating Stored Procedures and Triggers
• Testing the Oracle Database
• Configuring the Oracle Network Environment
• Implementing Security
• Monitoring and Tuning the Database
• Managing Undo Segments
• Configuring for Recoverability
• Performing Backups and Recovery
• Preferring the Past: Flashback