PL/SQL Training and Certification Course In Pune

SQL /PL SQL
Duration of course: 40 hrs

Best Blended Syllabus for PL/SQL Training in Pune by a 100% Placement-Oriented Training Institute

Instructor-led PL/SQL Live Online Interactive Training

Date Upcoming Batch Schedule
(Weekdays/Weekends)
Batch Timings Mode of Learning
26th Jun
Saturday-Sunday
26th Jun
Online/Classroom
Content
Content
Content
Content
Content
Content
Content
Content
Content
Content
Content
Content

Don't Wait for IT!

Let's Build a Great Career in IT!

Our Candidate's Placement Record!

Book Your Seat Now ! At just ₹2000!

No Cost Two Easy Installments!

PL/SQL Training Course​

Best Blended Syllabus for PL/SQL Training in Pune by a 100% Placement-Oriented Training Institute

  • Course Agenda
  • Course HR Data set
  • PLSQL Environment
  • Benefits and Block structure
  • Create & Execute Anonymous Block
  • Test output of PLSQL Block. Practice Overview

Download Curriculum

  • Use of Variables
  • Identifier
  • Handling Variable in PLSQL
  • Declaration & Initialization of PLSQL variable
  • Type of Variable
  • Guideline for Declaration & Initialization PLSQL Variables
  • Scalar Data Type
  • Bind Variables
  • Substitution Variables
  • Composite and LOB Data Type Variables. Practice Overview

Download Curriculum

  • Lexical Unit of PLSQL Block
  • Commenting Code
  • Usage of SQL Function in PLSQL
  • Nested Block
  • Variable Scope & Visibility
  • Operator in PLSQL
  • Indenting PLSQL Code
  • Practice Overview

Download Curriculum

  • SQL Statement in PLSQL
  • Naming Convention
  • Manipulating Data using PLSQL
  • Inserting
  • Updating
  • Deleting & Merging Data in PLSQL
  • SQL Cursor & Attribute.
  • Practice Overview

Download Curriculum

  • Controlling Flow of Execution
  • IF statement
  • IF THEN ELSE Statement
  • IF ELSIF ELSE clause
  • NULL values in IF Statements
  • Case Expression
  • Loop statements
  • BASIC Loop
  • WHILE Loop
  • FOR Loop
  • Guidance while using loop
  • Nested Loop and Labels
  • Practice Overview

Download Curriculum

  • Composite Data Type
  • PLSQL Records
  • PLSQL Records Structure
  • The %ROWTYPE Attribute
  • Advantages of %ROWTYPE & Sample Program using Record %ROWTYPE
  • Practice Overview

Download Curriculum

  • About Cursors
  • Explicit cursor operations
  • Curosr Life Cycle
  • Cursor & Records
  • Cursor FOR loop
  • Explicit Cursor Attributes
  • Usage of FOR UPDATE & WHERE CURRENT OF Clause
  • Cursor with Sub-Queries
  • Practice overview

Download Curriculum

  • Handling Exception using PLSQL
  • Exception Types
  • Trapping Exceptions
  • Guidelines for Trapping Exception
  • Trapping Predefined & Non Predefined Oracle Server Errors
  • Function of Trapping Exception
  • Propagate Exception in Sub-Block
  • RAISE_APPLICATION_ERROR Procedure
  • Practice Overview

Download Curriculum

  • Stored Procedure & Function
  • Difference between Anonymous Block and Sub-programs
  • Procedure Syntax
  • Example
  • Execution
  • Function Syntax
  • Example
  • Execution
  • Passing  Parameter to Function etc
  • Practice Overview

Download Curriculum

  • Developing Procedure
  • What are parameters? Formal & Actual Parameters
  • Procedural Parameter Modes
  • Example of IN
  • OUT
  • IN OUT parameter passing modes
  • Invoking Procedure
  • Handle Exception
  • Remove Procedure
  • Viewing Procedure in the Data Dictionary
  • Benefit of Subprograms
  • Practice Overview

Download Curriculum

  • Developing Function
  • Way to execute Function
  • Advantages of User Defined Function in SQL statements
  • Function in SQL Expression
  • Location to Call User Defined Function
  • Restriction on Calling from SQL Expressions
  • Controlling side effect Calling Functions from SQL Expression
  • Remove Function
  • Viewing Function in the Data Dictionary
  • Procedure Versus Function
  • Practice Overview

Download Curriculum

  • Why Collection? Oracle Collection
  • Associative Array
  • Varray
  • Nested Table
  • Scenario for Collection When to use What
  • Ref Cursors
  • Type Ref Cursors
  • Advantage/Disadvantage of Ref Cursor
  • Practice overview

Download Curriculum

  • PLSQL Package
  • Component of PLSQL Package
  • Visibility of Package Component
  • Developing PLSQL Package
  • Creating Package Specification & Package Body
  • Invoking Package Subprograms
  • Creating & Using Bodiless Package
  • Removing Package
  • Viewing Package in the Data Dictionary
  • Guideline to writing Package
  • Advantage of Using Package
  • Practice overview

Download Curriculum

  • Overloading Subprograms
  • Overloading the Standard Package
  • Use of Forward Declaration
  • Package Initialization Block
  • Use Package Function in SQL & Restriction
  • Persistent State of Package/Variables
  • Package using Collection
  • Wrapper Utility
  • Guideline for Wrapping
  • Practice Overview

Download Curriculum

  • Standardizing Constant & Exception
  • Exception Handling
  • Local Subprograms
  • Definer’s Rights Versus Invoker’s Right
  • Features of Autonomous Transaction
  • Bulk Binding
  • Bulk Binding FOR ALL Example
  • Using BULK COLLECT INTO with Queries/Cursors
  • Practice Overview

Download Curriculum

  • Type of Triggers
  • Guidelines of Designing Triggers
  • Creating DML Trigger
  • Type of DML Triggers
  • Trigger Timing
  • Trigger Firing Sequences
  • DML Statement Triggers
  • Using Conditional Predicates
  • DML ROW Trigger
  • Old
  • New Qualifier
  • Restricting Row Trigger
  • Implementing Integrity Constraint with a Trigger
  • Comparison of Database Triggers and Stored Procedure
  • Comparison of DB Trigger and Oracle Forms Triggers
  • Managing
  • Removing
  • Testing Trigger
  • Practice Overview

Download Curriculum

  • Creating Database Triggers
  • Creating Triggers on DDL Statements
  • Creating Triggers on System Events
  • LOGON
  • LOGOFF Triggers Examples
  • CALL Statements
  • Reading Data From a Mutating Table
  • Benefit of DB Triggers
  • Business Application Scenario for Implementing Triggers
  • Viewing Triggers in Data Dictionary using USER_TRIGGERS
  • Practice Overview

Download Curriculum

  • It covers real time project scenario including all deliver conceptual session based on Database 10g/11g
  • It includes Data Import
  • Validation
  • Audit Trail
  • Performance based Program etc.

Download Curriculum

PL/SQL Training Completion Certificate

To Obtain The PL/SQL Course Completion Certification,You Have To Fulfill The Following Criteria

  • Complete the PL/SQL Course Online/Classroom Training
  • You can attend multiple batches of the same trainer & complete the PL/SQL Course Training
  • Completion of all exercises, assignments & capstone project.
150+

Batches Completed

Industry Oriented Syllabus

Designed By Expert

2000+

Happy Students

Self Assessments

Quizzes, POC

8+

8+ Years Of Experience

Recorded Sessions

1 Year Of Access

PL/SQL Training Completion Certificate

GET CERTIFIED ON COURSE COMPLETION

Course Benefits​

  • No prerequisite
  • Course designed for non-IT as well as IT professionals

  • Flexible batch switch is available

  • Placement assistance in MNC

  • Classroom & Online Training – Can switch from online training to classroom training with nominal fee

  • Working professional as instructor

  • Proof of concept (POC) to demonstrate or self-evaluate the concept or theory taught by the instructor

  • 100% placement calls guaranteed till you get placed

  • Interview Preparation Support

  • Resume Building & Mock Interview

  • Evaluation after each Topic completion

  • Hands-on Experience with Real-Time Projects

STAY TUNED WITH US

Let's begin a dialogue with our career concealer!

About Course

Training Projects​

FAQ

Yes, you can attend demo session before you enroll either we can provide you the recorded lecture so that you can watch it as per your schedule or you can attend live demo lecture either online or offline

 

Yes, we do provide the placement assistance in which how we work on real time projects will be taught,resume preparation and Job openings will also be provided.More than 80% of candidates have changed their profile by getting either promotion or getting new job offers on good package.

Checkout our Telegram Channel for Placement Assistance (Open in Mobile Browser): https://t.me/technogeekssolutions

 

If you miss classes, you can get recording sessions of the lectures.

Testimonial Review​

CONTACT US TO DISCUSS HOW WE CAN HELP YOU.

Our candidates are working with