Oracle PL SQL Developer
Boot Camp
Session Start |
Free Trial |
|---|---|
| July 27, 2024 |
3
|
Get All Classes
Session Start |
Installment Option |
Full Payment |
|---|---|---|
| July 27, 2024 |
Yes
|
$2500.00
|
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
