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

Apply for Certification

https://www.vskills.in/certification/Certified-PL-SQL-Developer