Oracle Database 11g: Administration Workshop I

Beschreibung

SEMINARINHALT

• 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 Schema Objects



• Managing Data and Concurrency



• Managing Undo Data



• Implementing Oracle Database Security



• Database Maintenance



• Performance Management



• Backup and Recovery Concepts



• Performing Database Backups



• Performing Database Recovery



• Moving Data



• Enhancing Database Capabilities

Zielgruppe

TEILNEHMERKREIS

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

Voraussetzungen

TEILNAHMEVORAUSSETZUNGEN

Working knowledge of SQL 2

Oracle Database 11g: Introduction to SQL

Kursinhalte

SEMINARZIEL

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