Corporate Training in Oracle 9i SQL and PL/SQL

COMPUFIELD® Computer Institute
In Mumbai

Price on request
You can also call the Study Centre
22236... More
Students that were interested in this course also looked at...
See all

Important information

Description

Important information
Venues

Where and when

Starts Location
On request
Mumbai
OPriya Bldg.,1st Floor, Dr. Peter Dias Road, Near Mehboob Studio,, 400050, Maharashtra, India
See map
On request
Mumbai
Chinoy Mansion, First Floor, Block #2, Opp. St.Stephen's Church, Warden Road,, 400036, Maharashtra, India
See map

Frequent Asked Questions

· Requirements

No Prior knowlegde of Oracle or any other database product is required for this training

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

Students that were interested in this course also looked at...
See all