Canada IT Courses
ExitCertified US




ExitCertified - Excellence in IT Certified Education
 
IT education classes
IT training feature sheet
 
   
 
start > courses and registration > training feature sheet
Migrate from SQL Server to Oracle Database 10g
 
 
 
 
oracle certified training  
 
code. 10g-MIGRATE-SQL   length. 5 days
type. Instructor-Led   partner. Oracle
price.
$3,000 :: contact for GSA GOV.
 
 
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.
 
course schedule  
 
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.
   
Request course date Request on site training
 
who can benefit
  
 

Database Administrators
Support Engineer
Technical Consultant
 
skills gained
  
 

Perform a database migration to Oracle Database 10g using Oracle Migration Workbench
Compare and contrast the database architecture and design between Oracle Database 10g and Microsoft SQL Server 2000
Install Oracle Database software and create a database
Configure and manage the Oracle Network environemnt
Manage database storage structures
Administer users and security
Backup and recover the Oracle Database 10g
Monitor the database and use advisors
 
suggested next courses:
  
 

Oracle Database 10g: Program with PL/SQL
Oracle Database 10g: SQL Tuning Workshop
 
related courses:
  
 

Oracle Database 10g: 2 Day DBA NEW
Oracle Database 10g: Administration Workshop I NEW


 
course content details  
 


  Installing Oracle Software and Creating the Oracle Database

Install the Oracle 10g database using Oracle Universal Installer
Create a database as part of the installation


  Database Architecture Comparison

Compare SQL Server and Oracle Database 10g concepts at a high level
Explore Oracle Database 10g architecture (Control file, online redo log, tablespace, data file, segment, extent, block, Oracle instance, data dictionary, memory and processes)
Use Database Configuration Assistant to create an additional database


  Managing the Oracle Instance

Use Windows Services to check the status of Oracle processes
Administer two databases using Oracle Enterprise Manager
Modify initialization parameters
Stop and start the Oracle Listener
Startup and shutdown the Oracle instance and explain the different stages of the start-up and shut-down operations
Compare automatic and manual memory management of the SGA
View the Alert log
Access databases with SQL*Plus and iSQL*Plus


  Managing Database Storage Structures

Define the purpose of tablespaces and data files
Create and manage tablespaces
Describe dictionary versus locally managed tablespaces
Obtain tablespace information
Understand the main concepts and functionality of Automatic Storage Management (ASM)


  Administering Users

Create and manage database user accounts
Create and manage roles
Grant and revoke privileges (system privileges and object privileges)
Control resource usage by users


  Managing Schema Objects

Compare Oracle Database 10g and SQL Server: data objects, data types and the use of temporary tables
Create and modify database schema objects: tables, columns, constraints, indexes, views and sequences
Remove schema objects: delete or truncate


  Planning a Migration

Establish and follow a migration methodology
Plan how to migrate key components in a database migration
Select the appropriate Oracle migration tools
Assign key roles for a migration project


  Getting Started with Oracle Migration Workbench

Identify key components of OMWB
Install Oracle Migration Workbench software
Configure OMWB to connect to SQL Server and Oracle Database 10g
Create database users with appropriate permissions to access SQL Server and Oracle databases
Create the OMWB repository to store migration information


  Performing a Database Migration Using Oracle Migration Workbench

Identify the three stages in the OMWB workflow process
Capture the source database using the online and offline capture methods
Create and customize the Oracle Model
View the log file to correct errors and warnings
Use SQL*Loader to load data into the Oracle database
Identify objects migrated by Oracle Migration Workbench
Analyze the migration process using OMWB reports


  Application Migration Overview

Identify incompatibilities between Oracle Database 10g and SQL Server that affect application migration
Explain the key features of Oracle jDeveloper Application Migration Assistant


  Migrating SQL Statements and Managing Transactions and Data Concurrency

Describe SQL incompatibilities between Oracle Database 10g and SQL Server
Convert SQL statements to run in an Oracle database
Describe the Oracle transaction model and its differences to SQL Server
Describe the isolation level differences between Oracle database and SQL Server
Apply knowledge of the differences to plan for a database migration
Detect and resolve deadlocks


  Migrating Stored Procedures and Triggers

Identify PL/SQL objects
Compare and contrast SQL Server and Oracle database triggers
Use Oracle Migration Workbench to migrate stored procedures and triggers
Identify manual conversion tasks to complete PL/SQL code migration
Identify configuration options that affect PL/SQL performance


  Testing the Oracle Database

Use Oracle Migration Verifier to verify the schema and data migrated successfully
Apply guidelines to design and run test cases on the migrated Oracle database


  Configuring the Oracle Network Environment

Describe the Oracle Network configuration
Control the Oracle Net Listener
Create a backup listener to support connect-time failover
Configure a client to access the database
Describe Oracle Shared and Dedicated Servers


  Implementing Security

Compare security features between SQL Server and Oracle Database 10g
Apply the principal of least privilege
Manage default user accounts
Implement standard password security features
Describe Oracle database auditing


  Monitoring and Tuning the Database

Set warning and critical alert thresholds
Collect and use baseline metrics
Use tuning and diagnostic advisors
Use the Automatic Database Diagnostic Monitor (ADDM)
Manage the Automatic Workload Repository (AWR)
Monitor performance
Gather and view optimizer statistics


  Managing Undo Segments

Monitor and administer undo segments
Configure and guarantee undo retention: Automatic versus Manual Undo Management
Use the Undo Advisor


  Configuring for Recoverability

Identify the types of failure that may occur in an Oracle database
Describe ways to tune instance recovery
Identify the importance of checkpoints, redo log files, and archived log files
Configure ARCHIVELOG mode
Configure the flash recovery area


  Performing Backups and Recovery

Create consistent database backups
Back up your database without shutting it down
Create incremental backups
Automate database backups
Recover from loss of a control file
Describe recovery tasklist for loss of: control file, redo log file, non-critical and system-critical data file in ARCHIVELOG mode and loss of a data file in NOARCHIVELOG mode


  Preferring the Past: Flashback

Describe Flashback database
Manage the recycle bin
Describe Flashback versions query to recover from user errors
Describe Flashback Transaction query to perform transaction level recovery
Perform Flashback table operation



 
Organize your IT training. Contact an expert training consultant to put together the best training package for your organization.


ExitCertified - Oracle 100% Student Satisfaction


find a course
 
phone us
 
view course schedule





Rock solid authorized training. Search all courses now...

 
go to top
Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education
© 2008 ExitCertified. All rights reserved.
terms of use and disclaimer :: privacy policy :: webmaster :: link to us
   
Sacramento Training :: 916.669.3970 | Las Vegas Training :: 1.800.803.EXIT (3948) | San Francisco Training :: 415.975.3948 | San Jose Training :: 408.288.EXIT (3948)
Phoenix, Arizona Training | Los Angeles, California Training | San Diego, California Training | Broomfield, Colorado Training | Fort Lauderdale, Florida Training
Tampa, Florida Training | Atlanta, Georgia | Downers Grove, Illinois | Kansas City, Kansas Training | Portland, Maine Training | Baltimore, Maryland Training | Burlington, Massachusetts Training
Troy, Detroit, Michigan Training | Minneapolis, Minesota Training | St. Louis, Missouri Training | Omaha, Nebraska Training | Edison, New Jersey Training | New York City, New York Training
Raleigh, North Carolina Training | Columbus, Ohio Training | Philadelphia, Pennsylvania Training | Nashville, Tennessee Training | Dallas, Texas Training
Houston, Texas Training | Hampton, Virginia Training | Madison, Wisconsin Training | Seattle, Washington Training

ExitCertified is a global provider of authorized technology training. Some of our popular course topic searches include:

Java Training | J2EE Training | JSP Training | Java Courses | Servlets Training | EJB Training | Struts Training | Networking Courses | Solaris Training
Red Hat Training | SUSE Training | XML Training | Oracle SQL | Oracle PL/SQL | DBA Training | DBA Certification | Oracle Certification
RedHat Training | Solaris Certification | Java Certification | Veritas Certification | PeopleSoft Training | 11g Training | 11g Certification
RedHat Courses | SQL Training | 10g Training | 9i Training | Application Development Training | Certified Training | Corporate Training
Government Training | Course Catalogue | Training Schedule | Certification Training | Project Management Training | Linux Training
Solaris 10 Training | Unix Training | NetBackup Training | Virus Protection Courses | Education Technology Newsletter | zSeries Training
s/390 Training | iSeries Training | DB2 Training | OS/400 Training | AIX Training | Rational Courses | PMI Training | Project Management Training
SeeBeyond Training | Java Composite Application Platform (JCAPS) Training | MySQL Training | MySQL Database Course | Hyperion Training | Fusion Middleware