DBA Fundamentals

Catalyst Learning
London, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' By the end of this course, the delegate will have been given practical experience in creating and managing an Oracle9i database and in using the various Oracle backup and recovery commands. The delegate will also have had practical experience in configuring Net Architecture, the Oracle Shared Server and the Listener. Experience of troubleshooting backup and recovery and simple network problems will also have been gained. The main examination topics for the Oracle9i Database Fundamentals I (IZ0-031) and the Backup and Recovery and Networking topics of the Oracle9i Database Fundamentals II (IZ0-032) exams are also covered in this course.

Topics Covered:

Creating an Oracle database
Managing an Oracle instance
Altering an Oracle database
Managing disk space, tablespaces and datafiles
Managing redo log files and control files
Managing rollback segments and undo data
Managing temporary segments
Managing tables and indexes
Managing users, profiles, privileges and roles
Maintaining Database Security
Backup and Recovery Strategies
Disaster Recovery Plan
Failure Scenarios
Oracle Recovery Structures and Processes
Using ARCHIVELOG and NOARCHIVELOG Modes
Physical Backups
Complete Database Recovery
Incomplete Recovery with Archiving
The Export and Import Utilities
Loading Data with SQL*Loader
Troubleshooting Utilities
Recovery Manager Overview
Creating and Maintaining a Recovery Catalog
Backing up and Restoring with RMAN
Data Guard Architecture
Configuring the Oracle Network
Oracle Net Architecture and Net Configuration
Oracle Net Manager and Configuration Assistant
Net Server and Client Side Configuration
Listener Configuration
Configuration of Net Service Names
Configuration of the Oracle Shared Server
Overview of Oracle Internet Directory
Troubleshooting the Network Environment
Network Environment Security

Requirements:

A working knowledge of SQL*Plus is required. This can be obtained by attendance on the Oracle SQL*Plus course. A good working knowledge of operating system commands is also required.
...''

Phone:0800 953 0387

School Address:

175 Tottenham Court Road
London, W1T 7NU
UK

Jobs & Resumes: London
Houses & Roommates: London

Novell
Relational Databases
Introduction to SQL
ORACLE Overview
PL/SQL
ORACLE Fundamentals
Oracle Program with PL/SQL
PL/SQL Web Applications
SQL Performance Tuning
Forms Web Deployment
Oracle Database 10g DBA using Enterprise Manager
10g Discoverer for Administrators
Oracle 10g Application Server Administration
Oracle 11i System Administration
Oracle Financials

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent.