Oracle DBS Admin

DOWNLOAD PDF

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

  • 60 Hours
  • 20 Classes
  • 3.00 Hours per Class
Enquiry
Fee20,000/=
TypeOffline/Online
Module14
Duration60 Hours
Session20
Per Class3.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

  • Architecture Full Picture
  • Architecture Quiz!!!

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

  • REDO Concepts
  • REDO Logfile Management Demo1 and Demo 2
  • Archival Concepts
  • Archival Log Mode Demo

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

  • Networking Concepts
  • Listener Configuration Demo
  • TNSNAMES Configuration Demo
  • Database Link Concepts
  • Public Database Link
  • Private Database Link

Module-11

Data Dictionary

  • What is Data Dictionary?
  • Static Data Dictionary Views
  • Dynamic Data Dictionary Views
  • Miscellaneous Data Dictionary Views
  • Data Dictionary Demo

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)

  • RMAN Backup Types
  • Incremental Backup
  • Recovery Manager (RMAN) Terminology
  • Image Copies VS Backup sets
  • Why RMAN?
  • RMAN Commands

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

Module-17

Project Work

  • Project Work!!!
  • Where to go from here?
  • Choose your own destination