Oracle Database 10g Migrating from SQL Server Training
 Included with this training program:
- Interactive Multi-Media Training with Audio Track
- Practice simulated lab exercises
- Training Time: Over 25 hours of training
- Interactive Review questions
- Available in CD-ROM or Online formats
- Co-developed training with Oracle. Guarantees that your training will cover 100% of the certification's exam objectives.
- Audience
The target audience for this course includes database administrators (DBAs), technical consultants, sales consultants, and support engineers.
.
|
CD-ROM Oracle 10G Migrating from SQL Course
|
N67421DC
|
$299.00
|
|
|
Online Oracle 10G Migrating from SQL Course One Year Access
|
N67421DO
|
$299.00
|
|
|
Oracle 10G Migration from Server Training includes the following:
Oracle Database Architectural Framework
Course Training Overview
This course covers fundamentals of the Oracle DB architectural framework. In this course, students will learn
about DB 10g grid computing and administration. They will also go through key aspects of migration to DB
and DB 10g installation. Further, they will learn about management of Oracle instances and database storage structures.
Participants will learn
Identify key aspects of storage for locally managed tablespaces.
Identify key aspects of tablespaces and data files. 
Sequence the steps to create a new tablespace.
Identify features of initialization parameter files.
Identify key aspects of Oracle DB instance startup and shutdown.
Identify features of the Database 10g management framework.
Identify options used to create an database using the Database Configuration Assistant.
Match Oracle instance components with their features.
Match Oracle database objects with their features.
Sequence the steps for installing Database 10g.
Identify prerequisites for Database 10g installation.
Identify key Database 10g features that help address common database management challenges.
Match Oracle products with their descriptions.
Identify functions of DBAs.
Schema Objects and Planning Migration
Course Overview
This training course covers fundamentals of schema objects and migration planning. In this course, students
will learn about administering users and managing schema objects. They will also go through key aspects of
pre-migration activities, Oracle Migration Workbench installation, and creating a Workbench repository. Further, they will learn about connecting to the source and destination databases.
Participants will learn
Sequence the steps to create a Workbench repository user.
Sequence the steps to install the Oracle Migration Workbench software.
Identify features of Migration Workbench. 
Identify key requirements for a migration project.
Identify tasks performed during the four phases of a migration project.
Identify guidelines for naming database objects.
Identify key aspects of implementing schema objects.
Identify features of schemas.
Identify features of user profiles.
Identify features of a database user account.
Compare security features of SQL Server with those of Database 10g.
Performing Migrations with OMWB
Course Overview
This course covers fundamentals of the DB architectural framework. In this course, students will learn about
DB 10g grid computing and administration. They will also go through key aspects of migration to DB and DB 10g installation. Further, they will learn about management of Oracle instances and database storage
structures.
Participants will learn
Distinguish between SQL Server statements and Oracle SQL statements with respect to connectivity and object naming features.
Identify key guidelines for migrating SQL statements.
Identify features of SQL.
Identify features of AMA.
Identify key issues related to application migration.
Identify features of application architecture.
Sequence the steps to perform an offline capture.
Sequence the steps to perform an online capture of SQL Server training.
Identify features of the source database capture process.
Migrating and Testing Oracle Database
Course Overview
This course covers fundamentals of the 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 DB
and DB 10g installation. Further, they will learn about management of Oracle instances and database storage structures.
Participants will learn
Identify features of database service registration.
Sequence the steps to configure an Net Listener.
Identify key aspects of configuring the Network environment.
Identify modifications made to the properties file when installing DMV.
Identify features of DMV.
Identify key aspects of migration testing methodology.
Identify the steps to migrate SQL Server objects to the database.
Identify features of PL/SQL objects.
Identify features of PL/SQL.
Identify key features of the locking mechanism in the database.
Match transaction isolation levels provided by Oracle with their characteristics.
Differentiate between the SQL Server and database transaction models.
Securing and Managing Oracle Database
Course Training Overview
This course covers fundamentals of the DB architectural framework. In this course, students will learn about
DB 10g grid computing and administration. They will also go through key aspects of migration to DB and DB
10g installation. Further, they will learn about management of Oracle instances and database storage structures.
Participants will learn
Match network, media, and user error failures with their possible solutions.
Match statement and user process failures with their possible solutions.
Match categories of failures that may occur in an Oracle database with their descriptions.
Identify key aspects of configuring and guaranteeing undo retention.
Identify key considerations for monitoring and administering undo segments.
Identify characteristics of undo data.
Match tuning and diagnostic advisors with their functions.
Identify the steps to capture a baseline.
Identify key considerations for setting alert thresholds.
Identify guidelines for applying the principle of least privilege.
Identify guidelines for implementing database security in Oracle.
Identify similarities and differences in the security features supported by Database 10g and SQL Server.
Oracle Database Backup and Recovery
Course Overview
This course covers concepts related to database backup and recovery. In this course, students will learn
about types of backups as well as backup activities, including configuring backup settings, scheduling
backups, and managing backups. In addition, they will learn about recovering backup data. Further, they will
learn about concepts related to Flashback technology, including Flashback Drop, Recycle Bin, Flashback Versions Query, Flashback Transaction Query, and Flashback Table. Finally, they will learn about typical
migration considerations, including formatting tasks, logically correct tasks, performance improvements, and other necessary tasks.
Participants will learn
Identify performance improvement tasks performed during migration.
Identify logically correct tasks performed during migration.
Identify formatting tasks performed during migration.
Sequence the steps to flash back dropped tables using Enterprise Manager.
Identify considerations for using Flashback Database.
Match data corruption scenarios with Flashback operations training.
Identify key aspects of scheduling backups.
Identify key aspects of configuring backup settings.
Match database backup terms with their descriptions.
|
