Contact Information

  • :
  • :
  • :
  • :

Vision Networks

2nd Floor, Manikanta Crown, Beside Kalanikethan, Chaitanyapuri Main Rd, Kamala Nagar, Dilsukhnagar, Hyderabad, Telangana 500060.
Ph : 9247278885, 66758885, 9949954818.

Oracle

ORACLE (SQL, PL/SQL)

SQL

  • What is ORACLE & introduction to ORACLE
  • Features & capabilities
  • History of data base
  • Data base definition & DBMS
  • Examples of data bases
  • Introduction to SQL
  • Data types in SQL
  • Languages in SQL
  • Data definition language(DDL) (create, desc , alter, truncate)
  • Data manipulation language(DML) (insert, update , delete)
  • Data query language(DQL) (select) (from and where clause)
  • Operators (comparison, arithmetic, logical, between, in, like)
  • Integrity constraints (entity , domain , referential)
  • Entity integrity constraints(unique, primary key)- field & table level
  • Domain integrity constrains (check , not null)
  • Referential integrity constrains( foreign key) - field & table level
  • On delete cascade
  • Transition control language ( commit , rollback , save point)
  • Functions in oracle( character, number, date, conversion, miscellaneous)
  • Character functions
  • Number functions
  • Date functions
  • Conversion & miscellaneous functions
  • Aggregate or group functions
  • Group by clause and having clause
  • Nesting of group functions & set functions or operators
  • Joins(simple, equi, non-equi, outer join, self join)
  • Equi, non-equi and simple
  • Self and outer join
  • Sub queries(single row, multiple row, multiple column, correlated)
  • Data base objects(views, synonyms, sequence, indexes)
  • SQL Formatting Commands(column, compute, title, set page, storage and printing)

PL/SQL

  • Introduction To PL/SQL & Advantages
  • Main features Of PL/SQL
  • Block Structure Of PL/SQL & Pseudo Structure Of a PL/SQL Block
  • Execute Statements And PL/SQL Blocks From SQL *Plus
  • Types Of Blocks In PL/SQL(Anonymous, Named, Sub Programmed)
  • Data Types, Character Set, Identifiers
  • Declarations & Assigning values , Presenting Data On To The Screen
  • Basic Programs & Execution
  • Scope &Visibility Of Blocks
  • Control Structures ( Branching , Selection , Looping)
  • Branching statements ( Simple If , If-Than-Else If , else if , else if ladders)
  • Iterations OR Loops In PL/SQL(Simple, for, while)
  • Using SQL With PL/SQL(Data Retrieval Standards- %Type, %Rowtype)
  • Cursors(Implicit, Explicit)
  • Cursor Loops(Simple, For)
  • Working With Exceptions In PL/SQL(Predefined, non-predefined, user defined)
  • Working With Triggers and Advantages(before, after)
  • Sub programs and features
  • Procedures & parameters(in, out, in-out) and calling through sub programs
  • Functions and execution and calling through sub programs
  • Packages , package specification, package body specification
Hurry Up !!! NEW Batches getting started .... FLAT 20% DISCOUNT!!! for the first five registrations ... Upto 10% Discount for the next five registrations ...Hurry Up !!!

About Us

Staying one step ahead in providing the latest Information in Technology Education and sustain quality in academic delivery. Make the institution student friendly and deliver service to the society.
- Vision Networks -

Contact Us

Vision Networks

2nd Floor, Manikanta Crown, Beside Kalanikethan, Chaitanyapuri Main Rd, Kamala Nagar, Dilsukhnagar, Hyderabad, Telangana 500060.
Ph : 9247278885, 66758885, 9949954818.

copyright @ Vision Networks 2015

>