Oracle Database 11g Administration Workshop I

Course details

What you will learn

This course is designed to give Participants a firm foundation in basic administration of Oracle Database 11g. In this class, Participants learn how to install and maintain Oracle Database 11g. Participants gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Participants 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.

Learn To:

Manage users

Manage storage structures

Backup and Recovery

Install and configure an Oracle database

Audience

Database Administrators

Database Designers

Developer

Support Engineer

Technical Administrator

Prerequisites

Required Prerequisites

Working knowledge of SQL

Oracle Database 11g: Introduction to SQL

Course Objectives

Describe Oracle Database Architecture

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

Backup and recover a database

Monitor performance

Use the database diagnostic monitor