Learning Resources
 

 

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

Apply for Certification

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