United States
Oracle Database Administration Fundamentals II Tutorials
Online Contents For This Title
We have made some of the video tutorials for Oracle Database Administration Fundamentals II freely available to help you evaluate our training.
Click on any of the linked lesson listings below to preview FREE!
Title Description
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.
Choose your media type:
|
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) | |
This title is just part of the entire VTC collection of over 625 courses, 66,000 video tutorials (12,500+ free), available to you for just $30 a month.
View All Titles 
Email this Page
Send us FeedbackTutorial Information
| Title: | Oracle Database Administration Fundamentals II |
| Author: | Gavin Powell |
| SKU: | 33488 |
| ISBN: | 1932072845 |
| Release Date: | 2004-04-20 |
| Duration: | 8 hrs / 181 lessons |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
Subscription / Purchase Information
This title is just part of the entire VTC collection of over 625 courses, 65,000 video tutorials (12,500+ free), available to you for just $30 a month.
Purchase/Add to CartRelated Titles
Select Bandwidth
Now Shipping
Client Testimonials
What a great product! I have purchased alot of training for 3DS Max and they don't even come close to yours. Your training cd taught me so much...
Danny Doyle