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
• 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
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
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
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.