Oracle PL SQL Developer
Boot Camp
Session Start |
Free Trial |
|---|---|
| November 11, 2023 |
3
|
Get All Classes
Session Start |
Pay in Installment |
Full Payment |
Discount |
|---|---|---|---|
| November 11, 2023 |
$300.00 Monthly
|
$1000.00
|
Discount on Call |
Course Includes
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
