Oracle DBS Admin

Oracle Database Administration for Absolute Beginners’ course explains about the basic concepts of Relational Database Management Systems (RDBMS). It will help you to become an Oracle Database Administrator(Oracle DBA).Database Administrator is one of the highly sought after jobs in the IT industry. It is also one of the highly stable jobs as DATA is a vital part of every organization and they need that to be in the capable hands of a good DBA team.This course is absolutely for beginners. This is applicable for those who would want to learn Oracle Database 12c as well as Oracle Database 11g.

This would be ideal for..

  • Those who are already in IT and would like to jump into the world of Database Administration.
  • College students who would like to learn about Database concepts so that they can achieve high grades in their RDBMS related curriculum.
  • College students who would like to get into Oracle Database Administration as soon as they finish their college.
  • Fresh graduates who are looking for a job in the IT industry.
  • Anyone with the determination of getting into IT in order to have a better career.

Course Objectives

After completing this course, students will be able to : 

  • Describe Oracle Database architecture
  • Describe Oracle Database Cloud Service (DBCS) architecture and features
  • Create and manage DBCS database deployments
  • Configure the database to support your applications
  • Manage database security and implement auditing
  • Implement basic backup and recovery procedures
  • Move data between databases and files
  • Employ basic monitoring procedures and manage performance

Target Audience

  • Database Administrator
  • Data Warehouse Administrator
  • Database Designer
  • Support Engineer
  • Technical Administrator

Course Pre-requisite

  • ORACLE  DATABASE  11G : SQL FUNDAMENTALS – COMPLETE LIBRARY
  • ORACLE  DATABASE  11G : PROGRAM WITH PL/SQL – COMPLETE LIBRARY

Course Duration

Fee20,000/=
TypeOffline/Online
Module14
Duration60 Hours
Session20
Per Class3.00 Hours

Details Course Outlines

Module-01

Introduction

Module-02

Oracle Process Architecture

Module-03

Oracle Memory Architecture

Module-04

Architecture Recap

Module-05

Software Installation

Module-06

Tablespace Management

Module-07

UNDO Management

Module-08

REDO Management

Module-09

User Management

Module-10

Oracle Networking

Module-11

Data Dictionary

Module-12

Diagnostic Data

Module-13

Backup and Recovery (User Managed)

Module-14

Backup and Recovery (RMAN Backup)

Module-15

Database Objects-Materialized Views

Module-16

Table Partitioning

Module-17

Project Work