Target Audience:

• Database Administrators who want to have real time administration training.
• IT professionals who want to make their career in Oracle Database Admiration
• Oracle Developers who want to make their career in Database Administration
• Fresh Graduates who want to make their career in Database Administration.
• IT Developers who want to have good understanding of Database as it is the backbone of any GUI application design and development.
• Job seekers who are facing interviews. Around 40% of the interview questions are based on database understanding.

Pre-Requisites:

• Basic Knowledge of Basic Oracle Database & SQL/PLSQL
• Basic Knowledge of Windows/Linux

Course Duration: 3 Months

Course: Fee Rs.5000 (Discount Group)

Class Type: Class Room /Online Training

1. Introduction

• An Overview to Oracle Database
• Major Databases and Database Vendors
• Oracle Database Editions
• Understanding Database Release Version Numbers
• Types of DBA based on Roles and Responsibilities
• DBA Levels based on Roles and Responsibilities

2. Oracle Server Installation On Windows/Linux 

• Understanding OFA (Optimal Flexible Architecture)
• Pre-Requisites
• Downloading Oracle Server
• Installation Step by Step
• Understanding Various Installation Types
• Post installation Settings
• Initialization Parameter setting
• Oracle profile setting
• Password policy setting
• Deferred segment setting
• Environment Variable Setting
• Oracle Listener Creation using NETCA
• Dropping and Re-Creating Oracle LISTENER
• Demo user creation roles and privileges

3. Oracle Client Installation

• Downloading Oracle Client Software
• Understanding various Installation Types
• Installation Step by Step
• Post installation Settings
• Environment Variable Setting
• Creating Oracle Net Service Names using NETCA
• Client Server Environment setup involved issues demonstration
• Oracle Listener Error Real time Scenarios and resolution
• Demo user creation

4. Oracle Database Creation methods

• Using DBCA
• Manual Creation
• Catlog.sql and Catproc to Create/Recreate Database Internal Views/Procedures/Packages

5. Parameters & Parameter Files

• Parameter Files Introduction
• Difference between PFILE & SPFILE
• Changing Parameter values
• Getting the Currently used parameter file Type
• Getting Parameter Settings
• Creating PFILE from SPFILE
• Creating SPFILE from PFILE
• When to force Database to start with PFILE
• Changing Values of SPFILE
• Starting Database with PFILE
• Starting database SPFILE
• Parameter File Backup & Recovery.
• 6. Starting & Stopping Database
• Database Startup Methods
• Database Startup Stages
• Database Shutdown Methods
• Database Shutdown Stages
• Real time Troubleshoot with Database Shutdown & Startup Failure and Errors

7. Introduction to Oracle Database Objects

• Tables
• Indexes
• Views
• Materialized Views
• Synonyms
• Sequences
• Procedures
• Functions
• Package (Body & Specs)
• Triggers