Course Details

The hugely popular Oracle database  is learnt through the below areas:SQL

Oracle Overview

Oracle Installation

Fundamental I and II

Performance Tuning

Syllabus: 

 Background, Data Modeling, Window/UNIX/LINUX, and SQL *PLUS

The Oracle DBA’s World               

Relational Db Modeling Db Design

Essential OS for the Oracle DBA

SQL*Plus Oracle Enterprise Mgr

Architecture, Schema, Transaction

Managing Tablespaces

Schema Management

Oracle Transaction Management

Installing and Upgrading Oracle Db 11g

Creating a Database 

Connectivity User Management

User Mgt and Database Security

Loading and Transforming Data

Using Data Pump Export and Import

Backing Up Databases

Database Recovery

Automatic Mgt Online Capabilities

Managing and Monitoring the Operational Database

Improving Database Performance: SQL Query Optimization

Performance Tuning