Oracle Database 11g: Administration Workshop I - Self-Study Course

Oracle Database 11g allows users to innovate faster, manage more data with advanced table partitioning and compression, protect data and integrate 3D spatial and rich media content into business processes. This course is designed to teach you about the Oracle Database 11g architecture.

Learn To:

• Prepare the database environment and create an Oracle database.
• Manage the Oracle instance.
• Configure the Oracle network environment.
• Manage database storage structures.
• Manage user security,schema objects, data and concurrency and undo data.
• Implement Oracle database security, database maintenance and performance management.
• Perform backup and recovery, move data and enhance database capabilities.

Benefits of Self-Study Courses

By enrolling in an Self-Study course with Oracle University, you'll be able to learn at your own pace. Download the course material and access it whenever it's most convenient for you.

Audience

• Database Administrators
• Database Designers
• Developer
• Support Engineer
• Technical Administrator

Course Topics 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

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