CiiT Makes technology simple
Central Institute of Information Technology
Plot No.2, Near Jerryl Lawns, RPTS Road, Opp. Momentum Classes, Laxminagar, Nagpur - 440022
Email: ciit_nagpur@yahoo.com        Mobile: 9011501192
|    Home      |    Our Courses     |    Projects     |    Tips/Faq     |    Interview Questions     |    Jobs     |    About Us     |    Contact Us   |

Join Pl/Sql Classes in Nagpur at CiiT

Oracle Pl/Sql Course -  Learn PL/SQL from basic to an expert level

Job-Oriented Course with Comprehensive Syllabus at an Affordable Fee - 100% Placement Assistance

   PL/SQL is mixture of SQL statements with procedural constructs/language. Pl/Sql is used in software development by programmers to build/impliment business logic. Without PL/SQL, Oracle can execute single SQL statements at a time. Pl/Sql programs can be compiled once and stored in executable form to improve execution/response time. Pl/Sql programs reduces network traffic between the app/client and the database. Pl/Sql programs are very secure. PlSql support Object-Oriented Programming. PL/SQL supports both static and dynamic SQL. Learning PL/SQL can significantly boost your career in IT industry.

PL/SQL Course PreRequisite : This course is designed such that anyone or beginners willing to learn PL/SQL can take it. But Sql Knowledge is must. So first step is to learn SQL and then proceed to Pl/Sql.

PL/SQL Course Duration : 20 Days                      Sql Course

Oracle PL/SQL (Procedural Language extensions to SQL) Syllabus

  • Introduction TO PLSQL
  • PLSQL block Structure/Architecture
  • Data Types
  • Declaring Variables(Assignment, Default, Not Null, %Type, %Rowtype, Aggregate, Aliases, Scope)
  • Datatype Conversion (Implicit and Explicit)
  • Control Structures
  • Conditional Control Statements
    If ...Then
    If ...Then ...Else
    If ...Then ...ElsIf
  • Iterative Statements
    For(...Range...)Loop .. End Loop
    While(...condition...)Loop ... End Loop
    Loop ... End Loop --Explicite Exit Statement
  • Exit Statement
  • GoTo Statement
  • Null Statement
  • Into Statement
  • Implicit Cursors (Dml/Select Into)
  •   Attributes(SQL%Found, SQL%NotFound, SQL%RowCounts, SQL%IsOpen)
  • Explicit Cursors
  •   Declare,Open,Fetch,Close,Use with For,While,Loop Iterative Statements
  •   Parameter passing,Attributes(C%Found,C%NotFound,C%RowCounts,C%IsOpen)
  •   Value of attributes at different conditions.
  • Reference Cursor / Cursor Variables
  • Row Locking : For Update (/NoWait/Of ColumnName) Clause
  • Table Locking:Lock Table
  • Dynamic DDL statement in PLSQL using DBMS_SQL Oracle Package.
  • Exceptions Handling
  • Sub-Programs (Procedures and Functions)
  • Stored Programs (Procedures and Functions)
  • Database Triggers
  • Collections
  • Records
  • Object Types
  • Stored Procedures
  • Stored Functions
  • Packages
  • Oracle Supplied Packages
  • Manipulating Large Objects
  • Database triggers : Statement Level and Row Level triggers
  • Managing Dependencies
Basic PL/SQL Syntax :
    Declare 
       --declarations section
    Begin 
       --executable commands
    Exception
       --exception handling
    End;
    
    eg.
    Declare 
       var varchar(15);
    Begin 
       var := 'Hello World!';
        Dbms_Output.Put_Line( var );
    Exception
       When Others  Then
        Dbms_Output.Put_Line( 'Default Exception Handled' );
    End;


Central Institute of Information Technology - 2009