Microsoft Office
 
 
 
 
 
 
 
 
 
Creative Courses
 
 
 
 
 
 
 
   
Web Designing
 
 
 
 
 
 
 
   
Network Courses
 
 
 
 
   
 
   
Programming Courses
 
 
 
 
 
 
  


IT Corporate Training
 
 
 
Oracle 9i SQL and PL/SQL
Pre-requisites Duration : 5 day

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


Solve your Queries Online related to our Courses
Mobile Number
M.E. Khairaz (MD)
+919820134058
Gmail
 compufield@gmail.com
Yahoo Messenger
 Yahoo Messenger
compufield@yahoo.com
ICQ
 MSN Messenger
compufield@hotmail.co.uk  
Skype
compufieldinfo@skype.com

Facebook

Twitter
HO: Chinoy Mansion, First Floor, Block #2, Opp. St.Stephen's Church, Warden Road, Mumbai(Bombay)-400 036, India. :+91-22-23676218

"aonlinetraining - distance learning school, institute, college, academy, multimedia, digital art, interior and fashion designing, jewellery, jewelry, jewelery design, internet technology, and software engineering courses" "institute of online internet e-learning, courses in computer generated fashion designing, technology,free tutorials haute couture using coreldraw and photoshop software-CAD" "jewelcad distance education courses, computer based jewellery, jewelry, jewelry, jewelery designing in gold, platinum, diamonds, professional internet learning of necklaces, bracelets, rings, earrings designs"
 
"Compufield -computer Institute specialized in fast track courses-multimedia,web designing,software engineering,certification courses,fashion,jewellery,interior designing courses. India,Bombay(Mumbai)." "COMPUFIELD-Leader in Global IT Corporate training having more than 20yrs exp.Programs offered MS-Office, Advance Excel, Java, Oracle, Linux and many more." "Compufield : free e-greeting cards, animated, musical greetings, ecards, postcards for Christmas, xmas, new year, eid, diwali, valentine's day, birthday, friendship, anniversary, love, congratulations, Halloween."

Contact Us related to our Courses

MSN MessengerMobile Number
+91-9820134058 (Mr. Khairaz [MD])

OFFICE : Chinoy Mansion, First Floor, Block # 2, Opposite Church, Warden Road, Mumbai (Bombay)-400 036,India
: 091-22-23676218, 23679302, 23671772, Fax: 091-22-23671772