About this course
Private/In-House Training

  • We can deliver this course at either your organisation's venue, or at one of our many high-quality training venues.

    For IT training courses, you can take advantage of our computer hire service - we deliver and setup the computers for you. After the course, we will come and collect them

    Freephone 0800 781 0626

Course Reviews

Oracle Database 11g DBA - Part 1

Course Code : OD11G1

Delegates:
Anyone who needs to administer, monitor and support an Oracle 11g 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 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.

Topics Covered:
  • 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 with SQL*Loader and Data Pump
  • Backing up and Recovering the Database
  • Support Workbench, Metalink, Service Requests and Patches

Requirements:

A working knowledge of SQL is required.  This can be gained by attendance on the pre-requisite course.  Knowledge of PL/SQL would be beneficial.

Desktop Applications Professional Development Project Management Technical IT new! - Datrix Training Books