Oracle PL/SQL Training in Pune & Best Oracle PL SQL Training Institute in Pune

Oracle PL-SQL Course Contents

Basics of PL/SQL:

• PL/SQL architecture
• PL/SQL and SQL*Plus
• PL/SQL Basics, Variables, Constants, data types & error handling
• PL/SQL wrapper utility

PL/SQL structures:

• Simple blocks
• Control structures
• PL/SQL records
• Recognizing the Basic PL/SQL Block and Its Sections
• Describing the Significance of Variables in PL/SQL
• Distinguishing Between PL/SQL and Non-PL/SQL Variables
• Declaring Variables and Constants
• Executing a PL/SQL Block

Error checking ? exception handling:

• Defining exceptions
• Using the when others clause
• Ensuring complete error checking
• Passing error messages to calling routine

Boolean logic in PL/SQL:

• Identifying the Uses and Types of Control Structures
• Constructing an IF Statement
• Constructing and Identifying Different Loop Statements
• Controlling Block Flow Using Nested Loops and Labels
• Using Logic Tables
• If-then-else structure
• Testing for numbers characters and Booleans

Cursors in PL/SQL:

• Cursor basics
• Using a cursor for a multi-row SQL query

Iteration in PL/SQL:

• For loop
• While loop

PL/SQL tables:

• Defining PL/SQL tables
• Reasons to use PL/SQL tables
• Populating a PL/SQL table
• Retrieving from a PL/SQL table

Dynamic SQL in PL/SQL:

• Introduction to the dbms_sql package
• Creating a dynamic SQL statement

Nested blocks in PL/SQL:

• Introduction to the dbms_sql package
• Creating a dynamic SQL statement

Triggers in PL/SQL:

• Triggers and database events
• Defining a trigger
• Timing a trigger
• Enabling and disabling a trigger

Stored procedures, functions and packages:

• Basics of stored procedures
• Basics of functions
• Basics of packages
• Defining stored procedures & functions
• Function and stored procedures prototypes
• Passing arguments to functions and stored procedures
• Recompiling functions and stored procedures
• Pinning packages in the SGA with dbms_shared_pool.keep
• Package forward declaration
• Package dependency
• Package overloading
• Listing package information

Bulking in PL/SQL:

• Bulk queries
• Bulk DML (forall statement)
• Using cursor attributes
• Analyzing impact of bulk operations

Oracle PL/SQL training duration in Pune

Regular Classes( Morning, Day time & Evening)

• Duration : 4 weeks

Weekend Training Classes( Saturday, Sunday & Holidays)

• Duration : 5 Weeks

Fast Track Training Program( 2+ hours classes daily)

• Duration : within 2 weeks

Oracle PL/SQL trainer Profile & Placement

Our Oracle PL/SQL Trainers

• More than 8 Years of experience in Oracle PL/SQL Technologies
• Has worked on 8 realtime Oracle PL/SQL projects
• Working in a MNC company in Pune
• Trained 110+ Students so far.
• Strong Theoretical & Practical Knowledge
• Oracle PL/SQL certified Professionals

Oracle PL/SQL (oracle plsql) Placement Training in Pune

• More than 110+ students Trained
• 82 percent Placement Record
• 68 Interviews Organized
• Placement Supported by InterviewDesk.com

Oracle PL/SQL training Locations in Pune

Our Oracle PL SQL Training centers

• Aundh
• Baner Road
• Camp
• Chinchwad
• Deccan Gymkhana
• Karve Road
• Kothrud
• NIBM ROAD
• Pimpri Colony
• Sadashiv Peth
• Shivaji Nagar
• Yerwada

Oracle PL/SQL training batch size in Pune

Regular Batch ( Morning, Day time & Evening)

• Seats Available : 5 (maximum)

Weekend Training Batch( Saturday, Sunday & Holidays)

• Seats Available : 4 (maximum)

Fast Track batch

• Seats Available : 3 (maximum)

Oracle PL/SQL related training courses

• Oracle Training in Pune with placement support
• Oracle DBA Training in Pune with placement support
• Oracle Forms & Reports Training in Pune with placement support
• Oracle Performance Tunning Training in Pune with placement support
• Oracle Certification Training in Pune with placement support
• Oracle RAC Training in Pune with placement support
• Oracle ADF Training in Pune with placement support