Corporate Training in Oracle 9i SQL and PL/SQL
Training
In Mumbai
Price on request
Description
-
Type
Training
-
Location
-
Duration
5 Days
Facilities
Location
Start date
Mumbai
(Mahārāshtra)
See map
Chinoy Mansion, First Floor, Block #2, Opp. St.Stephen's Church, Warden Road,, 400036
Start date
On request
Mumbai
(Mahārāshtra)
See map
OPriya Bldg.,1st Floor, Dr. Peter Dias Road, Near Mehboob Studio,, 400050
Start date
On request
About this course
No Prior knowlegde of Oracle or any other database product is required for this training
Reviews
Have you taken this course?
Course programme
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 3: Retrieving data through SELECT queries
Conditional retrieval
Joins between multiple tables
Ordering selected data
Aggregate functions
Arithmetic, character and date functions
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
Introduction to SQL
Module 2: Creating tables
Data Types
Table and column level constraints
Inserting, updating and deleting data from tables
Module 3: Retrieving data through SELECT queries
Conditional retrieval
Joins between multiple tables
Ordering selected data
Aggregate functions
Arithmetic, character and date functions
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
Corporate Training in Oracle 9i SQL and PL/SQL
Price on request