Pre-requisites |
Duration : 5days |
No Prior knowlegde of Oracle or any other database product is required for this training |
|
|
Module 1: Introdcution to Oracle as a relational database management syste |
 Introduction to SQL
|
|
|
Module 2: Creating tables |
Data Types
Table and column level constraints
Inserting, updating and deleting data from tables
|
|
| |
|
| |
Module 4: Nested queries |
Transaction processing
Set operations: Intersect, Union, Minus |
|
| |
Module 5: Views |
Synonyms
Sequences
|
|
| |
Module 6: Introdcution to PL/SQL |
PL/SQL blocks and sections
Data types
Variables and constants |
|
| |
Module 7: Conditional statements |
Looping constructs |
|
| |
Module 8: Cursors |
Cursors attributes
|
|
| |
Module 9: Oracle objects |
Object types
Nested tables
|
|
| |
Module 10: Database Triggers |
Packages :Package specifications and package body
Exception handling |
|
| |
Module 11: Stored procedures and functions |
|
| |
Module 12: Brief Introdcution to Oracle Architecture |
|
| |
| |
| |
| |
|
.
Microsoft Office
|
|
Creative Courses
|
|
Web Designing
|
|
|
|
|
|
|
|
:
091-22-23676218, 23679302, 23671772, Fax: 091-22-23671772