• Overview
• Outline
• Schedule

About This Course

This course is designed to give you a firm foundation in basic database administration. In this class, you'll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.

Audience Profile

This course is designed for the following audiences:

• Database Administrators
• Forms Developers
• Portal Developers
• Business Intelligence Developers
• End Users
• Application Developers
• PL/SQL Developers

Prerequites

Before attending this course, students must have:

• Taken course ORCL-1101: Oracle Database 11g: Intro to SQL
• Taken course ORCL-1102: Oracle Database 11g: Administration Workshop I

At Course Completion

After completing this course, students will be able to:

• Install Oracle Grid Infrastructure
• Create and manage users
• Install and Configure Oracle Database
• Create and manage storage structures
• Administer the Oracle Database
• Backup and Recovery