Oracle Database 11g DBA - Part I

This course is designed to give database administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of an Oracle database. The Oracle database administrator will gain practical experience in setting up, administering and troubleshooting an Oracle11g database. Database administrators will gain an understanding of the architecture and processes of the Oracle server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. Course content

• Oracle Database Architecture
• Installing and Configuring Oracle
• Creating and Managing an Oracle Instance and Database
• Administering an Oracle Instance and Database
• Configuring the Oracle Network Environment
• Creating and Managing Database Storage Structures
• Managing Redo Log Files and Control Files
• Managing Schema Objects
• Managing Users, Profiles, Privileges and Roles
• Managing Undo Data and Temporary Segments
• Managing Data and Concurrency
• Maintaining Database Security
• Database Maintenance
• Managing Performance
• Moving Data withSQL*Loader and Data Pump
• Backing up and Recovering the Database
• Support Workbench, Metalink, Service Requests and Patches