ORACLE PLSQL – Radical Technologies Bangalore HSR Layout
Open Quick Enquiry
Please Contact Us
rad

ORACLE PLSQL

Best Advanced Plsql training in Bangalore

PLSQL Training by 10+yrs exp. Trainers

PL/SQL Training Duration : 5 weekends

Training Highlights:Training will be for experienced as well as for freshers also where everyone will get familiar with RDBMS concepts using Oracle and will be expert in PLSQL programming. Training will be user friendly and will be more focusing on real time programs as per industry standards.

Subject overview: By attending the training, you will become the expert in PLSQL programming. There will be complete subject covered by explaining each in & out of PLSQL. We shall be covering the following in training:

• Understanding the PLSQL block

• Advantage of PLSQL

• Writing programs in PLSQL

• Cursors

• Procedures / Packages / Functions and Triggers

• Creating the executable section

• Exception Handling

• Advanced PLSQL programming like Varrays, Nested tables etc.

Interview preparation : As per the topics covered, after each topics there will be interview questions preparation

 

Course Syllabus

Overview of Oracle Architecture
Physical Structure
Logical Structure
Memory Structure
Other Data-types
Interval and Date Data-types
Various TIMESTAMP Data-types
INTERVAL YEAR TO MONTH Data-type
INTERVAL DAY TO SECOND Data-type
Records and Collections
Introduction to PL/SQL records
Defining and declaring PL/SQL records
Initializing, referencing, assigning and comparing records
PL/SQL tables of records
Inserting PL/SQL records into the database
Updating the database with PL/SQL record values
Restrictions on record inserts / updates
Querying data into collection of records
Associative arrays

ORDBMS Features of Oracle
Features of object-oriented programming
Advantages of object orientation
Creating abstract data types
Creating methods
Retrieving information about objects
Creating tables using an abstract data types
VARRAYs and Nested Tables
Inserting records into tables
Constructor methods
Selecting columns, object attributes, and methods from object
tables
Comparing objects with map and order methods
Inserting data using constructor methods
Introduction to Collections.
Introduction to Varrays.
Creating Varrays
Introduction to Nested tables
Creating nested tables
Manipulating data using Varrays and Nested tables
Altering Varrays and Nested tables
Bulk Binds
Introduction to Bulk Binds
Improving performance using bulk binds
Querying data into collections of records
Using DML on collections with deleted elements
Using DML on selected elements in collections
Effects of rollback on FORALL
Flashback Table and DBMS_FLASHBACK
Introduction
Privileges required
Flashing back dropped tables
Purge
Overview of DBMS_FLASHBACK
Subprograms of DBMS_FLASHBACK
Advance Trigger Concepts
Creating Triggers on DDL Statements: CREATE, ALTER OR DROP
Creating Triggers on other User Events: Logging on or off
Creating Triggers on database or System Events: Shut down or startup of the
database or on an error
CALL Statement
Mutating Table
Benefits of Database Triggers
Viewing Information from USER_TRIGGERS & USER_ERRORS data dictionary
views
Managing Dependencies
Local Dependencies
Direct and Indirect Dependencies
Different data dictionary views for viewing direct & indirect dependencies
REMOTE_DEPENDENCIES_MODE Parameter
Time stamp & Signature Modes of remote dependencies

Our Courses