Oracle Database 11g Release 2 DBA using Enterprise Manager

GB Direct

Course

In London

£ 895 + VAT

The best Oracle courses

See all

See all

Description

  • Type

    Course

  • Location

    London

The Oracle Database 11g Release 2 DBA using Enterprise Manager course is designed for Database Administrators of small sized databases who need to carry out basic system administration tasks on Oracle Database 11g Release 1 or 2.

Facilities

Location

Start date

London
See map
Clerks Court 18-20 Farringdon Lane Clerkenwell, EC1R 3AU

Start date

On request

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

  • Database
  • IT
  • Database training

Course programme

Follow-On Courses

  • Oracle Database 11g Release 2 DBA - Part I
  • Oracle SQL Advanced
  • Oracle PL/SQL

Introduction

  • Oracle product overview
  • Oracle Support services
  • Relational database concepts
  • Oracle architecture
  • Database administration tasks
  • Database administration tools

Installing and Configuration of an Oracle Database

  • Understand system requirements
  • Use Oracle Universal Installer to install Oracle software (OUI)
  • Create a database using Database Configuration Assistant (DBCA)
  • Delete a database using DBCA
  • Use DBCA to manage templates
  • Upgrade a database using Database Upgrade Assistant (DBUA)

Administer a Database

  • Administrative tools available to a DBA
  • Use SQL*Plus and SQL Developer to manage a database
  • Administer the database using Enterprise Manager (EM)
  • Start and stop the EM Database Console
  • EM navigation
  • Grant EM administrative privileges to a user

Configure the Oracle Network Environment

  • Overview of network configuration
  • Oracle Net Listener configuration and management
  • Oracle Net Naming methods
  • Tools for configuring and managing the Oracle network
  • Configure local naming for client connections with Net Manager
  • Start and stop the Oracle listener
  • Configure the listener with EM
  • Use TNSPING to test Oracle Net connectivity
  • Connect to the database

Manage an Oracle Instance

  • Oracle Instance
  • Instance management
  • Memory structures
  • Background processes
  • Access an Oracle database
  • Initialization parameters
  • Password file
  • Shutdown the database
  • Startup the database
  • View alert log and trace files

Database Storage Structures

  • Oracle database structures
  • Control files
  • Redo log and archive redo log files
  • Tablespaces and data files
  • Create tablespaces
  • Manage tablespaces
  • Manage undo and use the Undo Advisor
  • Use EM to view the storage structure of the database

Manage Users

  • Database administration accounts
  • User accounts
  • Create and administer user accounts
  • Lock and unlock user accounts
  • Change a user's password
  • Administer privileges and roles

Manage Schema Objects

  • Create schema objects
  • Create a new table
  • View the attributes and contents of a table
  • Understand data integrity
  • Define constraints
  • Create indexes
  • View index attributes
  • Create views
  • Create synonyms
  • Create sequences

Back Up, Recover and Restore a Database

  • Oracle backup strategy
  • Overview of backup, restore and recovery
  • Backup and recovery configuration
  • Configure ARCHIVELOG mode
  • Backup and recover the database using EM
  • Schedule backups
  • Configure backup settings
  • Configure recovery settings
  • Configure catalog settings
  • Perform recovery

Performance Monitoring

  • Self-monitoring architecture
  • Monitor an Oracle database
  • Automatic Workload Repository
  • Automatic Database Diagnostics Monitor (ADDM)
  • Use the advisors
  • Set up notification rules
  • Conclusion

See related categories

Oracle Database 11g Release 2 DBA using Enterprise Manager

£ 895 + VAT

The best Oracle courses

See all

See all