Oracle Database Administration Fundamentals II Tutorials
	Quantity in Basket: none Code: VTC-33488 Price:$89.95
	Quantity:
Oracle Database Administration Fundamentals II Tutorials Producer: See all VTC titles Media: CD-ROM Author: Gavin Powell ISBN: 1932072845 Duration: 8 hrs / 181 lessons Compatibility: Win XP, ME, 2000, 98, NT, Mac OS X, OS 9 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. Try For Free Right Now To help you evaluate this training program, some of the tutorials may be viewed for free online. Listed below are all of the chapters and lessons for this title. Click on any of the linked lessons below to watch them now online! CD Contents 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) To view the Free Tutorials 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.