Radical Technologies
  • Starting Data Science and Analytics with Spark, Scala ,R and Python…Devops with- Chef Puppet Docker Ansible Salt Stack Jenkins Git Nagios Jira….VMWARE VCP 5.5 + 6.0 and 6.5 On Cisco UCS Server ….AWS | Salesforce | Openstack | Azure – Implementation,Migration  and  certification oriented Training …Windows SCCM And Server Deployment training with real time examples……Starting Training on Netapp Data Ontap Cluster Mode + 7.0 Mode…Appear for any RedHat Practical Exams at Any Time through KOALA-Redhat Systems…Discounted Oracle , Microsoft Exam Vouchers available….Exam Centres at Aundh & Kharadi in Pune, HSR Layout in Bangalore

  • COMBO COURSES

    RedHat Linux, Vitualization, Cloud, Hadoop,Datawarehousing Combo Courses with Discounted Price.....

    Readmore..

  • ONLINE TRAINING

    Radical Technologies provides best Online Training with Real-time Projects by Industry Experts....

    Online Schedule

  • BATCH SCHEDULE

    Best Classroom Training from Industry Consultants on High end Real-time Enterprise servers...

    Classroom Schedule

  • CERTIFICATIONS

    Authorized Exam Center for RedHat, Oracle, IBM, Microsoft, Cisco, Salesforce, AWS etc...

    Readmore..

ADVANCED PLSQL

Best Advanced Plsql training in pune by highly experienced Industry Experts

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.

Duration of Training : 5 weekends

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

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

Latest Review
Training Duration : 6 weekends
Oracle sql & plsql training done from Radical Technologies
Written by: Onkar Pande
Date Published: 11/24/2015
I have done training in SQL and PL/SQL at Radical Technologies. Depak sir was very cooperative with me although I was from non IT background, he made it very easy for me in each and every aspect.
5 / 5 stars
Summary
Review Date
Reviewed Item
I joined Radical Technologies to learn PL/SQL and it was a very helpful, useful and an enriching experience in terms of knowledge gained, real time scenarios learned, huge amount of practise problems solved. Teachers here are all highly experienced and knowledgeable. I learned Pl/SQL under the expertise of Deepak Dadarwal and feel very confident as a PL/SQL professional. Highly recommended.
Author Rating
51star1star1star1star1star