Demo Session

img_f40438ad2972747830de32eda2d2facf_1503071060585_original

____________________________________________________________________________

ORACLE

PLSQL

Get Updates on Demo session,Syllabus and timings by filling up this form

Your Name (required)

Your Email (required)

Mobile number(Prefix "+91-")

Branch

Course

 

 

 

    1 on 1 sessions

 


    Free cloud access

 


    24*7 call support

 

Course Features

 

 

    VM for practice

 


    Free cloud storage

 


    IZO 147

 

 

 

 

    Video Lectures

 


    Complete modules

 


    Multiple batches

 

Our Courses


Syllabus


Data Types & Structures

  • pl/sql introduction

  • basics of pl/sql

  • datatypes & error handling

  • pl/sql wrapper utility

  • control structures

  • pl/sql records

 

Exception handling

  • Error checking & exception handling

  • Using the when others clause

  • Ensuring complete error checking

  • Passing error messages to calling routine

  • Understand Exceptions

  • Handle Exceptions with PL/SQL

  • Trap Predefined Oracle Server Errors

  • Trap Non-Predefined Oracle Server Errors

  • Trap User-Defined Exceptions

  • Propagate Exceptions

  • RAISE_APPLICATION_ERROR Procedure

 

Conditional Statements

  • conditional processing using if statements

  • conditional processing case statements

  • handle nulls to avoid common mistakes

  • build boolean conditions with logical operators

  • use iterative control with looping statements

  • constructing & identifying loop statements

  • block flow using loops and labels.

 

Procedures , Functions

  • basics of stored procedures.

  • basics of functions and packages.

  • defining stored procedures and functions.

  • functions & stored procedures prototypes.

  • passing arguments to functions & procedures.

  • Pinning packages in the SGA.

  • listing package information.

  • flexibility of cursors by using parameters.

  • procedures parameters and parameters modes.

 

Data Retrieval

  • Retrieving data.

  • Retrieve data using sql statements.

 

Cursors , Triggers

  • using cursor attributes

  • triggers & database events

  • define a trigger

  • timing a trigger

  • enabling & disabling a trigger

  • bulk queries

  • bulk dml

  • analyzing impact of bulk operations

 

New Batches

Demo Session New Batch Location
2-June-2018 11 A.M. 3-June-2018 5 P.M. Pimple Saudagar
2-June-2018 2 P.M. 3-June-2018 2 P.M. Nal Stop
2-June-2018 2 P.M. 3-June-2018 2 P.M. Kharadi
26-May-2018 2 P.M. 27-May-2018 2 P.M. Pimple Saudagar
26-May-2018 2 P.M. 27-May-2018 2 P.M. Nal Stop
26-May-2018 2 P.M. 27-May-2018 2 P.M. Kharadi

CLICK HERE TO PAY REGISTRATION FEES ONLINE

Gallery

More

FAQs For PL/SQL

We will provide you complete support for java and linux.

We have designed our syllabus in such a way that it fits the suitability for CloudEra certified developer certification.

We have multiple batches running simultaneously, so if u misses a lecture u can attend it in next lecture.

We have designed our syllabus in such a way that it fits the suitability for HortonWorks certified developer certification.

Yes, we have multiple centers.

Your profile would be evaluated by experts, your resume would be rated and you would start getting calls after completion of your module.

 

PL/SQL Training In Pune

The PL/SQL language is an extension of SQL language developed by Oracle Corporation and the full name it is the Procedural Language/Structured Query Language. The PL/SQL language is a procedural programming language which allows data manipulation and sql query to be included in blocks. PL/SQL can be used to group multiple instructions in a single block and sending the entire block to the server in a single call. When the PL/SQL engine is located on the client, as it is in the Oracle Developer Tools, the PL/SQL processing is done on the client side. All SQL statements that are embedded within the PL/SQL block are sent to the Oracle server for further processing. When PL/SQL block contains no SQL statement, the entire block is executed on the client side. The vast majority of database programmers on this planet write PL/SQL. PL/SQL knowledge is a key skill for all developers working with Oracle databases
PLSQL is actually the number one database. The demand in market is growing equally with the value of the database. It has become necessary for the PLSQL certification to get the right job. Etlhive is one of the renowned institutes for PLSQL in Pune. We believe in fulfilling the skill set demand of the market. It is necessary to become knowledgeable in PLSQL to get a proper professional career. We start with the scratching competency of our clients and we end up with the intellectual understanding of the technical words. Client’s satisfaction is our foremost objective. We create the PL/SQL experts who are of valuable resource that can do a lot more on their own with the right tools.
top
ETLHIVE is a Trademark of Itelligence Infotech Pvt Ltd.   *PMP®, PMBOK, PMI, PgMP, CAPM, PMI-RMP, and PMI-ACP are registered trademarks of the Project Management Institute, Inc. *ITIL®, IT Infrastructure Library, Swirl Logo, Prince2 are registered trademarks of AXELOS Limited.
19th May - Demo Session - P.Saudagar - Hadoop : 10.00 am | Python : 2.00 pm | Informatica : 10.00 am | Data Science : 2.00 pm | Devops : 2 pm | AWS : 3 pm | Selenium : 12 pm | Digital Marketing : 10.00 am | Angular JS : 4 pm | Tableau : 1 pm | NAL Stop - Hadoop : 3.30 pm | AngularJS : 12 pm | Informatica : 4.00 pm | Selenium : 12 pm | Kharadi - Data Science : 9.00 am | Hadoop : 9.00 am | Tableau : 2.00 pm |Selenium : 9.00 am | Informatica : 5 pm | Python : 12.30 pm