Description

Implement and administer the Oracle10g DBMS under optimal conditions. Among the main points covered are the architecture of the DBMS, administration techniques, management of data partitioning, information security.

Who is this training for ?

For whom ?

This course is aimed at Oracle database administrators, application administrators and consultants.

Prerequisites

A basic knowledge of relational database concepts.

A general understanding of database management systems.

Training objectives

Understand the fundamental concepts of Oracle database management.

Learn how to install and configure an Oracle database.

Master database administration techniques, including managing users, roles and privileges.

Know how to perform database backups and recoveries.

Learn how to monitor and optimize database performance.

Understand advanced Oracle database management features, such as space management storage and control files.

Be able to troubleshoot common problems encountered when administering an Oracle database.

Prepare to take associated Oracle Database Administration certifications, if applicable.

Training program

• Architecture et installation d'Oracle 10g
  • - Memory areas.
  • - Multithreaded Server architecture.
  • - Prerequisites depending on the system.
  • - Installation under Unix.
  • - Enterprise Manager Configuration Assistant.
  • - Exercise: Installing Oracle 10g.
• Instance management and database creation/deletion
  • - Administrator credentials.
  • - Setting the instance with PFILE or SPFILE.
  • - Stopping and starting an instance.
  • - Understanding and using Oracle Managed Files (OMF).
  • - Creating and deleting a database.
  • - Exercise: Changing the database settings data.
  • - Creation of a new database from scripts generated by DBCA.
• Network configuration
  • - Configuring Oracle Net Services.
  • - The "listener.
  • - ora".
  • - utilities LSNRCTL, TNSPING.
  • - Configuring the client.
  • - Oracle Net Manager and Net Configuration Assistant.
  • - Exercise: Configuring Oracle Net.
• Logical disk spaces (tablespaces)
  • - Types of tablespaces.
  • - Modifying a tablespace.
  • - The extension of a file.
  • - Exercise: Creation of different types of tablespaces.
  • - Moving database files.
• Database Structures

  - n'as pas encore du programme

• Management of objects, users and security
  • - Schema concept.
  • - Table management.
  • - Creating a user.
  • - Locking an account.
  • - Exercise: Activating data-violated constraints.
  • - Configuring user rights.
• Log files, backups and restores
  • - The role of logging files.
  • - Manage checkpoints.
  • - Backups by copying files.
  • - ARCHIVELOG and NOARCHIVELOG.
  • - Exercise: Put the database in ARCHIVELOG mode.
  • - Performing backups and recovery.
• Administration tools
  • - Using SQL*Loader.
  • - Using Data Pump Export and Import.
  • - Exercise: Unloading and loading data with SQL*Loader and Expdp/ Impdp.