Oracle Database 11g DBA

Course details

The Knowledge Academy Oracle Database 11g Release 2 DBA - Part I 5 day course covers the following topics:

Introduction

Our Oracle Database 11g DBA - Part One course is aimed at Database Administrators who require the practical experience in setting up, administering and troubleshooting an Oracle 11g Release 1 or Release 2 database.

Who is the course for?

Database Administrators who require the practical experience in setting up, administering and troubleshooting an Oracle 11g Release 1 or Release 2 database.

What will I learn?

• 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

Course Content 

• 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

Course Availability:

• The spaces remaining on all courses across the website reflect the availability of the maximum printed course materials and equipment available in stock for any given event. If the spaces remaining do not appear, then there is comfortably enough lead time to provision course materials and equipment upon booking.

• What time shall I arrive at the venue?

  Please arrive at the venue for 08:45am

• What are the pre-requisites?

  Attend Oracle SQL

• Who is this course for?

  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.

• What examination follows this course?

  This course covers the main topics of the Oracle exam #1Z0-052 Oracle Database 11g: Administration I.

• Are examinations included?

• No, the course does not include the examination

• The Knowledge Academy Courseware Book
  
• Exam preperation
• Manual
• Certificate
• Experienced Instructor
• Refreshments