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 codes
   - Write PL/SQL codes 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

Course Includes
Join Now
Advanced SQL
  • Aggregate Functions
  • Analytical Functions
  • Joins 
  • operators
  • Nested query
  • Sub query
  • CTE
Indtroducing PL/SQL
  • 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
  • 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
Procedure
  • Stored Procedures
  • PROCEDURE with Parameters (IN, OUT  and IN OUT)
  • POSITIONAL Notation and NAMED Notation
  • Procedure with Cursors
  • Dropping a Procedure
Functions
  • Intorducing Function
  • Difference between Procedures and Functions
  • User Defined Functions
  • Nested Functions
  • Using stored function in SQL statements
Packages
  • Creating PACKAGE Specification and  PACKAGE Body
  • Private and Public Objects in PACKAGE
  • Overloading concept
Exceptions
  • Types of exceptions
  • User Defined Exceptions
  • Pre Defined Exceptions
  • RAISE_APPLICATION_ERROR
  • PRAGMA_AUTONOMOUS_TRANSACTION
  • SQL Error Code Values
Trigger
  • Introducing Triggers
  • Types of Triggers
  • Row Level Triggers
  • Statement Level Triggers
  • DDL Triggers
Performance
  • Introducing Index
  • Types of Index
  • Primary key, Unique Key etc 
  • Improving performance of query
  • How to read Explain plan
  • Using Hints
  •  
Session Start
Free Trial
Pay in Installment
Full Payment
Discount
November 11, 2023 3
$300.00 Monthly
$1000.00
Discount on Call
Not sure? Get Free Consultation Today!
 * I agree to AppTekLab Terms & conditions and Privacy Policy