• Course Overview
  • Objectives
  • Prerequisites
  • Course Detail

About the course

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

Objectives

After completing this course, the participant will be able to:

Prerequisites

To attend this course the participant must have the knowledge about these knowledge areas:

Database Administartion Level - I course outline

5 Hours
Course Outline

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 tns names

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