Oracle Database 11g Release 2 DBA - Part I

Course

In Bristol, London, Edinburgh and 3 other venues

£ 1,795 VAT inc.

Description

  • 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 Oracle11g database.  Database administrators will gain an understanding of the architecture. Suitable for: Anyone who needs to administer, monitor and support an Oracle 11g database.

Facilities

Location

Start date

Birmingham (West Midlands)
See map
C/O Netcom Training Solutions, 6th Floor, Quay Side Tower, Broad Street, Birmingham B1 2hf, B5 4UA

Start date

On request
Bristol (Avon)
See map
C/O Computerworld, Apex House, Westerleigh Business Park, Turner Drive, Yate, BS37 5YX

Start date

On request
Edinburgh (Midlothian/Edinburghshire)
See map
16 St Mary'S Street, EH1 1SU

Start date

On request
Leeds (West Midlands)
See map
Halsbury House, Chancellor Court, 21 The Calls, LS2 7EH

Start date

On request
London
See map
6 Long Lane, Barbican, EC1A 9HF

Start date

On request
Manchester (Greater Manchester)
See map
C/O Yses, St James Court, 30 Brown Street, M2 1DH

Start date

On request
See all (6)

About this course

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Installing and Configuring Oracle
  • Creating and Managing an Oracle Database

Course programme

Oracle Database 11g Release 2 DBA - Part I Course Overview
The Oracle Database 11g Release 2 DBA - Part I course is designed to give the Oracle database administrator practical experience in setting up, administering and troubleshooting an Oracle 11g Release 1 or Release 2 database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database and perform basic backup and recovery of the database.
This Oracle Database 11g Release 2 DBA - Part I course is suitable for users of both Release 1 and Release 2.
Skills Gained
The delegate will practise:
  • Installing and Configuring Oracle
  • Creating and Managing an Oracle Database
  • Administering an Oracle 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
  • Monitoring and Resolving Lock Conflicts
  • Maintaining Database Security
  • Monitoring the Performance of the Database
  • Loading and Unloading Data
  • Backing Up and Recovering the Database
Who will the Course Benefit?
The Oracle Database 11g Release 2 DBA - Part I course anyone who needs to administer, monitor and support an Oracle 11g database. The Oracle Database 11g Release 2 DBA - Part I course is also suitable for personnel who need to administer, monitor and support an Oracle Database 11g Release 1 or Release 2 database.
Course Objectives
This Oracle Database 11g Release 2 DBA - Part I course is designed to give database administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of an Oracle 11g database. The Oracle Database 11g administrator will gain practical experience in setting up, administering and troubleshooting an Oracle 11g database.
Examinations
This course covers the main topics of the Oracle exam #1Z0-052 Oracle Database 11g: Administration I.
Exams are not included as part of the course.
Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Oracle Database 11g Release 2 DBA - Part I

£ 1,795 VAT inc.