Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality.
Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials Please do not hesitate to contact us for download help.
Oracle Database Administration Fundamentals II Tutorial
Professionally created, self-study video training.
This beginners Oracle Database tutorial covers Oracle Certification course #1Z0-032, and more. All the important exam objectives and course material are explained in an easy to follow manner ensuring that you'll become an accomplished Oracle programmer in a very short space of time! This course is presented using step by step video training movies and you can evaluate these right now, click any of the blue linked lessons below for FREE beginners Oracle database tutorials...
Try this training now - See below for FREE tutorials
Each Course on 1 or 2 CDs
For Mac and PC FREE Shipping on all Orders
CD CONTENTS & FREE VIDEO TUTORIALS
Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left
We hope you enjoyed the FREE lessons above. To view the complete contents, including the chapters below, please purchase the CD. CLICK HERE TO BUY THIS CD
Oracle Net Services Architecture
Chapter Overview
The Open Systems Interconnection (OSI) Model
Oracle OSI Model Overview
Protocols Explained
Net Services Communication
Dedicated & Shared Connections
Shared Server Processes and Dispatchers
Configuring a Simple Connection Listener Configuration File Explained
TNS Names Configuration File
Profile Parameters File
Simple Database Configuration Parameters - Lesson 1
Simple Database Configuration Parameters - Lesson 2
Working with the Net Config. Assistant - Lesson 1
Working with the Net Config. Assistant - Lesson 2
The Listener The Listener Explained - Lesson 1
The Listener Explained - Lesson 2
Basic Listener Config
The Listener Control Utility Overview
Service Registration Explained
Listener Queue Size
Switch Off Listener Logging and Tracing
Timeouts
Multiple Listeners - Lesson 1
Multiple Listeners - Lesson 2
Connection Load Balancing and Failover
SDU - The Session Data Unit Buffer
Connection Profile Config.
Connection Strings and Naming Methods Chapter Overview - the above explained
Local Naming Using TNS
Host & External Naming
Directory Naming - Lesson 1
Directory Naming - Lesson 2
The Oracle Names Server
Oracle Shared Servers Multithreaded Server Overview
Dispatchers Overview
Dispatchers Pooling
Connection Pooling
Further Shared Server Parameters
How to Override Shared Servers
Connection Manager The Connection Manager Explained
Connection Concentration
Multiple Protocol Support Explained
How to Configure the Connection Manager
Other Oracle Net Services Utilities Chapter Overview
Oracle Net Services Advanced Features TAF Explained
TAF Parameters
How to Configure TAF
Non-Oracle db Connections
Oracle Net Services Metadata Performance Views
Backup and Recovery Chapter Overview
Why should you backup & Recover
Remember ... - Lesson 1
Remember ... - Lesson 2
Remember ... - Lesson 3
Things to Consider with Datafiles
Redo Logs Overview
Controlfiles
Archive Logs Explained
The Importance of Backing up and Recover
Points of Failure 1312 Backup Strategy
The Mechanics of Backup and Recovery Processes
Memory Structures
Checkpoints
All the Files
SCNs
Restore and Recovery
Logical Backups Using Exports Full Exports and Imports
Schemas
Multiple Schemas Explained
How to Import to a Different Schema
Tables
The Parameter File
Exporting and Importing Options
Physical Backup/Restore/Recovery Cold & Hot Backups
Verifying Backups Using DBVERIFY
Recovering using Offline & Online Physical Backups
Read Only Tablespaces Explained
Incomplete Recovery
How to Script Hot Backups
RMAN (Recovery Manager) RMAN Explained
Repository and Catalog
The Recovery Catalog Described
RMAN Architecture
A Channel - Explained
Allocating and Releasing Channels
Creating an RMAN Database and a Repository
How to Connect to RMAN
Registering Databases with the Repository
View the Repository
Backup Sets
Backups - Types Backups: • Controlfile and Datafile • Tablespace & Archive Log • Binary Parameter File • Database • Incremental
Restore and Recovery with Action - Lesson 1
Restore and Recovery with Action - Lesson 2
Scripts and RMAN
How to Delete RMAN Backups
Oracle Enterprise Manager Backup and Recovery How to Configure the Oracle Enterprise Manager
Communications
Win2K Log on as Batch Job
Export & Import
Backup and Recovery
Backup and Recovery Metadata Performance Views Explained
Transportable Tablespaces Chapter Overview
What are the Uses of Transportable Tablespaces?
Limitations of TT
Tablespace Sets Overview
Tablespace Set Verification
Transporting a Tablespace Set
Plug In
SQL*Loader SQL*Loader Explained
The Control File and Complexity
Input Data File Overview & Structures
How Rows are Loaded (Description)
Multiple Tables and Formats
Column Delimiters
NULL Values Explained
Load Filtering Explained
Filler Fields Explained
Data Types Explained
Conditional Replacement
Working with SQL
Generating Data Not in Input Files
Executing SQL*Loader
Conventional vs Direct
The Parameter File Explained
A Simple Example Load - Lesson 1
A Simple Example Load - Lesson 2
The Oracle Enterprise Manager
Oracle Database Tutorial Wrap Up
UK & Europe
Marrutt Software Training
Bellbrook Industrial Estate
Uckfield, East Sussex, TN22 1QL
United Kingdom
UK Tel: +44 (0) 1825 764057
UK Fax: +44 (0) 1825 768841
US & Canada
Marrutt Software Training
244 5th Ave # 1877
New York, NY 10001
United States
US Tel: 646-736-7932
US Fax: 646-895-7649
UK & Europe
US & Canada