Title Language  : 

Find a Course... Try for Free!

 

Oracle Database Administration Fundamentals II Tutorials

Course Content
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.
QT To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.

лл Hide This
Welcome
Welcome (01:28)
Prerequisites for this Course (02:41)
About this Course (03:41)
Oracle Net Services on Technet (01:15)
Oracle Backup and Recovery on Technet (02:04)
Other Applicable Technet Options (01:38)
Introducing Oracle Net Services
What is Oracle Net Services? (01:40)
Three Basic Configurations (02:41)
Managing Oracle Database Networks (03:15)
Local Versus Centralized Naming (02:57)
Simple Server Configuration (03:12)
Oracle Shared Servers or MTS pt. 1 (00:51)
Oracle Shared Servers or MTS pt. 2 (00:43)
Simple Client Configuration (03:31)
Connection Profiles (03:17)
Introducing Naming Options pt. 1 (01:23)
Introducing Naming Options pt. 2 (03:41)
Oracle Connection Manager (01:19)
Net Configuration Assistant (02:01)
Net Manager (01:16)
Using Oracle Enterprise Manager (00:55)
Introducing Backup/Recovery Options/Utilities
Different Backup and Recovery Options (04:46)
Import and Export (01:45)
Cold Backups (Offline) (02:36)
Hot Tablespace Backups (Online) (02:26)
RMAN or Recovery Manager (03:40)
Recovery (02:48)
Standby Databases (03:40)
Physical Standby Databases (00:44)
Logical Standby Databases (01:34)
Replication (01:49)
Replication by Other Means (01:23)
What are Transportable Tablespaces? (01:21)
What is SQL*Loader? (02:11)
Oracle Net Services Architecture
Oracle Net Services Architecture (01:01)
The Open Systems Interconnection (OSI) Model (05:34)
Oracle OSI Model (04:16)
Protocols (04:39)
Net Services Communication (02:23)
Dedicated and Shared Connections (03:08)
Shared Server Processes and Dispatchers (02:50)
Configuring a Simple Connection
The Listener Configuration File (03:09)
The TNS Names Configuration File (02:16)
The Profile Parameters File (01:02)
Basic Database Configuration Parameters pt. 1 (03:51)
Basic Database Configuration Parameters pt. 2 (02:38)
Using the Net Configuration Assistant pt. 1 (02:40)
Using the Net Configuration Assistant pt. 2 (01:00)
The Listener
What is the Listener? pt. 1 (01:21)
What is the Listener? pt. 2 (00:55)
Basic Listener Configuration (03:32)
The Listener Control Utility (03:27)
Service Registration (01:36)
Listener Queue Size (01:40)
Switching Off Listener Logging and Tracing (03:03)
Timeouts (00:50)
Multiple Listeners pt. 1 (02:45)
Multiple Listeners pt. 2 (02:02)
Connection Load Balancing and Failover (03:11)
The Session Data Unit Buffer (SDU) (02:40)
Connection Profile Configuration (01:46)
Connection Strings and Naming Methods
Connection Strings (01:56)
Naming Methods (01:57)
Local Naming Using TNS (01:09)
Host Naming (01:46)
External Naming (00:52)
Directory Naming pt. 1 (01:06)
Directory Naming pt. 2 (02:37)
Oracle Names Server (05:26)
Oracle Shared Servers
Multithreaded Server (04:32)
Introducing Dispatchers (01:32)
Dispatchers and Connection Pooling (02:53)
Other Shared Server Parameters (01:10)
Overriding Shared Servers (01:01)
Connection Manager
What is Connection Manager? (01:40)
Connection Concentration (01:10)
Multiple Protocol Support (01:19)
Configuring Connection Manager (01:47)
Other Oracle Net Services Utilities
Other Oracle Net Services Utilities (03:19)
Oracle Net Services Advanced Features
What is TAF? (01:16)
TAF Parameters (01:47)
Configuring TAF (01:27)
Non-Oracle Database Connections (01:50)
Oracle Net Services Metadata
Performance Views (04:18)
Backup and Recovery
What is Backup and Recovery? (01:51)
Why Backup and Recovery? (00:50)
Things to Remember (03:02)
Things to Consider with Datafiles (00:45)
Redo Logs (03:12)
Controlfiles (02:41)
Archive Logs (00:54)
More Things to Consider (03:23)
Yet More Things to Consider (02:37)
Importance of Backup and Recovery (02:08)
Points of Failure (06:19)
Backup Strategy (06:36)
How Backup and Recovery Works
Processes/Memory Structures/Checkpoints (02:43)
All the Files (01:47)
SCNs (01:50)
Restore and Recovery (03:26)
Archive Configuration
Basic Archive Configuration Parameters (03:43)
Archive Log Mode Configuration pt. 1 (03:14)
Archive Log Mode Configuration pt. 2 (03:32)
Multiple Archiving Processes (03:30)
Multiple Archive Destinations (01:55)
Standby Archiving pt. 1 (02:26)
Standby Archiving pt. 2 (03:46)
Logical Backups Using Exports
Full Exports and Imports (04:57)
Schemas (03:49)
Multiple Schemas (00:45)
Importing to a Different Schema (02:20)
Tables (02:16)
The Parameter File (01:24)
Export and Import Options (02:06)
Physical Backup/Restore/Recovery
Cold Backups (02:59)
Hot Backups (04:25)
Verify Backups Using DBVERIFY (04:09)
Recovering using Offline Physical Backups (01:06)
Recovering using Online Physical Backups (06:03)
Read Only Tablespaces (01:05)
Incomplete Recovery (00:40)
Scripting Hot Backups (03:25)
RMAN (Recovery Manager)
What is RMAN? (03:12)
Repository and Catalog (02:25)
The Recovery Catalog (01:41)
RMAN Architecture (01:36)
What is a Channel? (01:18)
Allocating and Releasing Channels (01:04)
Creating an RMAN Database (02:59)
Creating a Repository (02:38)
Connecting to RMAN (02:54)
Registering Databases with the Repository (02:49)
Viewing the Repository (03:00)
Backup Sets (01:41)
Types of Backups (00:55)
Controlfile Backups (01:52)
Datafile Backups (01:44)
Tablespace Backups (01:11)
Archive Log Backups (01:47)
Binary Parameter File Backups (00:25)
Database Backups (02:59)
Incremental Backups (04:06)
Restore and Recovery (01:19)
Restore and Recovery in Action (04:23)
Scripts and RMAN (02:11)
Deleting RMAN Backups (04:23)
Oracle Enterprise Manager Backup and Recovery
Configuring Oracle Enterprise Manager (03:51)
Communications (03:10)
Win2K Log on as Batch Job (02:13)
Export (02:37)
Import (02:11)
Backup and Recovery (03:57)
Backup and Recovery Metadata
Performance Views (04:43)
Transportable Tablespaces
What are Transportable Tablespaces? (01:05)
Uses of Transportable Tablespaces (02:16)
Limitations (01:28)
Tablespace Sets (03:54)
Tablespace Set Verification (03:39)
Transporting a Tablespace Set (04:22)
Plug In (03:46)
SQL*Loader
What is SQL*Loader? (01:31)
The Control File and Complexity (01:51)
Input Data File (00:35)
Input Data File Structures (04:45)
How Rows are Loaded (01:31)
Multiple Tables and Formats (02:40)
Column Delimiters (04:25)
NULL Values (01:05)
Load Filtering (01:36)
Filler Fields (01:28)
Data Types (04:26)
Conditional Replacement (02:05)
Using SQL (02:53)
Generating Data Not in Input Files (00:55)
Executing SQL*Loader (02:45)
Conventional Versus Direct (01:19)
The Parameter File (00:53)
A Simple Example Load pt. 1 (04:52)
A Simple Example Load pt. 2 (03:31)
Oracle Enterprise Manager (02:09)

Email this Page     Send us Feedback
Tutorial Information / Pricing
Title: Oracle Database Administration Fundamentals II
Author: Gavin Powell
SKU: 33488
ISBN: 1932072845
Duration: 8 hrs / 181 Lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP LEARN MORE »

Get this title on CD
Single User: US$ 99.95 - Purchase CD / Add to Cart

Multi User (10): US$ 500.00 - Purchase CD / Add to Cart

Select Bandwidth
Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

Select:

Select Category

Special Groups

Publisher or Products