Oracle Basic DBA Course

Introduction

As an Oracle Database Administrator (DBA), you are responsible for the overall operation of the Oracle database and maintaining its health.
You will learn more about the operation of the database server and the structure of the Oracle database where they are relevant to the performance of specific database management tasks.

OS Commands

• General OS Commands for day-to-day Database tasks
• File System, Configuration and Environment files
• Shell Scripting for monitoring, and automating jobs

OS Pre-requisites for Oracle Database and Oracle Applications Database

Oracle SQL and PL/SQL

• Basic SQL
• Advanced SQL
• SQL Reporting
• PL/SQL Basics
• Advanced PL/SQL
• PL/SQL for DBAs
• Stored Procedures
• DBMS PL/SQL Packages

Oracle DBA (4 Weekends)

• Oracle Database Architecture
• Installation Oracle Database
• Upgrade of Oracle Database
• Back and Recovery, RMAN
• Performance Tuning Overview
• Database Character Set and National Language Support (NLS)
• Database Cloning
• DataGuard for Disaster Recovery Compliance
• Oracle Real Application Clusters
• Oracle Cluster and Automatic
• Oracle Database Flash Recovery (FRA) and Flash Back Technologies