Introduction

  • SQL vs. PL/SQL
  • A Few Simple Examples
  • Saving Procedures
  • A More Complete Picture
  • Comments
  • Variable Substitution
  • Simple Exception Handling
  • Advantages of PL/SQL
  • Assignments

 Declarations and Data Types

  • Declarations
  • Standard Data Types
  • Initialization
  • Variable Names
  • Specialized Data Types – %TYPE
  • Specialized Data Types – %ROWTYPE
  • Building Your Own Data Types – Records
  • A Quick look at Loops
  • Arrays
  • Tables
  • Nested Blocks

Language Components

  • Introduction
  • Assignments
  • Decision Making Statements
  • Simple Loops
  • Loops – for
  • Loops – indefinite
  • Loops – while
  • Simple Loops
  • Nested Loops
  • Boolean Variables
  • PL/SQL Relational Operators
  • PL/SQL Logical Operators

 Cursors

  • Introduction
  • Cursor Manipulation
  • Using the Cursor
  • For Loops Cursors
  • Cursor Attributes
  • Cursor Parameters
  • Nested Cursors
  • Cursor Exceptions

 Exceptions

  • Errors In Programs
  • Run Time Exceptions
  • Oracle Built In Exceptions
  • Unnamed Exceptions
  • Built in Exception Functions
  • Creating Your Own Exceptions
  • Building Non Terminating Exceptions

 Functions and Procedures

  • Introduction
  • Creating a Procedure
  • Example Procedure
  • Using Parameters
  • Functions
  • Procedures and Exceptions

STUDENT BENEFITS

  • Job Assistance
  • Pay Fees in Installments / EMI
  • Technical Support after Course Completion
  • Back up Classes Available
  • Attend Demo class
  • Course Complete Certificate
  •  Lab Facility
  • Real Time Project

ADDITIONAL HIGHLIGHTS

  • Total 60  hours Class
  • 1 on 1 Trining
  •  You Get In-Depth Practical Knowledge on each Topic
  • Free Study E-Material, PDFs, Video Trainings
  • Flexible Timimg
  •  Online Trainings provided

For More Information: Call us on +917411000877

Contact us on +917411000877