Courses

Oracle PL SQL Developer

Oracle PL SQL Developer

PL/SQL stands for Procedural Language/Structured Query Language. It's an extension of SQL used in Oracle databases. It allows you to create procedures, functions, triggers, and more to enhance the capabilities of SQL for managing and manipulating data within the Oracle environment. It's a powerful tool for developing applications within Oracle databases.

Objectives of the Course

   - Write SQL code
   - Write PL/SQL code for developing packages
   - Create and manage database sequence and tables
   - Improve database security and its performance
   - Know complete concepts of several PL/SQL sections like Execution, Declaration and Exception

Not sure? Get Free Consultation Today!
 * I agree to AppTekLab Terms & conditions and Privacy Policy
Course Includes

  • Aggregate Functions
  • Analytical Functions
  • Joins 
  • operators
  • Nested query
  • Sub query
  • CTE

  • Introduction to PL/SQL
  • The Advantages of PL/SQL
  • 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
  • Simple LOOP,WHILE LOOP,FOR LOOP   and NESTED LOOPS
  • SQL within PL/SQL

  • Cursor Management in PL/SQL
  • Implicit Cursors
  • Explicit Cursors
  • Cursor Attributes
  • Cursor with Parameters
  • Cursors with LOOPs Nested Cursors
  • Cursors with Sub Queries
  • Ref. Cursors

  • Stored Procedures
  • PROCEDURE with Parameters (IN, OUT  and IN OUT)
  • POSITIONAL Notation and NAMED Notation
  • Procedure with Cursors
  • Dropping a Procedure

  • Intorducing Function
  • Difference between Procedures and Functions
  • User Defined Functions
  • Nested Functions
  • Using stored function in SQL statements

  • Creating PACKAGE Specification and  PACKAGE Body
  • Private and Public Objects in PACKAGE
  • Overloading concept

  • Types of exceptions
  • User Defined Exceptions
  • Pre Defined Exceptions
  • RAISE_APPLICATION_ERROR
  • PRAGMA_AUTONOMOUS_TRANSACTION
  • SQL Error Code Values

  • Introducing Triggers
  • Types of Triggers
  • Row Level Triggers
  • Statement Level Triggers
  • DDL Triggers

  • Introducing Index
  • Types of Index
  • Primary key, Unique Key etc 
  • Improving performance of query
  • How to read Explain plan
  • Using Hints
  •  
Session Start
Installment Option
Free Trial
Full Payment
July 27, 2024 Yes
3
$2500.00