ORACLE PL/SQL TRAINING

Loops and Reverse of LOOP Statements
Labeling a PL/SQL Loop and The Loop Control Statements
Syntax: The EXIT WHEN Statement.
Syntax: Restrictions with GOTO Statement

Parts of a PL/SQL Subprogram
Creating a Procedure, Executing and Deleting a Standalone Procedure
Parameter Modes in PL/SQL Subprograms
IN & OUT Mode Example 1 and IN & OUT Mode Example 2
Methods for Passing Parameters are POSITIONA, NAMED and MIXED NOTATION

Calling a Function and PL/SQL Recursive Functions
Cursors, Implicit and Explicit Cursors
Declaring, Opening, Fetching and Closing the Cursor
Defining a Record
Table-Based, Cursor-Based and User-Defined Records
Accessing Fields and Records as Subprogram Parameters

Syntax for Exception Handling
Raising, User-defined and Pre-defined Exceptions
Creating Triggers and Benefits of Triggers
Triggering a Trigger

Package Specification, Package Body
Using the Package Elements:
THE PACKAGE SPECIFICATION
CREATING THE PACKAGE BODY
USING THE PACKAGE
Index-By Table and Nested Tables
Collection Methods and Exceptions

Starting and Ending a Transaction, Committing and Rolling Back Transactions
Save points, Automatic Transaction Control
Date & Time
Field Values for Date time and Interval Data Types
The Date time Data Types and Functions
The Interval Data Types and Functions
DBMS Output and DBMS_OUTPUT Subprograms
Object Oriented and Instantiating an Object
Member Methods, Using Map method and Using Order method
Inheritance for PL/SQL Objects and Abstract Objects in PL/SQL

Our trainers are Highly experienced in Oracle PL/SQL implementing real-time solutions on different Scenarios and Expert in their professionals.

We record each LIVE class session you undergo through this training and we will share the recordings of each session/class.

Trainer will Provide Detailed installation of required software through LMS to the students we support by providing Training and practical in real time experience with all utilities required for completely understanding of this Training.

Yes, there are some group discount are available only if group contain more than 2 Or more participates.

Basic Hard ware requirement is useful to install the Product

We provide Training in a Real Time Projects Oriented

Yes we will Schedule a Demo Session as per the student convenient by sharing LIVE Online Streaming access either through GoToMeeting or WebEx.

If you are enrolled in classes and you have paid fees, but want to cancel the registration for certain reason, it can be done within 48 hours of initial registration. Please make a note that refunds will be processed within 15 days of prior request

As we are one of the Best Oracle PL/SQL Online Training Provider we have customer throughout the world wide specially from UK, USA, UAE, Australia, Qatar, Singapore, New Zealand, India, Malaysia, Dubai, Doha, Melbourne, Brisbane, Perth, Wellington, Auckland Middle East Countries and other parts of the world

We are also located in USA Offering Oracle PL/SQL Online Training in Cities like New York, New jersey, Dallas, Seattle, Baltimore, Tempe, Chandler, Scottsdale, Peoria, Honolulu, Columbus, Raleigh, Nashville, Plano, Toronto, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Houston, Minneapolis, Los Angeles, San Francisco, San Jose, San Diego, Washington DC, Chicago, Philadelphia, St. Louis, Edison, Jacksonville, Towson, Salt Lake City, Davidson, Murfreesboro, Atlanta, Alexandria, Sunnyvale, Santa Clara, Carlsbad, San Marcos, Franklin, Tacoma, California, Bellevue, Austin, Charlotte, Garland, Raleigh-Cary, Boston, Orlando, Fort Lauderdale, Miami, Gilbert.

In Indian we have customer from Bangalore, Mysore, Hyderabad (Ameerpet), Visage, Chennai, Kolkata, Pune, Mumbai, Delhi, Jaipur, Ahmadabad, Kerala etc…

You can clarify your queries by dialing +91 - 82 9696 0414, +1 (646) 586 - 2969 Or you can send a mail to info@gologica.com. We are ready to clear your enquiries at any time