About us   Registration   Site map    
 
         
   
      New user|Forgot password  
 
   
 
 
Select Your Country to check the Schedule for this Course
Country:  
Time Zone:
   
PAYMENT METHODS
PAYPAL GOOGLE CHECKOUT
Course Name Course Code
PL/SQL 66
Course Contents

ORACLE 11g

      DBMS Concepts

Ø  What is database?

Ø  What is database system?

Ø  Different  types of database models

Ø  Different types of relations

Ø  RDBMS

Ø  ORDBMS

Ø  Features of oracle

 

SQL 

Ø  What is sql?

Ø  Role of sql in rdbms

Ø  Data types of oracle

Ø  What is sql*plus

Ø  DDL

Ø  DML

Ø  DCL

Ø  TCL

Ø  Operators

Ø  Clauses

Ø  Constraints

Ø  Joins

Ø  Sub queries

Ø  Built in functions

Ø  Views

Ø  Synonyms

Ø  Sequence

Ø  Index

Ø  Cluster index

Ø  Pseudo columns

 

 

 

 

 

 

 

PL/SQL

Ø  Introduction to pl/sql

Ø  Advanced of pl/sql over sql

Ø  Structure of pl/sql

Ø  Architecture of pl/sql

Ø  Flow control statements

Ø  Iterative statements

Ø  Attribute data types

Ø  Composite data types

Ø  Exceptions

Ø  Pragma exception

Ø  Cursors

Ø  Ref cursors

Ø  Triggers

Ø  Procedures

Ø  Functions

Ø  Package

Ø  Collections

Ø  Bulk bind

Ø  Bulk collect

 

 

 

 

 

PAYMENT METHODS
PAYPAL GOOGLE CHECKOUT