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

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 Mumbai

Regular Classes( Morning, Day time & Evening)

• Duration : 6 weeks

Weekend Training Classes( Saturday, Sunday & Holidays)

• Duration : 7 Weeks

Fast Track Training Program( 4+ hours classes daily)

• Duration : within 4 weeks

Oracle PL/SQL trainer Profile & Placement

Our Oracle PL/SQL Trainers

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

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

• More than 4030+ students Trained
• 3002 students Placed
• 1902 Interviews Organized
• Placement Supported by InterviewDesk.com

Oracle PL/SQL training Locations in Mumbai

Our Oracle PL SQL Training centers

• Airoli
• Ambarnath
• Andheri East
• Anita Nagar
• Badlapur
• Bandra West
• Bhandup West
• Bhiwandi
• Bhiwandi
• Boreivali
• Chembur
• Dadar
• Dombivli
• Fort
• Ghansoli
• Goregaon East
• kalamboli
• Kalbadevi
• Kalwa
• Kalyan
• Kandivali West
• Mahim
• Malad West
• Mulund West
• Mumbra
• Navi Mumbai
• Parel
• Pnavel
• Sanpada
• Santhosh Nagar
• Taloje
• Thane West
• Ulhasnagar
• Vashi

Oracle PL/SQL training batch size (students per class) in Mumbai

Regular Batch ( Morning, Day time & Evening)

• Seats Available : 5 (maximum)

Weekend Training Batch( Saturday, Sunday & Holidays)

• Seats Available : 9 (maximum)

Fast Track batch

• Seats Available : 3 (maximum)

Upcmoing Oracle PL SQL Training Classes in Mumbai