Oracle Database 11g: Administration Workshop I (Self-Study Course)
Who should attend
- Database administrators
- Database designers
- Developers
Prerequisites
- A working knowledge of SQL
Course Objectives
- Install and configure Oracle Database 11g
- Configure Oracle Net services
- Manage the database storage structures
- Create and administer user accounts
- Perform basic backup and recovery of a database
- Manage users and schemas
- Manage data and concurrency
- Monitor and administer undo data
- Describe Oracle Database Architecture
- Backup and recover a database
- Monitor performance
- Use the database diagnostic monitor
Product Description
- Oracle Database 11g: Database Architecture and Installation
- Exploring the Oracle Database 11g Architecture
- Preparing the Database Environment
- Oracle Database 11g: Database Creation, Instance Management, and Connectivity
- Database Creation and Instance Management
- Configuring the Oracle Network Environment
- Oracle Database 11g: Storage Structures and User Security
- Managing Storage Structures
- Administering User Security
- Oracle Database 11g: Managing the Schema, Data, and Concurrency
- Managing Schema Objects
- Managing Data and Concurrency
- Oracle Database 11g: Managing Undo Data, Database Security, and Maintenance
- Undo Data and Database Security
- Maintaining Statistics
- Oracle Database 11g: Performance Monitoring, Recovery Concepts and Backup
- Performance Monitoring and Recovery
- Performing Database Backups
- Oracle Database 11g: Recovering, Moving, and Enhancing the Oracle Database
- Data Recovery and Movement
- Enhancing Database Capabilities