Oracle DBA Training in Chennai

Oracle DBA Training in Chennai Reviews

5 out of 5 based on 60 ratings. 25 user reviews.

Oracle DBA training in chennai, Oracle DBA training institute in chennai

Oracle DBA Training Institute in Chennai

IICT is the best Oracle DBA Training Institute in Chennai.Our training is completely Practical Oriented and its in real time.Our trainer works for leading MNC Company in chennai with almost 6 yrs industrial experience.

We are awarded as the best training center in Chennai for Oracle DBA by leading MNC Companies.

Oracle DBA training course content and Syllabus in Chennai

Introduction to Oracle : SQL (Exam - IZ0- 007)

Prerequisite

Computer Fundamentals, Windows Operating System

Course Objectives

Create database tables.

Manage database objects.

Access and manipulate data in the database using SQL statements.

Control user access to data.

Oracle 10g : SQL Certification exam readiness

Course Contents

Introduction

Writing Basic SQL SELECT Statements

Restricting and Sorting Data

Single- Row Functions

Displaying Data from Multiple Tables

Aggregating Data Using Group Functions

Subqueries

Producing Readable Output with iSQL *Plus

Manipulating Data

Creating and Managing Tables

Including Constraints

Creating Views

Other Database Objects

Controlling User Access

SQL Workshop

Using SET Operators

Oracle 10g Datetime Functions

Enhancements to the GROUP BY Clause

Advanced Subqueries

Hierarchical Retrival

Oracle10g Extensions to DML and DDL Statements

Oracle Database 10g : Administration Workshop I (1Z0-042)

Prerequisite

Oracle Database 10g : SQL

Course Objectives

Create Oracle database

Manage database objects, administer user security

Manage schema objects

Perform database backup & recovery

Oracle Database10g :AdminstrationWorskshop I Certification exam readines

Course Contents

Oracle Database

Oracle Instance

Database Storage Structures

Administering User Security

Schema Objects

Data and Concurrency

Managing Undo Data

Oracle Database Security

Oracle Network Environment

Proactive Maintenance

Performance Management

Backup and Recovery Concepts

Database Backup

Database Recovery

Flashback

Moving Data

Oracle Database 10g : Administration Workshop II (1Z0-043)

Prerequisite

Oracle Database 10g : Administration Workshop I

Course Obectives

Use recovery manager

Deal with database corruption

Monitor & manage memory

Manage schema objects

Oracle Database10g :AdminstrationWorskshop II Certification exam readiness

Course Contents

Recovery Manager

Flashback

Database Corruption

Memory

Storage

Performance Management