Oracle DBA 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

Fee	20,000/=
Type	Offline/Online
Module	20
Duration	60 Hours
Session	30
Per Class	2.00 Hours

Details Course Outlines

Module-01

Introduction

What is a Database
Role of a DBA
OLTP vs OLAP Databases
What is Oracle 11g and 12g
Database abc's
Undo vs Redo Data
Oracle Instance vs Database
Quiz Time!!!

Module-02

Oracle Process Architecture

Process Architecture
Database Writer Process
Log writer Process
Checkpoint Process
SMON Process and PMON Process
RECO Process and Archiver Process
SMON Process and PMON Process
Quiz Time!!!

Module-03

Oracle Memory Architecture

Memory Architecture
Database Buffer Cache
Shared Pool
REDO log buffer
Large Pool
Java Pool and Streams Pool
Keep Buffer Pool
Recycle Buffer Pool
nK Buffer Cache
Program Global Area (PGA)
Dedicated vs Shared Databases
PGA in a Shared Envrionment
Quiz Time!!!

Module-04

Architecture Recap

Module-05

Software Installation

Virtual Machine Installation
Linux Installation
Oracle Software Installation
Oracle Parameter Files
Database creation - Manual Method Demo
Oracle Startup Steps...
Oracle Shutdown methods
Oracle 12c Upgrade

Module-06

Tablespace Management

How data is stored in a Database?
Tablespace Concepts
Online and Offline Tablespaces
Let's create a Tablespace...
Let's add more space to the Database...
Tablespace Demo 1 and Demo 2
Tablespaces with different block sizes
Temporary Tablespace Management
Temporary Tablespace Groups
Extent Management (Local vs Dictionary managed)

Module-07

UNDO Management

UNDO Concepts
Read Consistency
ORA-01555 snapshot too old error
Automatic Undo Management
UNDO Management
Configuring Undo Retention Period
Retention Guarantee!!

Module-08

REDO Management

Module-09

User Management

User Management Concepts
User Management Demo 1 and Demo 2
User Creation Exercise
Privileges
System Privileges Demo
Object Privileges Demo
Revoking User Privileges
Revoking System Privileges
Revoking Object Privileges
Let's practice what we learnt so far...
Role Management Concepts
Role Management Demo
User Profiles and User Profiles Demo
Managing Passwords using Profiles

Module-10

Oracle Networking

Module-11

Data Dictionary

Module-12

Diagnostic Data

What is Diagnostic Data?
Automatic Diagnostic Repository (ADR)
Manually navigating through the Diagnostic Data
Automatic Diagnostic Repository Command Interpreter (ADRCI)
Using ADRCI to navigate through Diagnostic Data
Creating an Incident Package for Oracle Support

Module-13

Backup and Recovery (User Managed)

Backup and Recovery Concepts 1 and Concept 2
Backup Types
Performing a Cold Backup manually
Hot Backup Steps and Hot Backup Demo
Recover a Control file from media failure
Recover a System Data file from media failure
Recover a non-system data file from media failure

Module-14

Backup and Recovery (RMAN Backup)

Module-15

Database Objects-Materialized Views

Materialized Views Introduction
Materialized Views creation Options
Materialized Views with ON COMMIT option
Materialized Views with ON DEMAND option
Materialized Views with REFRESH FAST option
Timing the refresh
Query Rewrite functionality
Materialized Views Recap

Module-16

Table Partitioning

Table Partitioning Introduction
Range Partition based on range of values
List Partition based on list of values
Hash Partition based on the hash key
Composite Partitioning by mixing things up!!
Interval Partition for automatic partition creation
Adding/Droping Partitions
Table Partitioning Recap