• Course Overview
  • Objectives
  • Prerequisites
  • Course Outline

In this database administration course students gain the skills necessary for how to install and maintain an Oracle database. Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another.

You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including basic database security, user management, and backup/recovery techniques

Upon Completion of this Course, you will accomplish following:

Participants are required to meet the following prerequisites:

40 Hours

Installing your Oracle

  • Brief History of Oracle Database
  • Tasks of an Oracle Database Administrator
  • Tools Used to Administer an Oracle Database
  • Installation: System Requirements
  • Oracle Universal Installer (OUI)
  • LAB - Pre-requisites for Installation
  • LAB - Installing Oracle Database

Managing the Oracle Database Instance

  • Oracle database Architecture
  • Describe the stages of database startup
  • Describe database shutdown options
  • View the alert log
  • Oracle Network
  • LAB - Start and stop the Oracle database and components
  • LAB - Use Oracle Enterprise Manager
  • LAB - Access a database with SQLPlus
  • LAB - Start stop Listener
  • LAB - connecting using tnsnames

Administering User Security

  • Database User Accounts
  • Predefined Administrative Accounts
  • Benefits of Roles
  • Predefined Roles
  • Implementing Profiles
  • LAB - User creation
  • LAB - Profile creation
  • LAB - Role creation
  • LAB - Grant object privileges
  • LAB - Grant system privileges

Storage Management

  • Database storage management
  • Tablespace management
  • LAB - Tablespace Creation
  • LAB - Extending/Adding data files
  • LAB - Moving/Resizing data files
  • LAB - Undo table space creation
  • LAB - Temp table space creation

Performing Database Backups

  • Backup Solutions: Overview
  • Database Cold Backup
  • Restoration of Cold Backup
  • Data pump Overview
  • LAB - Database backup
  • LAB - Database restoration
  • LAB – Data pump backup
  • LAB - Restoration dump files

Contact Us and let our consultant support you to assess the training requirements for your organization

Get in touch with our consultants