Migrating to Oracle DB 10g: Migrating and Testing Oracle DatabaseTraining CBT/CD-Rom

Training Course Description / Outline:

Migrating to Oracle DB 10g: Migrating and Testing Oracle Database Computer Based Training CBT course covers fundamentals of the Oracle DB architectural framework. In this course, students will learn about Oracle DB 10g grid computing and administration. They will also go through key aspects of migration to Oracle DB and Oracle DB 10g installation. Further, they will learn about management of Oracle instances and database storage structures.

Learn To

• Differentiate between the SQL Server and Oracle database transaction models.
• Match transaction isolation levels provided by Oracle with their characteristics.
• Identify key features of the locking mechanism in the Oracle database.
• Identify features of PL/SQL.
• Identify features of PL/SQL objects.
• Identify the steps to migrate SQL Server objects to the Oracle database.
• Identify key aspects of migration testing methodology.
• Identify features of Oracle DMV.
• Identify modifications made to the properties file when installing DMV.
• Identify key aspects of configuring the Oracle Network environment.
• Sequence the steps to configure an Oracle Net Listener.
• Identify features of database service registration.

Training Audience

The Migrating to Oracle DB 10g: Migrating and Testing Oracle Database target audience for this course includes database administrators (DBAs), technical consultants, sales consultants, and support engineers.

Total Training Time

4 Hours

Training Objectives

Unit 1: Transactions and Data Concurrency

• Differentiate between the SQL Server and Oracle database transaction models.
• Match transaction isolation levels provided by Oracle with their characteristics.
• Identify key features of the locking mechanism in the Oracle database.
• Match Oracle database lock modes with their characteristics.
• Identify ways of detecting and resolving lock conflicts in the Oracle database.

Unit 2: Migrating Stored Procedures and Triggers

• Identify features of PL/SQL.
• Identify features of PL/SQL objects.
• Identify the steps to migrate SQL Server objects to the Oracle database.
• Identify features of the Migration Workbench parser.
• Identify the steps to resolve parser errors.
• Identify manual tasks for completing PL/SQL migration.

Unit 3: Testing Migrated Oracle Database

• Identify key aspects of migration testing methodology.
• Identify features of Oracle DMV.
• Identify modifications made to the properties file when installing DMV.
• Identify key aspects of using DMV.
• Identify guidelines for creating and running test cases.
• Identify the steps to test a migrated database.

Unit 4: Oracle Network Environment

• Identify key aspects of configuring the Oracle Network environment.
• Sequence the steps to configure an Oracle Net Listener.
• Identify features of database service registration.
• Match Oracle Net naming methods with their features.
• Identify the steps to configure service aliases.
• Match advanced connection options in Oracle with the connection functionalities that they enable.
• Identify the steps to establish a connection to a dedicated server.
• Identify features of user sessions.
• Identify the steps to process a request.
• Identify considerations for configuring Oracle Shared Server.