This course is designed for SQL Server database administrators (DBA's) looking to leverage their skills and experience to manage Oracle Database Management systems.

This course maps, compare and contrasts SQL Server database management to that of Oracle. Beyond mere guidelines, this course is a reference guide intended to be delivered and used in the workplace.
The course was developed to extend the terminologies familiar to the SQL Server DBA and to relate those terminologies to the Oracle world. This relate-and-learn approach can help you expand your knowledge to Oracle database administration.



Audience
Database Administrators
Database Developers



Ojectives:
Understanding of Database and Instances
Understanding of Instance Architecture
Understanding of Database Architecture
Schema and Data Objects
Manage Data Access
Perform Basic Administration
Manage Schema Operations
Protection and Security
Data Transport
Backup and Recovery
Performance Tuning
High Availability



Course Outline

Database and Instances
Terminology Concepts
Client Interaction with Database and Instance
Understanding Database Limits

Instance Architecture
Configuring a database server
Memory Architecture Overview
Understanding Processes and threads
Background Processes

Database Architecture
Schema and Data Storage
Tablespaces and Datafiles
Logging and Data Dictionary

Schema and Data Objects
Database Tables
Schema Objects
Data and data types
Non-Native Data Types
Beyond Relational

Data Access
Comparing Structured Query Language
Control and Procedural Statements
Developing Robust Queries

Basic Administration
Installing Oracle
Managing and Configuring Oracle
Working with Oracle Databases

Managing Schema Operations
Managing Tables, Constraints, Objectifers and Naming
Managing Triggers
Managing Indexes and Views

Data Protection and Security
Securing the Database
Understanding Privileges
Managing Users
Managing Roles

Data Transport
Getting Data Into and Out of Oracle
Understanding Oracle Data Pump
Other Transfer Methods - SQL*Loader

Backup and Recovery
Understanding Database Backups
Data Recovery
Backup and Recovery Tools and Solutions
Monitoring and Performance Tuning

Performance Tuning
SQL Server Performance Tuning
Managing Memory and Processes Oracle
Managing Database Interactions
Monitoring Availability and Errors
Monitoring Performance

Scalability and High Availability
Understanding Availability Features
Replicating Databases
Impact of Scale and Disaster Recovery
    

NOTE: THIS COURSE IS ALSO AVAILABLE IN SELF-STUDY E-LEARNING, TRAINING GUIDE OR DISTANCE LEARNING FORMATS. FEEL FREE TO ASK IF YOU PREFER DISTANCE, E-LEARNING OR TRAINING GUIDE LEARNING  FORMATS.PRICES DIFFER

What is a CBT?

CBT's are usually interactive with Software Simulations (behaves like you're using the real thing on the PC, therefore you don't even need the real software installed on your machine) and sometimes BUT NOT ALWAYS with voice. This Publisher's CBT Titles do NOT have voice..

Generally, CBT's tend to be more expensive. Our CBT Titles are NOT based on Flash. They are based on the latest technology which uses the: See It, Do It, and Try It learning paradigm. A very powerful new way of learning. All CBT and Courseware Learning formats are delivered with FULL LICENCE KEY.

Today's competitive business environment and frequent software updates by software vendors demands rapid skill acquisition. WebLearning Publishing helps you keep up-to-date by delivering quality Interactive Self-Study in CBT format. These factors give CBT's a clear advantage over conventional, inconvenient and expensive Classroom and Hard-copy print training methods.

CBT's not only offers the advantage in terms of convenience and lower cost, but it also facilitates improved subject-matter comprehension.

The WebLearning unique Methodology

All WebLearning® CBT and Courseware courses are based on the latest materials available at the time of publishing and are regularly updated every 3 months with FREE UPGRADES to the LATEST EDITION: A NEW, very effective and proven way of learning. 

FACT:

·        Material retention with CBT’S are 45% better than with conventional training methods

·        Your learning curve with CBT is 25%-55% less than conventional methods

·        The cost of CBT training is over 65% less than Classroom training

·        CBT’S are self pacing, interactive and simulate the actual software being studied