PRODUCT INFO

Product Guarantee

Testimonials

MAIN LINKS

Multi User Training CDs

	This Week's Special Offer NEW TITLE DISCOUNT!
Final Cut Pro 7 Tutorial

Quicktime is required for the movies, click here to download if needed.
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.

About this Tutorial

show details

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...

hide details

Learn this Software - See below for FREE TUTORIALS

Each Course on 1 or 2 CDs
For Mac and PC

FREE Shipping on all Orders

Oracle Database Tutorial Info
	CLICK HERE TO BUY THIS CD
Tutor: Gavin Powell
Duration: 8 hrs / 181 video lessons
Cost for UK: £79.95 + VAT
Cost for EU: €84.95 + VAT
Cost for US & Canada: $124.95
Product Code: 33488
Delivery: Please allow 2-3 days for UK & Europe, 3-5 days US & rest of world IN STOCK - All CDs Shipped Carriage FREE -
Compatibility: MS Windows 7, Vista, XP, 2000, 98, NT, Mac OS X, OS 9

Benefits of this Software Training

Tuition by expert tutors.

Narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter.

Learning is fast as the trainers use simplistic terms and minimal jargon.

Step-by-step video training from your own desktop. Delivered via CD training or online tuition.

The tutor transfers knowledge to you quickly and effectively.

All the concepts of each application are explained clearly and precisely.

Every course works on PC and Mac.

Alternative to a boring book or manual and expensive training courses & classes.

Jump to and from lessons - learn at your own pace.

The visual and practical nature shortens the learning curve compared to standard training manuals.
Customer Testimonials

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

Welcome

Oracle Database Tutorial Overview

Prerequisites

Course Info

Oracle Net Services on Technet

Oracle Backup and Recovery on Technet

Further Applicable Technet Options

Oracle Net Services Intro

Oracle Net Services Explanation

3 Basic Configs

How to Manage Oracle Database Networks

Local Vs Centralised Naming

Simple Server Config.

Oracle Shared Servers (MTS) - Lesson 1

Oracle Shared Servers (MTS) - Lesson 2

Basic Client Config

Connection Profiles Explained

Naming Options - Lesson 1

Naming Options - Lesson 2

Oracle Connection Manager Overview

Net Config Assistant

Net Manager Intro

Working with the Oracle Enterprise Manager

Introducing Backup/Recovery Options/Utilities

The Backup and Recovery Options

Importing and Exporting

Offline Cold Backups

Online Hot Tablespace Backups

RMAN or Recovery Manager - RMAN Tutorial

Recovery Overview

Standby Databases

Physical Standby Databases Overview

Logical Standby Databases Overview

Replication

Replication by Other Means

Transportable Tablespaces Explained

SQL*Loader Explained

We hope you enjoyed the FREE lessons above. To view the complete contents, including ALL the lessons 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

Archive Configuration
Basic Archive Config. Parameters
Archive Log Mode Configuration - Lesson 1
Archive Log Mode Configuration - Lesson 2
Multiple Archiving Processes and Destinations
Standby Archiving - Lesson 1
Standby Archiving - Lesson 2

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


[ Home \| Video Training CDs/DVD \| Site Map \| Resources \| Specialist Categories \| Specialist Categories 2 ]
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