Oracle 11g DBA Release 2 - Part I

Focus on Training

Course

In London-City

£ 1,695 + VAT

The best Oracle courses

See all

See all

Description

  • Type

    Course

  • Location

    London-city

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. 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. Learning Objectives The delegate will practise: Installing and Configuring OracleCreating and Managing an Oracle DatabaseAdministering an Oracle DatabaseConfiguring the Oracle Network EnvironmentCreating and Managing Database Storage StructuresManaging Redo Log Files and Control FilesManaging Schema ObjectsManaging Users, Profiles, Privileges and RolesManaging Undo Data and Temporary SegmentsMonitoring and Resolving Lock ConflictsMaintaining Database SecurityMonitoring the Performance of the DatabaseLoading and Unloading DataBacking Up and Recovering the Database 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.

Facilities

Location

Start date

London-City ((select))
EC3V 9LJ

Start date

On request

About this course

Delegates who wish to attend the Oracle Database 11g Release 2 DBA - Part I course should have an understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. 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

  • Network Training
  • Network
  • Database training
  • Database
  • Server

Course programme

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.

Please note that the 10g version of this course is also available on request

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

Course Introduction

INTRODUCTION TO ORACLE DATABASE 11g
ORACLE DATABASE 11g ARCHITECTURE
INSTALLATION AND CONFIGURATION OF AN ORACLE DATABASE
ADMINISTER A DATABASE INSTANCE
CONFIGURE THE ORACLE NETWORK ENVIRONMENT
MANAGE AN ORACLE INSTANCE
TABLESPACE AND DATAFILE MANAGEMENT
MANAGE REDO LOGS
MANAGE CONTROL FILES
MANAGE SCHEMA OBJECTS
MANAGE USERS
MANAGE PROFILES AND RESOURCES
MANAGING PRIVILEGES
DATABASE AUDITING
UNDO MANAGEMENT
MOVING DATA
OVERVIEW OF MANAGING AN ASM INSTANCE
DATA CONCURRENCY AND LOCK CONFLICTS
PROACTIVE DATABASE MAINTENANCE
PERFORMANCE MANAGEMENT
BACKUP AND RECOVERY CONSIDERATIONS
DATABASE BACKUPS
DATABASE RECOVERY
ENHANCE THE CAPABILITIES OF THE DATABASE

See related categories

Oracle 11g DBA Release 2 - Part I

£ 1,695 + VAT

The best Oracle courses

See all

See all