Oracle Database Administration Tutorial - Training Videos

Training CDs > Certification Tutorial Videos > ORACLE DATABASE ADMIN

Oracle Database Administration Tutorial CD

Affordable Training you can depend on
This Oracle Database Administration video tutorial utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that brings a high degree of visual clarity to even the most complex applications. Being over 8 hours long these Oracle Database Administration tutorials are extremely comprehensive and easy to follow. Video Training by Experts - Low Cost.

Not sure which Training CDs to buy?
The Online University allows unlimited access to the entire range of training titles for one low fee of only $30 per month. There is no fixed term, no limits, and you can cancel at any time. For corporate users and schools we also offer multi user accounts.
Find out more about the online video tutorials »

About the Free Video Online Training Course Demos
To allow you to evaluate the quality of the Oracle Database Admin training course we have made the first 3 chapters of this tutorial available for free viewing online, the purchased version of this training course contains all the topics listed below. The free demos below have been compressed for faster playback over the internet, the audio and video quality of the purchased CD / DVD is far greater. To play the free demo videos you will need QuickTime,

THIS TUTORIAL COVERS THE FOLLOWING SUBJECTS

Description

The visual nature of this Oracle Database Admin tutorial videos ensures that users of all levels can learn faster than with any other method of training, users will also benefit from a much higher retention rate then with conventional forms of training. All courses are created using expert authors and recorded with studio quality audio and video, users can expect to receive the same high standard of training that would be taught on a dedicated classroom based course, but for a fraction of the cost.

Users have total control over the speed at which they learn, lessons can be stopped, rewound or fast forwarded at any time, this video tutorial is structured to accommodate both beginner and intermediate users, ideal for people that need to fit comprehensive training into a busy schedule. To sample a free demo of this Oracle Database Administration training video click one of the links below.

Oracle Database Administration Related Groups

Hide Description

The Blue Links below are free demos, when you purchase the video training CD / DVD the enitre content listings below are included , not just the free demo videos.

Welcome to these Tutorials

Introducing Oracle Net Services

Introducing Backup - Recovery Options - Utilities

Oracle Net Services Architecture

Oracle Net Services Architecture
The Open Systems Interconnection (OSI) Model
Oracle OSI Model
Protocols
Net Services Communication
Dedicated and Shared Connections
Shared Server Processes and Dispatchers

Configuring a Simple Connection

The Listener Configuration File
The TNS Names Configuration File
The Profile Parameters File
Basic Database Configuration Parameters Tutorials 1
Basic Database Configuration Parameters 2
Using the Net Configuration Assistant 1
Using the Net Configuration Assistant 2

The Oracle Listener

What is the Listener? 1
What is the Listener? 2
Basic Listener Configuration
The Listener Control Utility
Service Registration
Listener Queue Size
Switching Off Listener Logging and Tracing
Timeouts
Multiple Listeners Tutorials 1
Multiple Listeners 2
Connection Load Balancing and Failover
The Session Data Unit Buffer (SDU)
Connection Profile Configuration

Connection Strings and Naming Methods

Connection Strings
Naming Methods
Local Naming Using TNS
Host Naming
External Naming
Directory Naming Tutorials 1
Directory Naming 2
Oracle Names Server

Oracle Shared Servers

Multithreaded Server
Introducing Dispatchers
Dispatchers and Connection Pooling
Other Shared Server Parameters
Overriding Shared Servers

Connection Manager

What is Connection Manager?
Connection Concentration
Multiple Protocol Support
Configuring Connection Manager

Other Oracle Net Services Utilities

Other Oracle Net Services Utilities

Oracle Net Services Advanced Features

What is TAF?
TAF Parameters
Configuring TAF
Non-Oracle Database Connections

Oracle Net Services Metadata

Performance Views

Backup and Recovery

What is Backup and Recovery?
Why Backup and Recovery?
Things to Remember
Things to Consider with Datafiles
Redo Logs
Controlfiles
Archive Logs
More Things to Consider
Yet More Things to Consider
Importance of Backup and Recovery
Points of Failure
Backup Strategy

How Backup and Recovery Works

Processes/Memory Structures/Checkpoints
All the Files
SCNs
Restore and Recovery

Oracle Archive Configuration

Basic Archive Configuration Parameters
Archive Log Mode Configuration Tutorials 1
Archive Log Mode Configuration 2
Multiple Archiving Processes
Multiple Archive Destinations
Standby Oracle Archiving 1
Standby Archiving 2

Logical Backups Using Exports

Full Exports and Imports
Schemas
Multiple Schemas
Importing to a Different Schema
Tables
The Parameter File
Export and Import Options

Physical Backup/Restore/Recovery

Cold Backups
Hot Backups
Verify Backups Using DBVERIFY
Recovering using Offline Physical Backups
Recovering using Online Physical Backups
Read Only Tablespaces
Incomplete Recovery
Scripting Hot Backups

RMAN (Recovery Manager)

What is RMAN?
Repository and Catalog
The Recovery Catalog
RMAN Architecture
What is a Channel?
Allocating and Releasing Channels
Creating an RMAN Database
Creating a Repository
Connecting to RMAN
Registering Databases with the Repository
Viewing the Repository
Backup Sets
Types of Backups
Controlfile Backups
Datafile Backups
Tablespace Backups
Archive Log Backups
Binary Parameter File Backups
Database Backups
Incremental Backups
Restore and Recovery
Restore and Recovery in Action
Scripts and RMAN
Deleting RMAN Backups

Oracle Enterprise Manager Backup and Recovery

Configuring Oracle Enterprise Manager
Communications
Win2K Log on as Batch Job
Export
Import
Backup and Recovery

Backup and Recovery Metadata

Oracle Performance Views

Transportable Tablespaces

What are Transportable Tablespaces?
Uses of Transportable Tablespaces
Limitations
Tablespace Sets
Tablespace Set Verification
Transporting a Tablespace Set
Plug In

Oracle SQL*Loader

What is SQL*Loader?
The Control File and Complexity
Input Data File
Input Data File Structures
How Rows are Loaded
Multiple Tables and Formats
Column Delimiters
NULL Values
Oracle Load Filtering
Filler Fields
Oracle Data Types
Conditional Replacement
Using SQL
Generating Data Not in Input Files
Executing SQL*Loader
Conventional Versus Direct
The Parameter File
A Simple Example Load Tutorials 1
A Simple Example Load 2
Oracle Enterprise Manager

Oracle Database Admin Tutorials - VIDEO INFO

» Studio quality audio and video
» Works on Pc or Mac
» Ideal for people that learn quicker by being shown
» Master complex application in days

Title	:	Oracle Database Administration
Instructor	:	Gavin Powell
Price	:	US$ 99.95
Duration	:	8 hours - 181 Movies
OS	:	Win Vista XP 98,2000,ME. Mac OS 9, OS X
Delivery Options	:	Ground / 2 day / Next Day
Product Code	:	33488

BENEFITS OF THIS TRAINING COURSE

Master Oracle Database Admin in the shortest time possible
Self paced tutorial, training on video, at your own pace
Just sit back and watch, no books to read, just easy to follow lessons
Training can be viewed from any location, on PC or Mac
All training is self-contained; you don’t even need the application you are learning loaded on your machine
The most affordable way to learn, benefit from a world-leading expert
High quality content for a fraction of the cost of a classroom training course
The Tutorials can be rewound, fast forwarded or stopped at any time
Learn from the comfort of your own desk.