Oracle

Today the world has witnessed a virtual explosion in electronic commerce. With computers increasingly becoming the most potent instrument of globalization, the demand for professionals who can build and manage databases has grown in geometric proportions. In such a scenario, it makes sense to take advantage of the world's largest enterprise software company - Oracle, which is best known for its sophisticated relational database products. Indeed, when it comes to enterprise level database management systems on high end work stations, Oracle is one of the undisputed names to reckon with.

Available Courses

Introduction

It is no secret that the Oracle Database 10G is a pioneer database in the massive field of grid computing. Self-efficiency being the mantra of the Oracle 10G, it breaks the shackles of monotonous and underappreciated administrative work and introduces database administrators to a whole new world of personal growth and professional exposure. Although versatile, the Oracle 10G is an ideal addition to the administrative arsenal of huge organizations handling humungous volumes of data.

Audience

Working Professional

Pre-requisites

The students should have: Knowledge of SQL, equivalent to Oracle 10g: Introduction to SQL module.

Exit Profile

Learner will be able to apply key concepts of relational databases and SQL Programming Language.

Course Name

Oracle 10G: Introduction to SQL

Course Description

Identify the major structural components of Oracle Database 10gRetrieve row and column data from tables with the SELECT statementCreate reports of sorted, restricted and aggregated dataRun data manipulation language (DML) statements to update data in Oracle Database 10gObtain metadata by querying the dictionary views

Introduction

As a prerequisite to OWK2, the OWK1 program lays the foundation of your understanding about the Oracle database, thuspaving the way for effective administration and management

Audience

Working Professional

Pre-requisites

The student should have knowledge of SQL equivalent to:- Oracle Database 10g : Introduction to SQL and Oracle Database 10gPL/SQL Fundamental Knowledge of Linux is desirable

Exit Profile

Learner will be able to administer and maintain the Oracle 10G database

Course Name

ORACLE DATABASE 10G: ADMINISTRATION WORKSHOP I

Course Description

Install Oracle Database 10g and configure a databaseManage the Oracle instanceManage the Database storage structuresCreate and administer user accountsPerform backup and recovery of a databaseMonitor, troubleshoot, and maintain a databaseConfigure Oracle Net servicesMove data between databases and files

Introduction

As the second stage of a cascading set of programs, the OWK2 centers around the expansion of your technical skills. In a broad sense, you will be able to execute advanced administrative tasks on the Oracle 10G database.

Audience

Working Professional

Pre-requisites

The student should have knowledge of Oracle Database 10g: Administration Workshop I Knowledge of Linux is desirable

Exit Profile

Learner will be able to perform advanced database administration tasks on the Oracle 10G database.

Course Name

ORACLE DATABASE 10G: ADMINISTRATION WORKSHOP II

Course Description

Use RMAN to create and manage backup sets and image copiesRecover the database to a previous point in timeUse Oracle Secure Backup to backup and recover a databaseUse Oracle's Flashback technology to recover your databaseDetect block corruptions and take appropriate measures to correct themUse the various Database advisors and views to monitor and improve database performanceControl database resource usage with the Resource ManagerSimplify management tasks by using the SchedulerReview database log files for diagnostic purposesCustomize language-dependent behavior for the database and individual sessionsAdminister a VLDBImplement a secure databaseTransport data across platforms

Introduction

Developed as a sequential successor to OSQ 10 program, this program is a skill sharpening course that will enable you to create PL/SQL program units to interface with your existing databases. It is designed to enable database administrators to manage enterprise information in a cost efficient and flexible manner, so as to achieve personal as well as professional proficiency. Its time to gt your fundamentals in line.

Audience

Working Professional

Pre-requisites

The student should have knowledge of SQL equivalent to:- Oracle Database 10g : Introduction to SQL

Exit Profile

Learner will be able to design PL/SQL program units to interface with the database

Course Name

Oracle Database 10G: PL/SQL Fundamentals

Course Description

Use PL/SQL programming constructs and conditional control statements Write PL/SQL code to interface with the databaseDesign PL/SQL program units that execute efficientlyHandle run-time errors Describe stored procedures and functions