+234 – 811 – 555 – 6666 Admissions Department
Search

Oracle - Administration I

What you will learn:

This course is developed to provide you a firm knowledge in basic database administration. You will learn how to install, maintain and manage an Oracle database through hands-on exercises.

Duration: Fast Track: 5 Days. Regular: 1 Month

Benefits To You:

Gain a theoretical knowledge of the Oracle database architecture and how its components work and communicate with each other. You will further learn how to create an operational database and properly manage the various structures competently. This includes database security, user management, performance monitoring and backup/recovery techniques. Learn Advanced Features of Oracle Database Administration In order to administer the Oracle database effectively by creating, managing and controlling the different facets of the database, you will be taught thoroughly on the various features of the Enterprise Manager and how the different functions are achieved using it.

Learn To:
  • Install Oracle Grid Infrastructure.
  • Create and manage users.
  • Install and configure Oracle Database.
  • Create and manage storage structures.
  • Administer the Oracle Database.
  • Perform backup and recovery.
Tools

In this course, the major tool used is the Oracle Enterprise Manager 11g Control.

  • SQL*Plus is available as an additional command line tool. This is appropriate for a 10g and 11g audience.

Audience
  • Database Administrators
  • Java Developer
  • PL/SQL Developers
  • Support Engineer
  • Data Warehouse Administrators
  • Technical Administrator
  • Technical Consultant
Related Training

Required Prerequisites

  • Taken Oracle Introduction to SQL course or equivalent experience
  • Oracle Database: Introduction to SQL
  • Suggested Prerequisites

  • Oracle Database: PL/SQL Fundamentals
  • Taken Oracle PL/SQL course or equivalent experience
Course Objectives
  • Install Oracle Grid Infrastructure
  • Install and configure Oracle Database 11g
  • Configure Oracle Net services
  • Manage the database storage structures
  • Create and administer user accounts
  • Monitor and administer undo data
  • Perform basic backup and recovery of a database
  • Monitor performance
  • Manage data concurrency
  • Describe Oracle Database Architecture
Course Topics
  • Exploring the Oracle Database Architecture.
  • Installing your Oracle Software.
  • Creating an Oracle Database.
  • Managing the Oracle Database Instance.
  • Manage the ASM Instance.
  • Configuring the Oracle Network Environment.
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Data Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Security
  • Database Maintenance
  • Performance Management
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data
  • Working with Support
Apply Now