Call :+91 8055223360 

ADVANCED PLSQL TRAINING IN THRISSUR

2145 Reviews
4.8/5
2267 Learners

Overview

Duration of Training : 5 weekends

Watch
INTRO VIDEO

Why Radical Technologies

Check Batch Schedulings

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.

Course Curriculum

Course description

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.

For whom PLSQL is? 

IT professional can easily enter into leading Database Programming Language which is close to all domain as back-end PLSQL Developer. There are so many reason to go ahead:

  • Oracle PLSQL is extension of SQL platform; Seamlessly integrates procedural construct with SQL.
  • It is Oracle Corporation’s standard Data access language for Relation Databases.
  • Oracle PLSQL Developer opportunities are so many more with MNCs.
  • It is easy to survive with Product Development & Service based company due to Oracle Database product.
  • On completion Oracle PLSQL training you can attempt certification exam.Certified candidate can take benefit as IT document and can get good opportunity in IT world, as skill set PLSQL Developer.

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

Pre-requisites

There are no formal prerequisites for this course; however, previous operating system administration experience will be very beneficial.

Course Content

WEEK-01 

Oracle PLSQL 

PLSQL Basic:

[1] Introduction to Oracle PLSQL

  • Oracle PLSQL: Course Agenda, Course HR Data set, PLSQL Environment, Benefits and Block structure, Create & Execute Anonymous Block, Test output of PLSQL Block. Practice Overview.

[2] Declaration PLSQL Variables

  • Use of Variables, Identifier, Handling Variable in PLSQL, Declaration & Initialization of PLSQL variable, Type of Variable, Guideline for Declaration & Initialization PLSQL Variables, Scalar Data Type, Bind Variables, Substitution Variables, Composite and LOB Data Type Variables. Practice Overview.

[3] Writing Executable Statement

  • Lexical Unit of PLSQL Block, Commenting Code, Usage of SQL Function in PLSQL, Nested Block, Variable Scope & Visibility, Operator in PLSQL, Indenting PLSQL Code. Practice Overview 

WEEK-02 

[4] Interacting with Oracle Server

  • SQL Statement in PLSQL, Naming Convention, Manipulating Data using PLSQL, Inserting, Updating, Deleting, & Merging Data in PLSQL, SQL Cursor & Attribute. Practice Overview.

[5] Writing Control Structure

  • Controlling Flow of Execution, IF statement, IF THEN ELSE Statement, IF ELSIF ELSE clause, NULL values in IF Statements, Case Expression, Loop statements, BASIC Loop, WHILE Loop, FOR Loop, Guidance while using loop, Nested Loop and Labels. Practice Overview.

[6] Working with Composite Data Type

  • Composite Data Type, PLSQL Records, PLSQL Records Structure, The %ROWTYPE Attribute, Advantages of %ROWTYPE & Sample Program using Record %ROWTYPE. Practice Overview.

WEEK-03

[7] Cursor

  • About Cursors, Explicit cursor operations, Curosr Life Cycle , Cursor & Records, Cursor FOR loop, Explicit Cursor Attributes, Usage of FOR UPDATE & WHERE CURRENT OF Clause, Cursor with Sub-Queries. Practice overview. 

[8] Handling Exception

  • Handling Exception using PLSQL, Exception Types, Trapping Exceptions, Guidelines for Trapping Exception, Trapping Predefined & Non Predefined Oracle Server Errors, Function of  Trapping Exception, Propagate Exception in Sub-Block, RAISE_APPLICATION_ERROR Procedure . Practice Overview.

[9] Introduction to Stored Procedure & Function

  • Stored Procedure & Function, Difference between Anonymous Block and Sub-programs, Procedure Syntax, Example, Execution, Function Syntax, Example, Execution, Passing Parameter to Function etc. Practice Overview.

PLSQL Advanced:

WEEK-04

[10] Creating Stored Procedures

  • Developing Procedure, What is parameters? Formal & Actual Parameters, Procedural Parameter Modes, Example of IN, OUT, INOUT parameter passing modes, Invoking Procedure, Handle Exception, Remove Procedure, Viewing Procedure in the Data Dictionary, Benefit of Subprograms, Practice Overview.

[11] Creating Stored Functions

  • Developing Function, Way to execute Function, Advantages of User Defined Function in SQL statements, Function in SQL Expression, Location to Call User Defined Function, Restriction on Calling from SQL Expressions, Controlling side effect Calling Functions from SQL Expression, Remove Function, Viewing Function in the Data Dictionary, Procedure Versus Function. Practice Overview.

[12] Introduction to Collection

  • Why Collection? Oracle Collection, Associative Array, Varray, Nested Table, Scenario for Collection When to use What, Ref Cursors, Type Ref Cursors, Advantage/Disadvantage of Ref Cursor. Practice overview.

WEEK-05

[13] Creating Packages

  • PLSQL Package, Component of PLSQL Package, Visibility of Package Component, Developing PLSQL Package, Creating Package Specification & Package Body, Invoking Package Subprograms, Creating & Using Bodiless Package, Removing Package, Viewing Package in the Data Dictionary, Guideline to writing Package, Advantage of Using Package. Practice overview.

[14] Advancement on Package Concept

  • Overloading Subprograms, Overloading the Standard Package, Use of Forward Declaration, Package Initialization Block, Use Package Function in SQL & Restriction, Persistent State of Package/Variables, Package using Collection, Wrapper Utility, Guideline for Wrapping. Practice Overview.

[15] Design Consideration for PLSQL Code

  • Standardizing Constant & Exception, Exception Handling, Local Subprgrams, Definer’s Rights Versus Invoker’s Right, Features of Autonomous Transaction, Bulk Binding, Bulk Binding FORALL Example       , Using BULK COLLECT INTO with Queries/Cursors   . Practice Overview. 

WEEK-06

[16] Creating Triggers

  • Type of Triggers, Guidelines of Designing Triggers, Creating DML Trigger, Type of DML Triggers, Trigger Timing, Trigger Firing Sequences, DML Statement Triggers, Using Conditional Predicates, DML ROW Trigger, Old, New Qualifier, Restricting Row Trigger, Implementing Integrity Constraint with a Trigger, Comparison of Database Triggers and Stored Procedure, Comparison of DB Trigger and Oracle Forms Triggers, Managing, Removing, Testing Trigger. Practice Overview.

[17] Application for Triggers

  • Creating Database Triggers, Creating Triggers on DDL Statements, Creating Triggers on System Events, LOGON, LOGOFF Triggers Examples, CALL Statements, Reading Data From a Mutating Table, Benefit of DB Triggers, Business Application Scenario for Implementing Triggers, Viewing Triggers in Data Dictionary using USER_TRIGGERS. Practice Overview.

[18] Project Work

  • It covers real time project scenario including all deliver conceptual session based on Database 10g/11g. It includes Data Import, Validation, Audit Trail, Performance based Program etc.

[schema type=”review” url=”https://www.radicaltechnologies.co.in/” name=”Advanced PLSQL Training in Radical Technologies” description=”PLSQL Training in Pune” rev_name=”Advanced PLSQL” rev_body=”Excellent Training. Trainer was well experienced & have good knowledge. who explains every thing well. Really great training” author=”Ram Krishna” user_review=”5″ min_review=”0″ max_review=”5″ ]

Training Options

Live Online Training

  • Highly practical oriented training
  • Installation of Software On your System
  • 24/7 Email and Phone Support
  • 100% Placement Assistance until you get placed
  • Global Certification Preparation
  • Trainer Student Interactive Portal
  • Assignments and Projects Guided by Mentors
  • And Many More Features

Course completion certificate and Global Certifications are part of our all Master Program

Live Classroom Training

  • Weekend / Weekdays / Morning / Evening Batches
  • 80:20 Practical and Theory Ratio
  • Real-life Case Studies
  • Easy Coverup if you missed any sessions
  • PSI | Kryterion | Redhat Test Centers
  • Life Time Video Classroom Access ( coming soon )
  • Resume Preparations and Mock Interviews
  • And Many More Features

Course completion certificate and Global Certifications are part of our all Master Program

Exam & Certification

Course Reviews

I had a wonderful experience in Radical technologies where i did training in Hadoop development under the guidance of Shanit Sir. He started from the very basic and covered and shared everything he knew in this field. He was brilliant and had a lot of experience in this field. We did hands on for every topic we covered, and that’s the most important thing because honestly theoretical knowledge cannot land you a job.
Rohit Agrawal Hadoop
I have recently completed Linux course under Anand Sir and can assuredly say that it is definitely the best Linux course in Pune. Since most of the Linux courses from other sources are strictly focused on clearing the certification, they will not provide an insight into real-world server administration, but that is not the case with Anand Sir’s course. Anand Sir being an experienced IT infrastructure professional has an excellent understanding of how a data center works and all these information is seamlessly integrated into his classes.
Manu Sunil Linux
I had undergone oracle DBA course under Chetan sir’s Guidance an it was a very good learning experience overall since they not only provide us with theoretical knowledge but also conduct lot of practical sessions which are really fruitful and also the way of teaching is very fine clear and crisp which is easier to understand , overall I had a great time for around 2 months , they really train you well.also make it a point to clear all your doubts and provide you with clear and in-depth concepts hence hope to join sometime again
Reema banerjee Oracle DBA
I have completed Oracle DBA 11g from Radical technology pune. Excellent trainer (chetna gupta ). The trainer kept the energy level up and kept us interested throughout. Very practical, hands on experience. Gave us real-time examples, excellent tips and hints. It was a great experience with Radical technologies.
Mrudul Bhokare Oracle DBA
Linux learning with Anand sir is truly different experience… I don’t have any idea about Linux and system but Anand sir taught with scratch…He has a great knowledge and the best trainer…he can solve all your queries related to Linux in very simple way and giving nice examples… 100 🌟 to Anand Sir.
Harsh Singh Parihar Linux
Prev
Next

Why we are the best Radical Technologies

Radical Technologies is truly progressing and offer best possible services. And recognition towards Radical Technologies is increasing steeply as the demand is growing rapidly.

Creative

0%

Innovative

0%

Student Friendly

0%

Practical Oriented

0%

Valued Certification

0%

Training FAQs

Similar Courses

ENQUIRE NOW











    [recaptcha]