Scope of the program:

Oracle Database Administrator
Paper I : SQL/PL-SQL (80 Hours)

Oracle is a Relational Database Management System(RDBMS). Oracle is the latest technology, today's system Designers and Developers can build 21st century enabled applications.Oracle has also demonstrated a continuous ability to build products that help us exceed the demands of the information enabling age we live in.

SALIENT FEATURES

Oracle has sophisticated security mechanisms control access to sensitive data by an assortment of privileges. Oracle provides sophisticated backup & recovery routines. Backup creates a second copy of Oracle Data, recovery restores a copy of data from back up. Oracle provides flexible space management. It has special abilities that are capable of handling very large databases.Oracle provides open connectivity to & from other vendor's software. Oracle server supports a wide range of Development tools, end user query tools, off the shelf applications & office wide information tools.

APPLICATIONS

Education Industry
Software Development Industry
Data warehouse and maintenance
Domestic Air Services
Production Industry
Banking Industry

TOPICS COVERED

Introduction to oracle products.
SQL*plus features and commands.
Data manipulation commands, data control commands.
Altering tables, data definition commands, joins, types of functions.
Process Transaction commands, SQL*plus set theory.
Sub-queries and Co-related queries.
Security in Oracle
Locking
Oracle Objects - Views, clusters, indexes, synonyms, snapshots.
Formatting output of queries, Report creation.
Implementing Object Oriented features in Oracle.
Introduction to PL/SQL.
Packages
Creating Cursors, exceptions, procedures, functions and triggers.
Understanding the Oracle Architecture.
Features of Latest Oracle Version.
Data Dictionary
DBA - An Overview

COURSE - 2

Oracle Certified Professional Database Administrator

Enterprise DBA Paper II : Database Administration (30 Hours)

Oracle8i Database Administration: Create a Database
Oracle8i Database Administration: Manage an Instance
Oracle8i Database Administration: Manage Storage Structures
Oracle8i Database Administration: Manage Data Storage
Oracle8i Database Administration: Manage Security
Oracle Simulator: Oracle8i Database Administration Pack #1
Oracle Simulator: Oracle8i Database Administration Pack #2
Oracle Simulator: Oracle8i Database Administration Pack #3
Enterprise DBA Paper III : Backup and Recovery (30 Hours)
Oracle8i Backup & Recovery: Strategies and Backups
Oracle8i Backup & Recovery: Troubleshooting and Recovery
Oracle Simulator: Oracle8i Backup & Recovery Pack #1
Enterprise DBA Paper IV : Performance Tuning (30 Hours)
Oracle8i Performance Tuning: Strategies and Techniques
Oracle8i Performance Tuning: Managing Memory and Disk I/O
Oracle8i Performance Tuning: Optimizing Sorts and Minimizing Contention
Oracle Simulator: Oracle8i Performance Tuning Pack #1
Enterprise DBA Paper V : Network Administration (15 Hours)
Oracle8i Network Administration: Net8 Architecture and Basic Configuration
Oracle8i Network Administration: Net8 Additional Configuration and Troubleshooting
Oracle Simulator: Oracle8i Network Administration Pack #1
APPLICATIONS

Education

Database Designing
Data warehousing and Data mining
International Air Services
Multimedia Production Industry
Telecom Industry
Banking Industry
Insurance Industry
Many Govt. Department where Database is kept.
Defense Department

Course Duration : 110 Hrs/ 12. Weeks

Batch Strength : 25 /Batch

Track record of placements: USHACOMM,THINKSOL,CONNECTIVASYSTEMS,ANSHINSOFT,PATNI,KANBAY,
IBM,TCS,ZENSAR and V2Technologies etc....

Special Offer : Session on Personality Development,Aptitude Tests, GD and Crack Interview.

Required : Basic Knowledge Of Front End programming Language.