Why should I take this certification?

PL/SQL is Procedural Language extension of SQL. A PL/SQL program can have both SQL & procedural statements. In the PL/SQL program the SQL statements are used to access sets of data stored in a database, while the procedural statements are used to process individual piece of data & control the program flow.

This certification will teach you programming in Oracle PL/SQL.

How will I benefit from this certification?

Mastering PL/SQL gives you a very lucrative skill. Oracle and SQL It is the only language used to build business logic within an oracle database. Jobs in PL/SQL are many and highly paid. Knowing PL/SQL could double your income if you are already an SQL developer.

Companies that hire PL/SQL Developers

HCL, Tech Mahindra, Sify Ltd., TCS, Cognizant

Companies that hire PL/SQL Developer

PL/SQL Developer professionals are in great demand and companies in India looking for oracle database application development are hiring them.

Apply for PL/SQL Developer Certification

By Net banking / Credit Card/Debit Card

We accept Visa/Master/Amex cards and all Indian Banks Debit Cards. There is no need to fill application form in case you are paying online.

Please click buy now to proceed for online payments.

  • Visa Card
  • Master Card
  • American Express

 

Buy Now
TABLE OF CONTENT

PL/SQL Introduction
  • Relational database, oracle and PL/SQL
  • PL/SQL need and benefits
Configuration
  • Hardware and software pre-requisites
  • Oracle environment configure and test
PL/SQL programming constructs
  • Lexical elements and basic data types
  • Constants, variables, operators and expressions
  • Conditional and loop construct
  • Overloading and recursion
Code Block
  • Procedure and functions
  • Packages, INSTEAD OF and triggers
  • Compilation errors
  • Exception handling and custom exception
Cursors
  • Declaration and defining
  • Implicit cursors
  • Cursor variables, using PL/SQL functions, record updates and shortcuts
Code Management
  • Packaging and placement of code and triggers in database
  • Code placement in application server
  • Naming standard basics, need and norms
Advanced Datatypes
  • Clob, blob and bfile
  • Custom data types
  • Varray and bulk collect
Transaction Processing
  • Commit and rollback
  • Autonomous transactions
 
COURSE OUTLINE

 


PL/SQL Introduction
  • Understanding basics and terminologies of relational database, oracle and PL/SQL
  • Explaining the usage of PL/SQL in oracle DBMS
  • Describing the need and benefits of PL/SQL for triggers and server-side code
Configuration
  • Detailing the hardware and software requirements for Oracle and PL/SQL
  • Describing the steps for configuring and testing oracle environment and connectivity
PL/SQL programming constructs
  • Illustrating the various lexical elements and basic data types in PL/SQL
  • Describing the concepts of constants, variables, operators and expressions
  • Explaining the various conditional and loop constructs offered by PL/SQL
  • Understanding the usage of overloading and recursion
Code Block
  • Detailing concepts of procedure, functions, packages, instead of and triggers
  • Explaining techniques for handling compilation errors and exception with adding custom exception
Cursors
  • Describing the steps for declaration and definition of cursors
  • Detailing usage of implicit cursors
  • Understanding the usage of cursor variables, PL/SQL functions, record updates and Shortcuts in PL/SQL
Code Management
  • Explaining the steps for packaging and placement of code and triggers in database
  • Illustrating the process, advantages and disadvantages of code placement in application server
  • Detailing the basics of naming standard, it’s need and norms to follow
Advanced Datatypes
  • Understanding usage of clob, blob and bfile data types
  • Detailing the implementation of custom data types
  • Explaining varray and bulk collect for bulk data operations
Transaction Processing
  • Describing the concepts and usage of commit and rollback of transactions in PL/SQL
  • Explaining the autonomous transactions
“Exam scheduling to be done through user account” / “Exam once scheduled cannot be cancelled”
Date of Examination
05-Nov-2017
18-Nov-2017
02-Dec-2017
03-Dec-2017
16-Dec-2017
17-Dec-2017
06-Jan-2018
07-Jan-2018
20-Jan-2018
21-Jan-2018
03-Feb-2018
04-Feb-2018
17-Feb-2018
18-Feb-2018
03-Mar-2018
04-Mar-2018
17-Mar-2018
18-Mar-2018
Examination Time
01:00 PM - 02:00 PM
02:30 PM - 03:30 PM
04:00 PM - 05:00 PM
05:30 PM - 06:30 PM
10:00 AM - 11:00 AM
11:30 AM - 12:30 PM

Write a review


Your Name


Your Review Note: HTML is not translated!

Rating Bad           Good

Captcha

Write a review

Note: HTML is not translated!
    Bad           Good


Captcha

Tags: Pl/SQL Certification, Pl SQL Certification Exam, SQL, Pl SQL, Pl/SQL, Oracle, Oracle Database, Database, Data Storage, Database Administration, Data Structure, Oracle, Database Management, Information Technology, Data Analyst Skills, Data Scientist Skills, Computer Science, Computer Science Engineering, Computer Science Engineer, MySQL Db, Oracle Db, Oracle Programming, Trigger