Oracle DBA 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
Module19
Duration60 Hours
Session30
Per Class2.00 Hours

Details Course Outlines

Module-01

Overview of Oracle Database and Evaluation of Oracle Database

  • What is Database and Why Oracle Database is so important?
  • What is the need for a Database?
  • Type of Database Management System
  • What is Relational Database Management System?

Module-02

Popular Relational Database Management System

  • How to Use RDBMS?
  • Hands-On Of Using RDBMS
  • What is Converged Database?
  • Overview of oracle database 19c and evaluation of database
  • Journey to automation

Module-03

Hands on of Installing Oracle Database 19c

  • Require Personal Laptop with Minimum 8 GB of RAM/ VM for each person
  • Installing Oracle Database 19c
  • You Can Check by oracle-database-preinstall-19c
  • Configure sysctl.conf
  • Installation Packages
  • Create Group and Users
  • Configure Listener
  • Configure Control File
  • Configure Redo File
  • Configure Data File
  • QUIZ

Module-04

Oracle Database File Management (Check Hands On)

  • Parameter File
  • Data File
  • Environment File
  • Alter Log File
  • Listener and TNS File
  • Control File
  • Redo Log File
  • Password File

Module-05

Database Process Management (Theory and Check By Handson)

  • Check by SQL Query
  • Client and Server Processes from System Process Monitor Process (PMON) Listener
  • Registration Process (LREG) System Monitor Process (SMON) Database Writer Process (DBW)
  • Log Writer Process (LGWR)
  • Checkpoint Process (CKPT)
  • Manageability Monitor Processes (MMON and MMNL) Recoverer Process (RECO)

Module-06

Oracle database Memory Architecture

  • Introduction to Oracle Database Memory Structures
  • System global area (SGA)
  • Program global area (PGA)
  • User global area (UGA)
  • Automatic memory management
  • Database Buffer Cache
  • Redo Log Buffer
  • Library Cache

Module-07

Oracle Database Architecture

  • Recap and Overview of Oracle DB Architecture
  • Exam and Quiz

Module-08

Oracle Real Application Cluster

  • What is SCAN IP
  • Cluster Interconnection
  • Shared Storage
  • OCR and OLR
  • Node Eviction
  • Hands On Guideline for Oracle DB RAC Installation and Checking
  • QUIZ and EXAM

Module-09

Oracle Database Automatic Storage Management

  • What is ASM
  • Volume Manager and File System
  • What is ASM Instance
  • Redundancy in ASM
  • About Mirroring and Failure Groups
  • About Oracle ASM Disks
  • QUIZ

Module-10

Oracle Database Backup, Restore and Recover

  • Hot Backup
  • Cold Backup
  • Handson of RMAN
  • Recovery control file handson
  • Incremental Backup
  • Handos of Cold Backup and Restore

Module-11

Oracle Database User Management (Hands-On)

  • System Users
  • Create Users (Demo)
  • User Privileges
  • DDL, DML Commands (Demo)
  • Managing User Role
  • Viewing User Roles and Priviledges (Demo)
  • Revoking Roles and Priviledges (Demo)
  • User Profiles

Module-12

Tablespace Management (Hands-On)

  • Assign Tablespace Quotas to Users
  • Creating Tablespace
  • Managing the SYSAUX Tablespace
  • Using Read-Only Tablespaces
  • Altering and Maintaining Tablespaces
  • Renaming Tablespaces
  • Dropping Tablespaces
  • Specifying Nonstandard Block Sizes for Tablespaces
  • Migrating the SYSTEM Tablespace to a Locally Managed Tablespace
  • Temporary Tablespace

Module-13

Undo Management

  • Introduction to Automatic Undo Management
  • Setting the Minimum Undo Retention Period
  • Sizing a Fixed-Size Undo Tablespace
  • Managing Undo Tablespaces
  • Managing Temporary Undo
  • Undo Space Data Dictionary Views

Module-14

Redo Log Management (Demo)

  • What Is the Redo Log?
  • Creating Redo Log Groups and Members
  • Forcing Log Switches
  • Verifying Blocks in Redo Log Files
  • Clearing a Redo Log File
  • Redo Log Data Dictionary Views

Module-15

Control File Management

  • Guidelines for Control Files
  • Creating Control Files
  • Backing Up Control Files
  • Recovering a Control File Using a Current Copy
  • Dropping Control Files
  • Control Files Data Dictionary Views

Module-16

How to Monitor Oracle Database

  • Daily Activity Monitoring Activities
  • Some Monitoring Demo
  • EM For Monitoring

Module-17

Oracle Database in Oracle Cloud (Demo)

  • What is Oracle Cloud
  • How Oracle DB runs on Oracle Cloud

Module-18

Oracle Autonomous Database (demo)

  • What is the mean of Oracle Autonomoud DB?
  • Handson of Autonomous DB

Module-19

Oracle Database Security and Auditing

  • What is DB security
  • How DB Security Breaches?
  • Protect data by encryption
  • Auditing of DB
  • Transparent Data Encryption