| Oracle Database Administration Fundamentals II Tutorials Online |
 |
|
Description 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. |
| Sample - Preview the First 3 chapters of Oracle Database Administration Fundamentals II video free. Free learning Oracle Database Administration Fundamentals II online. |
01 Welcome
0101 Welcome
0102 Prerequisites for this Course
0103 About this Course
0104 Oracle Net Services on Technet
0105 Oracle Backup and Recovery on Technet
0106 Other Applicable Technet Options
02 Introducing Oracle Net Services
0201 What is Oracle Net Services?
0202 Three Basic Configurations
0203 Managing Oracle Database Networks
0204 Local Versus Centralized Naming
0205 Simple Server Configuration
0206 Oracle Shared Servers or MTS pt. 1
0207 Oracle Shared Servers or MTS pt. 2
0208 Simple Client Configuration
0209 Connection Profiles
0210 Introducing Naming Options pt. 1
0211 Introducing Naming Options pt. 2
0212 Oracle Connection Manager
0213 Net Configuration Assistant
0214 Net Manager
0215 Using Oracle Enterprise Manager
03 Introducing Backup/Recovery Options/Utilities
0301 Different Backup and Recovery Options
0302 Import and Export
0303 Cold Backups (Offline)
0304 Hot Tablespace Backups (Online)
0305 RMAN or Recovery Manager
0306 Recovery
0307 Standby Databases
0308 Physical Standby Databases
0309 Logical Standby Databases
0310 Replication
0311 Replication by Other Means
0312 What are Transportable Tablespaces?
0313 What is SQL*Loader?
04 Oracle Net Services Architecture
0401 Oracle Net Services Architecture
0402 The Open Systems Interconnection (OSI) Model
0403 Oracle OSI Model
0404 Protocols
0405 Net Services Communication
0406 Dedicated and Shared Connections
0407 Shared Server Processes and Dispatchers
05 Configuring a Simple Connection
0501 The Listener Configuration File
0502 The TNS Names Configuration File
0503 The Profile Parameters File
0504 Basic Database Configuration Parameters pt. 1
0505 Basic Database Configuration Parameters pt. 2
0506 Using the Net Configuration Assistant pt. 1
0507 Using the Net Configuration Assistant pt. 2
06 The Listener
0601 What is the Listener? pt. 1
0602 What is the Listener? pt. 2
0603 Basic Listener Configuration
0604 The Listener Control Utility
0605 Service Registration
0606 Listener Queue Size
0607 Switching Off Listener Logging and Tracing
0608 Timeouts
0609 Multiple Listeners pt. 1
0610 Multiple Listeners pt. 2
0611 Connection Load Balancing and Failover
0612 The Session Data Unit Buffer (SDU)
0613 Connection Profile Configuration
07 Connection Strings and Naming Methods
0701 Connection Strings
0702 Naming Methods
0703 Local Naming Using TNS
0704 Host Naming
0705 External Naming
0706 Directory Naming pt. 1
0707 Directory Naming pt. 2
0708 Oracle Names Server
08 Oracle Shared Servers
0801 Multithreaded Server
0802 Introducing Dispatchers
0803 Dispatchers and Connection Pooling
0804 Other Shared Server Parameters
0805 Overriding Shared Servers
09 Connection Manager
0901 What is Connection Manager?
0902 Connection Concentration
0903 Multiple Protocol Support
0904 Configuring Connection Manager
10 Other Oracle Net Services Utilities
1001 Other Oracle Net Services Utilities
11 Oracle Net Services Advanced Features
1101 What is TAF?
1102 TAF Parameters
1103 Configuring TAF
1104 Non-Oracle Database Connections
12 Oracle Net Services Metadata
1201 Performance Views
13 Backup and Recovery
1301 What is Backup and Recovery?
1302 Why Backup and Recovery?
1303 Things to Remember
1304 Things to Consider with Datafiles
1305 Redo Logs
1306 Controlfiles
1307 Archive Logs
1308 More Things to Consider
1309 Yet More Things to Consider
1310 Importance of Backup and Recovery
1311 Points of Failure
1312 Backup Strategy
14 How Backup and Recovery Works
1401 Processes/Memory Structures/Checkpoints
1402 All the Files
1403 SCNs
1404 Restore and Recovery
15 Archive Configuration
1501 Basic Archive Configuration Parameters
1502 Archive Log Mode Configuration pt. 1
1503 Archive Log Mode Configuration pt. 2
1504 Multiple Archiving Processes
1505 Multiple Archive Destinations
1506 Standby Archiving pt. 1
1507 Standby Archiving pt. 2
16 Logical Backups Using Exports
1601 Full Exports and Imports
1602 Schemas
1603 Multiple Schemas
1604 Importing to a Different Schema
1605 Tables
1606 The Parameter File
1607 Export and Import Options
17 Physical Backup/Restore/Recovery
1701 Cold Backups
1702 Hot Backups
1703 Verify Backups Using DBVERIFY
1704 Recovering using Offline Physical Backups
1705 Recovering using Online Physical Backups
1706 Read Only Tablespaces
1707 Incomplete Recovery
1708 Scripting Hot Backups
18 RMAN (Recovery Manager)
1801 What is RMAN?
1802 Repository and Catalog
1803 The Recovery Catalog
1804 RMAN Architecture
1805 What is a Channel?
1806 Allocating and Releasing Channels
1807 Creating an RMAN Database
1808 Creating a Repository
1809 Connecting to RMAN
1810 Registering Databases with the Repository
1811 Viewing the Repository
1812 Backup Sets
1813 Types of Backups
1814 Controlfile Backups
1815 Datafile Backups
1816 Tablespace Backups
1817 Archive Log Backups
1818 Binary Parameter File Backups
1819 Database Backups
1820 Incremental Backups
1821 Restore and Recovery
1822 Restore and Recovery in Action
1823 Scripts and RMAN
1824 Deleting RMAN Backups
19 Oracle Enterprise Manager Backup and Recovery
1901 Configuring Oracle Enterprise Manager
1902 Communications
1903 Win2K Log on as Batch Job
1904 Export
1905 Import
1906 Backup and Recovery
20 Backup and Recovery Metadata
2001 Performance Views
21 Transportable Tablespaces
2101 What are Transportable Tablespaces?
2102 Uses of Transportable Tablespaces
2103 Limitations
2104 Tablespace Sets
2105 Tablespace Set Verification
2106 Transporting a Tablespace Set
2107 Plug In
22 SQL*Loader
2201 What is SQL*Loader?
2202 The Control File and Complexity
2203 Input Data File
2204 Input Data File Structures
2205 How Rows are Loaded
2206 Multiple Tables and Formats
2207 Column Delimiters
2208 NULL Values
2209 Load Filtering
2210 Filler Fields
2211 Data Types
2212 Conditional Replacement
2213 Using SQL
2214 Generating Data Not in Input Files
2215 Executing SQL*Loader
2216 Conventional Versus Direct
2217 The Parameter File
2218 A Simple Example Load pt. 1
2219 A Simple Example Load pt. 2
2220 Oracle Enterprise Manager
sku |
|
