Microsoft MCSD MCAD VB.NET Exam 305 306 Programming Category  > Directory Certification Training Course Curriculum >

mcse ccnp oracle boot camp cissp ccna a+ orlando, chicago, scottsdale, san diego, New Jersey, Florida, New York, Illinois
Home Page Training
Oracle Certification
Oracle 11i Certification
Oracle 11i Training Courses
Oracle 11i  Administration
E-Business 11i  Admin
Oracle 11i General Ledger
Oracle 11i Project Foundation
Oracle 11i Workflow
Oracle 10G DBA OCA Certification
Oracle 10G DBA OCP  Certification
Oracle 10g Developer OCA
Oracle 10G Reports Training
Migrating to Oracle 10G
OracleBI Discover Admin Training
Oracle BI Discoverer Plus

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. freedemo
    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. courses online and cds
    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.

 

 Cisco®, Cisco Systems®, CCDA™, CCNA ™, CCDP™, CCNP ™, CCIE™, CCSI™, the Cisco Systems logo Networking Academy and the CCIE logo are trademarks or registered trademarks of Cisco Systems, Inc and/ or its affiliates in the U.S and certain other countries. All other trademarks mentioned in this document or Web site are the property of their respective owners . 

Netwind Learning Center

United Kingdom Hours 2:00 pm to 8:00 pm
International Phone Number 561.381-0322
sales@netwind.com
webmaster@netwind.com
Copyright  © CDi Communications Inc. 1996-2008
Netwind Learning Center is a registered trademark of CDi Communications, Inc.

*30-Day Guarantee applies only if products purchased are returned with 50% of one product unopened. For example if product purchased contains 6 videos, 3 must remain unopened
.