Oracle Database 10g DBA - Part I
Course
In London
Description
-
Type
Course
-
Location
London
-
Class hours
35h
-
Duration
5 Days
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 Oracle10g database. Database administrators will gain an understanding of the architecture. Suitable for: Anyone who needs to administer, monitor and support an Oracle 10g database.
Facilities
Location
Start date
Start date
About this course
A working knowledge of SQL*Plus is required. This can be gained by attendance on the pre-requisite course. Knowledge of PL/SQL would be beneficial.
Reviews
Subjects
- Creating and Managing an Oracle Database
- Installing and Configuring Oracle
Course programme
Anyone who needs to administer, monitor and support an Oracle 10g database.
Objectives:
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 Oracle10g 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. This course covers the main topics of the Oracle exam #1Z0-042 Oracle Database 10g: Administration I .
Note:
Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience.
Topics Covered:
- Installing and Configuring Oracle
- Creating and Managing an Oracle database
- Administering an Oracle database
- Configuring the Oracle Network Environment
- Configuring Shared Servers
- 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
- Monitoring and Resolving Lock Conflicts
- Maintaining Database Security
- Monitoring the Performance of the Database
- Loading and Unloading Data
- Backing up and Recovering the Database
- Flashback
Requirements:
A working knowledge of SQL*Plus is required. This can be gained by attendance on the pre-requisite course. Knowledge of PL/SQL would be beneficial.
Oracle Database 10g DBA - Part I