Corporate Training in Oracle 9i SQL and PL/SQL

Training

In Mumbai

Price on request

Description

  • 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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

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

Corporate Training in Oracle 9i SQL and PL/SQL

Price on request