| |
|
|
ORACLE |
| Oracle 9i DBA |
Oracle 9i Developer |
| |
SQL |
SQL |
| |
 |
Introduction |
 |
Introduction |
| |
 |
Writing Basic SQL Statemnt |
 |
Writing Basic SQL Statemnt |
| |
 |
Restricting & Sorting Data |
 |
Restricting & Sorting Data |
| |
 |
Single Row Functions |
 |
Single Row Functions |
| |
 |
Displaying Data from Multiple Tables |
 |
Displaying Data from Multiple Tables |
| |
 |
Aggregating Data using Group Functions |
 |
Aggregating Data using Group Functions |
| |
 |
Sub_Queries |
 |
Sub_Queries |
| |
 |
Producing Readable Output with iSQL* plus |
 |
Producing Readable Output with iSQL* plus |
| |
 |
Mainpulating Data |
 |
Mainpulating Data |
| |
 |
Creating and Managing Tables |
 |
Creating and Managing Tables |
| |
 |
Oracle 9i Extensions to DML and DDL statements |
 |
Oracle 9i Extensions to DML and DDL statements |
| |
|
|
|
|
| |
DBA Fundamental - I |
PL/SQL |
| |
 |
Oracle Architectural Components |
 |
Introduction |
| |
 |
Getting started with Oracle Server |
 |
Declaring Variables |
| |
 |
Managing an Oracle Instance, Creating a Database |
 |
Writing Executable Statements |
| |
 |
Data ictionary Contents and Usage |
 |
Interacting with the Oracle Server |
| |
 |
Maintaining the Control File,Redo Log Files |
 |
Writing Control Structures |
| |
 |
Managing Tablespaces and Data Files |
 |
Working with composite Data types |
| |
 |
Storage Structures and Relationships |
 |
Handdling Exceptions,creating procedures |
| |
 |
Managing Undo Data, Tables, Indexes |
 |
Creating Functions,managing Subprogram |
| |
 |
Maintaining Data Integrity,Managing Password |
 |
Writing Explicit cursors and advanced Explicit cursor |
| |
 |
Loading Data into a Database & Globalization Support |
 |
Creating Packages, More Package Concepts |
| |
|
|
|
| |
DBA Fundamental - II |
Forms and Reports |
| |
 |
Basic Oracle Net Architechture , Server- side configuration |
 |
Create Form Modules |
| |
 |
Basic Oracle Net Services Clinet - side Configuration |
 |
Including components in multiple windows |
| |
 |
Usage and Configuration of the Orcle shared server |
 |
Link one Form module to another |
| |
 |
Backup and Recovery Overview |
 |
Implement Triggers |
| |
 |
Instance and Media Recovery structures |
 |
Reuse Objects and Code |
| |
 |
Configuring the Database Archiving Mode |
 |
Test Form modules in a Web browser |
| |
 |
Oracle Recovery Manager Overview and Configuration |
 |
Debug Form modules in a 3-Tier environment |
| |
 |
User managed backups,RMAN backups |
 |
Working with Bata Blocks |
| |
 |
User managed complete & Incomplete Recovery |
 |
Frames |
| |
 |
RMAN Complete Recovery, Incomplete Recovery&Maintenance |
 |
Canvases |
| |
 |
Recovery Catalog Creation and Maintenance |
 |
Writing Flexible Codes |
| |
 |
Transporting Data between Databases |
 |
Sharing Objects and Codes |