Oracle Database Admin Video Tutorial - Training CD

Affordable Training you can depend on. Learn from an Expert from the comfort of your own desk, at a pace that suits you.

Benefits

• Works on PC or Mac
• Professional Tutition by Experts
• Self-Paced Learning Interface
• Builds Practical Skills Quickly
• Rapid Learning - High Retention
• Free Certificate with each Tutorial

Client Testimonials

• 'Your training CDs are great and I will recommend [them] to everyone interested in learning software.'
  David Easter
  Brooklyn, NY ;

Just Released Training

Just Released this week.
• 
Poser 8 Tutorial Video

Topics covered on this Tutorial Video
are Listed Below:-

Welcome to these Tutorials

• Welcome
• Prerequisites for this Course
• About this Course
• Oracle Net Services on Technet
• Oracle Backup and Recovery on Technet
• Other Applicable Technet Options

Introducing Oracle Net Services

• What is Oracle Net Services?
• Three Basic Configurations
• Managing Oracle Database Networks
• Local Versus Centralized Naming
• Simple Server Configuration
• Oracle Shared Servers or MTS Tutorials 1
• Oracle Shared Servers or MTS 2
• Simple Client Configuration
• Connection Profiles
• Introducing Naming Options 1
• Introducing Naming Options 2
• Oracle Connection Manager
• Net Configuration Assistant
• Net Manager
• Using Oracle Enterprise Manager

Introducing Backup - Recovery Options - Utilities

• Different Backup and Recovery Options
• Import and Export
• Cold Backups (Offline)
• Hot Tablespace Backups (Online)
• RMAN or Recovery Manager
• Recovery
• Standby Databases
• Physical Standby Databases
• Logical Standby Databases
• Replication
• Replication by Other Means
• What are Transportable Tablespaces?
• What is SQL*Loader?

The purchased version of this product contains all the movies listed below as well as all the featured samples above. US$ 99.95

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

An effective training video that teaches using practical based examples and easy to follow instructions.

A self-paced learning interface that simplifies learning and breaks even the most complex topics down into easy to follow step-by-step instructions making it ideal for users of all levels

A proven video training product that's created by professionals and used by companies, schools, government and individuals the World over.

A verifiable Certificate Proving your Skills

Oracle Database Admin Training - VIDEO INFO

TitleOracle Database Administration

TutorGavin Powell

Duration8 hours - 181 Movies

Price US$ 99.95

OSWin Vista XP, 2000, 98. Mac OS X

Delivery Ground / 2 day / Next Day

Product Code33488