Subscribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: Aug 1st @9:00AM

Faculty: Mr. Ahmed Shareef (18+ Yrs of Exp,.. & Real Time Expert)

Duration : 20 Days

Location: Maitrivanam, Hyderabad

Venue :
DURGA SOFTWARE SOLUTIONS at Maitrivanam
Plot No : 202, IInd Floor ,
HUDA Maitrivanam,
Ameerpet, Hyderabad-500038.

Ph.No: +91 - 8852 8852 96/97/63/64

Syllabus:

ORACLE 19c - PL/SQL

1. PL/SQL

• Introduction to PL/SQL
• What is a Program block?
• Advantages of PL/SQL.
• Architecture of PL/SQL Engine
• Features, Structure of Program Block
• Data types, Executable Stmts.
• What are the blocks in the program structure?
• DECLARE Block
• BEGIN Block
• EXCEPTION Block
• END

1.1. TYPES OF PROGRAMS

• Static Programs
• Dynamic Programs
• Worked Examples and Assignments

1.2. Type Compatibility keywords

• Declaring variables Dynamically --%TYPE
• Declaring Table Type Record Variables--%ROWTYPE

1.3. SUB PROGRAMS

Stored Procedures
• What is a procedure?
• How to create it?
• What are the advantages of procedures?
• Types of stored procedures
• Static Procedures (without Arguments)
• Dynamic Procedures (with Arguments)
• Arguments or Parameters Mode
• IN OUT INOUT

CONTOL STRUCTURES
CONDITIONAL STATEMENTS
• Simple IF
• IF—THEN—ELSE
• COMPOUND IF
• ELSIF Construct
• Worked Examples and Assignments

LOOPS
• Simple Loop
• While Loop
• For Loop

CURSORS
• Types: Implicit and Explicit cursors
• Cursor Variables
• FOR loop cursor
• Parameterized cursor
• REF_CURSOR

What is BULK COLLECT?
What is FORALL?
What is BULKBIND?

EXCEPTION HANDLING AND THEIR TYPES
• Predefined Exceptions
• User defined Exceptions
• Pragma_ Exception_init
• RISE_APPLICATION_ERROR

PL/SQL RECORDS AND TABLES
• Composite Data Types
• PL/SQL Records & Tables
• Nested Records
• Using Record in a Table
• And Examples

FUNCTIONS
• What is a Function?
• When we have to create a function?
• How to call it?
• With and without arguments

PL/SQL Collections
• VARRAYS
• Associative Arrays
• Nested tables/ PLSQL TABLES

TRIGGERS
• What is a Trigger Program?
• When we need a Trigger?
• Parts of a Trigger
• Types of Triggers
• Database Triggers
• Row Level Triggers with Ex.
• Statement Level Triggers
• Instead-of Triggers - Views with Ex.

PACKAGES
• What is a PACKAGE?
• Structure of package
• Package Spec and Body
• Accessing procedures and functions from a package

Supporting
Interview Tips
Interview Questions
Resume Preparation tips