| |
|
|
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 |
