TRAINING PROGRAMME ON LINUX & ORACLE 10G (20.7.2009 to 01.8.2009)

 

Day

Session I

(10.00 am to 11.15am)

Session II

(11.30am to 12.45 pm)

Session III

(2.00 pm to 3.15 pm)

Session IV

(3.30 pm to 4.45 pm)

20.07.2009

Overview & History Of Red Hat Linux

Linux Basic Use And Running command and help.

Users groups and permissions.

 

Standard I/O and Pipes

Text Processing Tools

Faculty

AMIT

AMIT

AMIT

AMIT

21.07.2009

Finding and Processing Files

The Linux File System In-Depth

Package Management

System Services

 

FileSystem Management

Faculty

AMIT

AMIT

AMIT

AMIT

22.07.2009

Introduction Session

 

Using Oracle Database 10g Data Types

Datetime Data Types

Enhancements to the GROUP BY Clause

Related Practicals

Faculty

AMITA

AMITA

AMITA

AMITA

23.07.2009

Introducing BINARY_FLOAT, BINARY_DOUBLE

Using General SQL Enhancements

Using Regular Expressions

Related Practicals

Faculty

AMITA

AMITA

AMITA

AMITA

24.07.2009

Introduction to PL/SQL

Oracle Supplied Packages

Large Objects

Collections

Faculty

AMITA

AMITA

AMITA

AMITA

25.07.2009

Collections Continued

Programming with PL/SQL Enhancements

 

Using the SQL Model Clause

Related Practicals

Faculty

AMITA

AMITA

AMITA

AMITA

27/07/09

Introduction (Database Architecture)

 

Database Architecture

 

 

Installing the Oracle Database Software

 

Installing the Oracle Database Software

 

 

Related Practical

Creating an Oracle Database

 

 

 

Related Practical

Faculty

ANIRBAN

ANIRBAN

ANIRBAN

ANIRBAN

28/07/09

Managing the Oracle Instance

 

Related Practical

Managing Database Storage Structures

 

Related Practical

 

Administering User Security

 

Related Practical

Managing Schema Objects

 

 

Related Practical

Faculty

ANIRBAN

ANIRBAN

ANIRBAN

ANIRBAN

29/07/09

Managing Data and Concurrency

 

Related Practical

 

Managing Undo Data

 

 

Related Practical

Configuring the Oracle Network Environment

 

Related Practical

Proactive Maintenance

 

 

Related Practical

Faculty

ANIRBAN

ANIRBAN

ANIRBAN

ANIRBAN

30/07/09

Backup and Recovery Concepts

 

Related Practical

 

Performing Database Backups

 

 

Related Practical

Performing Database Recovery

 

Related Practical

Moving Data

 

 

Related Practical

Faculty

ANIRBAN

ANIRBAN

ANIRBAN

ANIRBAN

31/07/09

Configuring Recovery Manager

 

Related Practical

 

Using Recovery Manager

 

 

Related Practical

Incomplete Recovery

 

 

Related Practical

Flashback

 

 

Related Practical

Faculty

ANIRBAN

ANIRBAN

ANIRBAN

ANIRBAN

01/08/09

Monitoring and Managing Memory

 

Related Practical

Monitoring and Managing Storage

 

Related Practical

Automatic Storage Management

 

Related Practical

Data Movement

 

 

Related Practical

Faculty

ANIRBAN

ANIRBAN

ANIRBAN

ANIRBAN

Tea Break: 11.15 am to 11.30 am and 3.15 pm to 3.30 pm and Lunch Break: 12.45 pm to 2.00 pm.