PL SQL Developer Career Facts
PL SQL Pre-requisites
Basic Computer Knowledge.
Jobs On PL SQL
Top IT MNC such as Capgemini, Cognizant, IBM, Infosys, Accenture, etc.,
PL SQL Developer Salary
The average salary for a PL SQL Developer with 4 years experience in India is ₹8,43,568.
PL SQL Course Outline:
- Introduction to Programming Languages
- Introduction to PL/SQL
- The Advantages of PL/SQL
- PL/SQL Architecture
- PL/SQL Data types
- Variable and Constants
- Using Built_in Functions
- Conditional and Unconditional Statements
- Simple if, if… else, nested if..else, if..else Ladder
- Selection Case, Simple Case, GOTO Label and EXIT
- Iterations in PL/SQL
- STORED PROCEDURES
- PROCEDURE with Parameters (IN, OUT and IN OUT)
- POSITIONAL Notation and NAMED Notation
- Procedure with Cursors
- Dropping a Procedure
- Creating PACKAGE Specification and PACKAGE Body
- Private and Public Objects in PACKAGE
- User Defined Exceptions
- Pre Defined Exceptions
- RAISE_APPLICATION_ERROR
- PRAGMA_AUTONOMOUS_TRANSACTION
- SQL Error Code Values
- Types of Triggers
- Row Level Triggers
- Statement Level Triggers
- DDL Triggers