|
Provided by: Ahana Systems and Solutions (P) Ltd Oracle 10g DBA online Training from 10-05-2009 |
 |
Training
Provided by Ahana Systems and Solutions (P) Ltd
Oracle Database Administration
Oracle database training equips individuals to install, maintain, troubleshoot and fine-tune all aspects of an Oracle database.
Our Oracle database training explores Oracle's unique ability to deliver the benefits of grid computing with more self-management and automation. Our Oracle Database Administrator Certification track combines training, experience and testing to ensure you have a strong foundation and expertise in the industry's most advanced database management system.
Oracle DBA professionals need a solid knowledge of the Linux/ Unix environment and functionality to successfully implement, administer and maintain Oracle software. To help these professionals get the recognition that they need our training includes excessive coverage in the Linux space. Oracle DBA track training is delivered on Linux/ unix environments unlike others, which imparts knowledge and expertise in Linux/ Unix OS administration and managing Oracle database environments on Linux/ Unix platform
|
|
||||||||||
Oracle 10g DBA online Training from 10-05-2009
Oracle 10g Database Administration
Oracle 10g Database Administration - I
Oracle 10g Database Administration - II
Oracle 10g Database Administration - I
Course Contents:
Basic Database Administration
Overview of Administering an Oracle Database
Types of Oracle Database Users
Tasks of a Database Administration
Creating an Oracle Database
Deciding How to Create an Oracle Database
Manually Creating an Oracle Database
Understanding the CREATE DATABASE Statement
Understanding Initialization Parameters
Troubleshooting Database Creation
Dropping a Database
Managing Initialization Parameters Using a Server Parameter file
Starting Up and Shutting Down
Starting Up a Database
Altering Database Availability
Shutting Down a Database
Quiescing a Database
Suspending and Resuming a Database
Managing Oracle Database Processes
About Dedicated and Shared Server Processes
Configuring Oracle Database for Shared Server
About Oracle Database Background Processes
Managing Control Files
Guidelines for Control Files
Creating Control Files
Troubleshooting After Creating Control Files
Backing Up Control Files
Recovering a Control File Using a Current Copy
Dropping Control Files
Managing the Redo Log
Basic working of Redo Log
Planning the Redo Log
Creating Redo Log Groups and Members
Relocating and Renaming Redo Log Members
Dropping Redo Log Groups and Members
Managing Archived Redo Logs
What Is the Archived Redo Log?
Choosing Between NOARCHIVELOG and ARCHIVELOG Mode
Controlling Archiving
Specifying the Archive Destination
Specifying the Mode of Log Transmission
Managing Archive Destination Failure
Managing Tablespaces
Guidelines for Managing Tablespaces
Creating Tablespaces
Altering Tablespace Availability
Using Read-Only Tablespaces
Renaming Tablespaces
Dropping Tablespaces
Managing the SYSAUX Tablespace
Viewing Tablespace Information
Managing Datafiles and Tempfiles
Guidelines for Managing Datafiles
Creating Datafiles and Adding Datafiles to a Tablespace
Changing Datafile Size
Altering Datafile availability
Renaming and Relocating Datafiles
Dropping Datafiles
Copying Files using the Database Server
Managing the Undo Tablespace
What Is Undo?
Introduction to Automatic Undo Management
Setting the Undo Retention Period
Sizing the Undo Tablespace
Managing Undo Tablespaces
Using Oracle-Managed Files
What Are Oracle-Managed Files?
Enabling the Creation and Use of Oracle-Managed Files
Creating Oracle-Managed Files
Using Automatic Storage Management
Oracle 10g Database Administration - II
Course Contents:
Using Automatic Storage Management
What Is Automatic Storage Management?
Overview of the Components of Automatic Storage Management
Administering an Automatic Storage Management Instance
Administering Automatic Storage Management Disk Groups
Using Automatic Storage Management in the Database
Managing Schema Objects
Creating Multiple Tables and views in a Single Operation
Analyzing Tables, Indexes and Clusters
Truncating Tables and Clusters
Renaming Schema Objects
Managing Space for Schema Objects
Managing Space in Data Blocks
Managing Storage Parameters
Managing Resumable Space Allocation
Managing Tables
About Tables
Guidelines for Managing Tables
Creating Tables
Loading Tables
Automatically collecting Statistics on Tables
Altering Tables
Redefining Tables Online
Using Flashback Drop and Managing the Recycle Bin
Managing Index-Organized Tables
Managing External tables
Managing Indexes
About Indexes
Gidelines for Managing Indexes
Creating Indexes
Altering Indexes
Monitoring Space Usage of Indexes
Dropping Indexes
Managing Partitioned Tables and Indexes
About Partitioned Tables and Indexes
Partitioning Methods
Creating Partitioned Tables
Maintaining Partitioned Tables
Dropping Partitioned Tables
Managing Clusters
About Clusters
Guidelines for Managing Clusters
Creating Clusters
Altering clusters
Dropping Clusters
Loading And Unloading Data
Introduction to the Data Pump Architecture
Benefits of Data Pump Technology
Using Data Pump Export and Import
Monitoring a Data Pump Job
Creating External Tables for Data Population
Defining External Table Properties
Manageability Infrastructure
The Automatic Workload Repository (AWR)
Active Session History (ASH)
Server-Generated Alerts
The Automated Tasks Feature
The Management Advisory Framework
The Oracle Scheduler And The Database Resource Manager
Simplifying Management Tasks Using the Scheduler
Managing the Basic Scheduler Components
Managing Advanced Scheduler Components
Managing Scheduler Attributes
Backup And Recovery Enhancements
Using the Flash Recovery Area
Using Incremental Backups
Enhanced RMAN Commands
Miscellaneous Backup and Recovery Enhancements
FlashBack Technology Enhancements
General Flashback Technology Considerations
Flashback Drop
Flashback Table
Row Level Flashback Features
Oracle 10g Database Administration - I
Oracle 10g Database Administration - II
Oracle 10g Database Administration - I
Course Contents:
Basic Database Administration
Overview of Administering an Oracle Database
Types of Oracle Database Users
Tasks of a Database Administration
Creating an Oracle Database
Deciding How to Create an Oracle Database
Manually Creating an Oracle Database
Understanding the CREATE DATABASE Statement
Understanding Initialization Parameters
Troubleshooting Database Creation
Dropping a Database
Managing Initialization Parameters Using a Server Parameter file
Starting Up and Shutting Down
Starting Up a Database
Altering Database Availability
Shutting Down a Database
Quiescing a Database
Suspending and Resuming a Database
Managing Oracle Database Processes
About Dedicated and Shared Server Processes
Configuring Oracle Database for Shared Server
About Oracle Database Background Processes
Managing Control Files
Guidelines for Control Files
Creating Control Files
Troubleshooting After Creating Control Files
Backing Up Control Files
Recovering a Control File Using a Current Copy
Dropping Control Files
Managing the Redo Log
Basic working of Redo Log
Planning the Redo Log
Creating Redo Log Groups and Members
Relocating and Renaming Redo Log Members
Dropping Redo Log Groups and Members
Managing Archived Redo Logs
What Is the Archived Redo Log?
Choosing Between NOARCHIVELOG and ARCHIVELOG Mode
Controlling Archiving
Specifying the Archive Destination
Specifying the Mode of Log Transmission
Managing Archive Destination Failure
Managing Tablespaces
Guidelines for Managing Tablespaces
Creating Tablespaces
Altering Tablespace Availability
Using Read-Only Tablespaces
Renaming Tablespaces
Dropping Tablespaces
Managing the SYSAUX Tablespace
Viewing Tablespace Information
Managing Datafiles and Tempfiles
Guidelines for Managing Datafiles
Creating Datafiles and Adding Datafiles to a Tablespace
Changing Datafile Size
Altering Datafile availability
Renaming and Relocating Datafiles
Dropping Datafiles
Copying Files using the Database Server
Managing the Undo Tablespace
What Is Undo?
Introduction to Automatic Undo Management
Setting the Undo Retention Period
Sizing the Undo Tablespace
Managing Undo Tablespaces
Using Oracle-Managed Files
What Are Oracle-Managed Files?
Enabling the Creation and Use of Oracle-Managed Files
Creating Oracle-Managed Files
Using Automatic Storage Management
Oracle 10g Database Administration - II
Course Contents:
Using Automatic Storage Management
What Is Automatic Storage Management?
Overview of the Components of Automatic Storage Management
Administering an Automatic Storage Management Instance
Administering Automatic Storage Management Disk Groups
Using Automatic Storage Management in the Database
Managing Schema Objects
Creating Multiple Tables and views in a Single Operation
Analyzing Tables, Indexes and Clusters
Truncating Tables and Clusters
Renaming Schema Objects
Managing Space for Schema Objects
Managing Space in Data Blocks
Managing Storage Parameters
Managing Resumable Space Allocation
Managing Tables
About Tables
Guidelines for Managing Tables
Creating Tables
Loading Tables
Automatically collecting Statistics on Tables
Altering Tables
Redefining Tables Online
Using Flashback Drop and Managing the Recycle Bin
Managing Index-Organized Tables
Managing External tables
Managing Indexes
About Indexes
Gidelines for Managing Indexes
Creating Indexes
Altering Indexes
Monitoring Space Usage of Indexes
Dropping Indexes
Managing Partitioned Tables and Indexes
About Partitioned Tables and Indexes
Partitioning Methods
Creating Partitioned Tables
Maintaining Partitioned Tables
Dropping Partitioned Tables
Managing Clusters
About Clusters
Guidelines for Managing Clusters
Creating Clusters
Altering clusters
Dropping Clusters
Loading And Unloading Data
Introduction to the Data Pump Architecture
Benefits of Data Pump Technology
Using Data Pump Export and Import
Monitoring a Data Pump Job
Creating External Tables for Data Population
Defining External Table Properties
Manageability Infrastructure
The Automatic Workload Repository (AWR)
Active Session History (ASH)
Server-Generated Alerts
The Automated Tasks Feature
The Management Advisory Framework
The Oracle Scheduler And The Database Resource Manager
Simplifying Management Tasks Using the Scheduler
Managing the Basic Scheduler Components
Managing Advanced Scheduler Components
Managing Scheduler Attributes
Backup And Recovery Enhancements
Using the Flash Recovery Area
Using Incremental Backups
Enhanced RMAN Commands
Miscellaneous Backup and Recovery Enhancements
FlashBack Technology Enhancements
General Flashback Technology Considerations
Flashback Drop
Flashback Table
Row Level Flashback Features
About The Training Provider: Ahana Systems and Solutions (P) Ltd
Ahana Systems and Solutions (P) Ltd - Oracle9i DBA
Oracle 10g DBA
Oracle 10g RAC
Sybase DBA
ASE DBA
Sybase Replication DBA
Oracle DBA
MSSQL DBA
MySQL DBA
Perl scripting
Shell scripting
Clearcase Administration
Linux Administration
VMWare
Windows Administration
Our In-house training is aimed at individuals who want to build their career in IT infrastructure field. Its mainly aimed at studends who are in the verge of...
