Oracle Database Administration Fundamentals II Tutorials

Course Title: Oracle Database Administration Fundamentals II

Oracle Database Administration Fundamentals II is the third in a series of four courses covering Oracle Certification course #1Z0-032, and more. Like the other courses in this series of Oracle Certification titles, this course teaches and demonstrates by example using thoroughly tested examples. In this course, instructor Gavin Powell covers Oracle Net Services, Backup and Recovery including RMAN, Oracle Enterprise Manager, Transportable Tablespaces and SQL*Loader. In addition, there are small sections introducing other Oracle optional features such as Standby databases (both Logical and Physical) plus Replication (both traditional and using Streams). Net Services covers architecture, connection configuration, listener configuration (from basics to connection profiling and load balancing), all the facts about connection strings and Oracle Net Services naming methods, even introducing some advanced features. To get started today, simply click one of the links below.

Course Author/Expert: Gavin Powell

Language: english

Full Online Training Available: Yes

Number of Course Movies: 181

Course Duration: 8 hours

Never has it been so easy to learn Oracle Database Administration Fundamentals II.
No expensive classroom training courses.
No boring hard to follow books to read.
Learn from your own desk at a pace that suits you.
High quality affordable training that is easy to use and follow.
Use unique training methods, it makes learning easy no matter what your learning style.

Course Outline:

The FIRST THREE chapters of this online training course can be viewed right now!

Click Here Now To View the First Three Chapters of Oracle Database Administration Fundamentals II Online Training For Free

If you then need all the lessons or complete access to over seven hundred different courses then join the online university for as long as you need them and even get an online university certificate.

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

Basic Database Configuration Parameters pt. 2

Using the Net Configuration Assistant pt. 1

Using the Net Configuration Assistant pt. 2

The Listener

What is the Listener? pt. 1

What is the Listener? pt. 2

Basic Listener Configuration

The Listener Control Utility

Service Registration

Listener Queue Size

Switching Off Listener Logging and Tracing

Timeouts

Multiple Listeners pt. 1

Multiple Listeners pt. 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 pt. 1

Directory Naming pt. 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

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

Archive Configuration

Basic Archive Configuration Parameters

Archive Log Mode Configuration pt. 1

Archive Log Mode Configuration pt. 2

Multiple Archiving Processes

Multiple Archive Destinations

Standby Archiving pt. 1

Standby Archiving pt. 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

Performance Views

Transportable Tablespaces

What are Transportable Tablespaces?

Uses of Transportable Tablespaces

Limitations

Tablespace Sets

Tablespace Set Verification

Transporting a Tablespace Set

Plug In

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

Load Filtering

Filler Fields

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

A Simple Example Load pt. 2

Oracle Enterprise Manager

To continue your learning, Click Here for the Online University and get access to all of the training courses, that's over 550 software programmes including 60,000 tutorial videos, for editing, image manipulation and graphics programmes. All for just $30 (approx £16) month. Unlimited access for as long as you need, cancel when you're finished, no contract, no minimum period, no hassle.

or

Click Here and we'll send you the training CD itself for Oracle Database Administration Fundamentals II at £79.95