Course Brief

Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner. This includes performance monitoring, database security, user management and backup/recovery techniques.

Course Description

This course is designed to give students a firm foundation in basic database administration. Lesson topics are reinforced with structured hands-on practices that will prepare them for the corresponding Oracle Certified Associate exam. Students will learn how to install Oracle Grid Infrastructure, create and manage users, install and configure an Oracle Database, and create and manage storage structures. They will also learn how to administer the Oracle Database, perform backup and recovery, and create an Operational Database. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner. This includes performance monitoring, database security, user management and backup/recovery techniques.

Oracle abase 11g: Administration I

• Exploring the Oracle Database Architecture
• Preparing the Database Environment
• Creating an Oracle Database
• Managing the Oracle Instance
• Configuring the Oracle Network Environment
• Managing Database Storage Structures
• Administering User Security
• Managing Data and Concurrency
• Managing Undo Data
• Implementing Oracle Database Security
• Database Maintenance
• Performance Management
• Intelligent Infrastructure Enhancements
• Backup and Recovery Concepts
• Performing Database Backups
• Performing Database Recovery
• Moving Data
• Working data