Oracle Database 11g Release 2 DBA using Enterprise Manager

Oracle Database 11g Release 2 DBA using Enterprise Manager

2 days @ £895.00 exc. VAT 

Course Code: O11GDBA

25 Years - The IT Training specialist

Upcoming Scheduled Events - next 12 months

Location Start Date Spaces Book
London 01 Mar 2018 Spaces StayAhead - Course Running Book
London 10 May 2018 Spaces StayAhead - Course Running Book
London 12 Jul 2018 Spaces StayAhead - Course Running Book
London 17 Sep 2018 Spaces StayAhead - Course Running Book
View Further Dates

Location Start Date Spaces Book
London 29 Nov 2018 Spaces StayAhead - Course Running Book

S8

Oracle Database 11g Release 2 DBA using Enterprise Manager Course Overview

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. The Oracle Database 11g Release 2 DBA using Enterprise Manager course is also suitable for support staff and personnel who are required to carry out occasional administration or troubleshooting tasks. The Oracle Database 11g Release 2 DBA using Enterprise Manager course is not aimed at delegates who are full time Database Administrators. The focus is on using Enterprise Manager to teach delegates how to manage the database.

Full time Database Administrators should attend the Oracle Database 11g Release 2 DBA - Part I and Oracle Database 11g Release 2 DBA - Part II courses.

The delegate will learn and acquire skills as follows:

  • Installing Oracle Database 11g Release 2 Software
  • Creating an Oracle database
  • Administering an Oracle database with Enterprise Manager
  • Configuring the Oracle Network Environment
  • Creating and Managing Database Storage Structures
  • Managing Schema Objects
  • Managing Users
  • Maintaining Database Security
  • Backing up, Restoring and Recovering the Database
  • Monitoring the Performance of the Database Using Advisors

Who will the Course Benefit?

The Oracle Database 11g Release 2 DBA using Enterprise Manager course is aimed at Database Administrators of small sized databases who need to install Oracle Database 11g Release 1 or Release 2 software, create, monitor and support an Oracle Database 11g database. The Oracle Database 11g Release 2 DBA using Enterprise Manager course is also suitable for support staff and personnel who are required to carry out occasional administration or troubleshooting tasks. It aims to gives delegates practical experience in installing Oracle Database 11g Release 2 software, configuring the database, performing basic monitoring of the database and in carrying out basic administration tasks.

Course Objectives

The Oracle Database 11g Release 2 DBA using Enterprise Manager course is designed to provide the knowledge and skills needed to successfully manage an Oracle database.

Requirements

Delegates wishing to attend the Oracle Database 11g Release 2 DBA using Enterprise Manager course should have an understanding of relational database concepts and basic operating system knowledge. They should also have a working knowledge of Oracle SQL, this can be gained by attendance on the pre-requisite course.

Pre-Requisite Courses

Follow-On Courses

NOTE: Course technical content is subject to change without notice.


Oracle Database 11g Release 2 DBA using Enterprise Manager Training Course

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: INTRODUCTION

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

Session 2: 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)

Session 3: 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

Session 4: 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

Session 5: 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

Oracle Database 11g Release 2 DBA using Enterprise Manager Training Course

Session 6: 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

Session 7: 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

Session 8: 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

Session 9: BACKUP, 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

Session 10: 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
Home Let Us Call You Enquiry

Place A booking





Print Friendly





Book further course dates
StayAhead Locations

If the course you require is not scheduled at your preferred centre, please contact us on 020 7600 6116 or sales@stayahead.com to enquire if we can accommodate your venue requirements.


Quick Search...


New Search
Enquiry
StayAhead Promo 5


Oracle User Group - Membership Benefits

Oracle User Group - Membership Benefits

Course Certification

Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.

Programming, Java, Web Dev, SQL, NoSQL, MySQL & MariaDB

Linux, Red Hat, Oracle Linux, SUSE & LPI

UNIX, Solaris, AIX & HP-UX

UNIX 
AIX 
HP-UX 

GDPR, Business Analysis, ITIL & Prince2

See what our clients say . . .

Extremely happy with the course. The material are all well presented and tutor is just great, very knowledgeable and no questions left unanswered.

Zak - System Administrator - Professional Services - November 2017

More Reviews

+44 (0)20 7600 6116
Cookies Policy
Copyright © 2017 StayAhead Training Ltd
sales@stayahead.com