Demos On 12th / 13th August
PIMPLE SAUDAGAR :     AWS - Amazon Web Services (09:00 AM)   |   DevOps (10:30 AM)   |   Selenium (02:00 PM)   |   UI / PHP (02:00 PM)   |   Angular JS (02:00 PM)       DECCAN :    Core Java (11:00 AM)   |   Java for Selenium (11:00 AM)   |   UI Development (11:00 AM)   |   PHP (02:00 PM)   |   
ISO 9001:2015 Certified Organization  |  Pearson Exam Center

Oracle : PL/SQL

Overview

Duration : (40 Hours)

Prerequisites : Knowledge of SQL

Training Highlights : Students learn to create anonymous PL/SQL blocks as well as stored procedures and functions. Student learn to write powerful PL/SQL programs such asprocedures, packages, functions & triggers. Best trainers having Industry experience in current technology. We assist in OCA Certification and provides Interview tips.

Course Syllabus

Oracle : PL/SQL
  1. PL/SQL Structure
    • Variables
    • Data type
  2. Creating the Executable Section
    • Comments6
    • Literals
    • Operator
    • Output Statement
    • Accepting input from user
    • Variable scope
    • Function
    • Programs using SQL Statements in PL/SQL
  3. Writing Control Structures
    • If statement in PL/SQL
    • If…else statement in PL/SQL
    • Else if ladder statement in PL/SQL
    • LOOPs in PL/SQL
  4. Working with Composite Data Types
    • PL/SQL Records
    • Collections
  5. Cursors
    • PL/SQL Attributes Cursor Attributes
    • Using cursor with for …loop
  6. Exception Handling
    • What is an Exception?
    • How to handle Exception?
    • Predefined Exception
    • Get information about error with – SQLCODE and SQLERRM
    • Non Predefined Error
    • User Defined Exception
  7. Stored Procedures
    • Advantages of procedures
    • Creating procedure
    • Formal and actual parameters in procedure
    • Using Anonymous block to invoke a procedure
    • Default option for parameters
    • Using Sub Procedures
    • Calling procedure from another procedure
    • Handled and Unhandled Exception when procedure called
    • Delete procedure
  8. Functions
    • Advantages of Functions
    • Calling function in SQL statement
    • Restriction on calling function in SQL statement
    • Deleting a Function
    • Difference between function and procedure
  9. Packages
    • Advantages of packages
    • Package Structure
    • Executing the procedure and function
    • Removing package
  10. Triggers
    • Creating a trigger
    • Accessing a column using row trigger
    • Using Statement trigger
    • Modifying a Trigger
    • Enabling and Disabling a trigger
    • Dropping a trigger
  11. Oracle Architecture- Complimentary Session

Inquire Now

Student’s Reviews about 3RI