This Oracle 11g training course and training guide book allows our students to gain the skills necessary for day-to-day administration of an Oracle database. This course is the starting point for Oracle database administrators and sets the foundation for advanced administrator training and Oracle OCA certification.
This 5-day course teaches students how to design and create a server using the Optimal Flexible Architecture (OFA), configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Students will develop the fundamental skills necessary to be an effective Oracle® DBA.
| Next public classes scheduled: |
|
Jun 4 2012 |
Guaranteed to run |
Course ID: OCA700
Duration: 5 days
Audience: None
Prerequisites: None
Topics:
|
Enterprise Edition Installation
- Identify System Requirements
- The Optimal Flexible Architecture (OFA)
- ORACLE_BASE
- ORACLE_HOME
- Configure The Installation Environment
- Enterprise Edition Installation
- DBCA
The Administrator Interface
- Enterprise Manager Tour
- Using EM SQL Worksheet
- Duties Of A Database Administrator
- Exploring The Oracle Database Architecture: General
The Oracle Enterprise Architecture
- Exploring The Oracle Database Architecture: Instance Memory
- What Is An Oracle Database Instance?
- More About The System Global Area (SGA)
- About The PGA
- Managing Memory
Exploring The Oracle Database Architecture: Instance Processes
- Instance Background Processes
- SQL Execution Processes
Creating An Oracle Database
- Create A New Database
- Configure An Existing Database
- Drop A Database
- Manage DBCA Templates
- Manually Create A Database
Managing The Database Instance
- Configuring A Linux Environment
- Starting and Stopping Database Control
- Starting and Stopping The Database Listener
- Starting and Stopping The Database Instance
- More About The Database Files
Manage Database Storage Structures: Tablespaces
- About Tablespaces
- Tablespace Management
- Drop Tablespace
- Alter Tablespace
Manage Database Storage Structures: Advanced Tablespaces
- More About Temporary Tablespaces
- About Temporary Tablespace Groups
- More About Permanent Tablespaces
- More About BIGFILE Tablespaces
- More About The SYSAUX Tablespace
Manage Database Storage Structures
- Data Files and Temp Files
- Managing Data Files
- Managing Temp Files
- Enable Oracle-Managed Files(OMF)
|
Managing Undo Data
- About Undo Space Management
- Configure Automatic Undo Management
- Undo_Management
- Undo_Tablespace
- Undo_Retention
- Guarantee Undo Retention
- Monitor UNDO Space
- Use The UNDO Advisor
Network Environment: Oracle Shared Servers
- Shared Servers Architecture
- Configure Shared Servers
- Monitor Shared Servers
- V$SHARED_SERVER
- V$SHARED_SERVER_MONITOR
- V$SESSION
- V$CIRCUIT
- V$DISPATCHER and V$DISPATCHER_CONFIG
- V$QUEUE
Security: Implementing Database Security
- Database System Privileges
- Database Object Privileges
- Administrator Auditing Of Database Activity
- Enhanced Default Security Settings
Security: Administering User Security
- Create and Manage Database Accounts
- Grant and Revoke Database Privileges
- Resource Limits Via Profiles
- Alter Profile
- Drop Profile
- Password Management Via Profiles
- About Role-Based Security
- With Admin Option
- Alter User...Default Role
- Set Role
- Enhanced Default Security Settings
Moving Data: SQL Loader
- Loader Concepts
- Control File Options
- Load Methods
- Using The EM Interface
Moving Data: Export and Import
- Manage Directory Objects
- About The Data Pump Architecture
- Data Pump Export
- Data Pump Import
- Data Pump Data Dictionary Views
- Using The EM Interface
Database Maintenance and Performance Management
- The Management and Advisory Framework
- Manage The Automatic Workload Repo
|
