Learnfly Academy

PL/SQL Training

  • Sale
  • Regular price Rs. 15,000.00

Drop a query

Speak to Counsellor: Call 1-800 3000 7460 (India Toll Free)


Quick Overview

Course Description

PL SQL course is essentially an in-depth introduction to Oracle Database 11g. The course will train you to become an expert of designing, building and managing high-end database applications with Oracle 11g. During the course we will teach you the PL SQL and related concepts like:



  • Basic PL/SQL Programming
  • Syntax and Section Query
  • Cursor/Conditional Statement
  • Advance Cursor
  • Subprogram - Procedure
  • Procedures/Function, Package
  • Advance Package
  • DML & advance level DML
  • Scripting etc.

After the course, you will be able to:


  • Restore and manipulate data efficiently
    using SQL Developer
  • Generate and handle database tables
  • Maintain data integrity
  • Strengthen the security
  • Restrict unauthorized access to database tables
  • Enhance performance by using encryption format

Enroll for a Live Class

Enroll for the course at the earliest as we have limited seats available.

Duration : 1 hour
Length : 7 Weeks
Batch Start Date : 26/11/2016
Course Fee Rs. 15000
Test Lab Hours : 30 mins
Class Room Training : Available
Instructor Learnfly Faculty
Available Training Modes Instructor-Led Class

PL SQL training is a comprehensive training in which the primary objective is to learn database protection and management. The curriculum will help you learn and test your progress as you move forward.

  • Overview of PL/SQL
  • PL/SQL Environment
  • Benefits of PL/SQL
  • Variable uses, types and declaration
  • PL/SQL Block syntax & guideline
  • SQL functions in PL/SQL
  • Data type conversion
  • Nested blocks and variable scope
  • Retrieving and updating data in PL/SQL
  • Naming conventions
  • SQL Cursor
  • SQL Cursor Attributes.
  • Controlling PL/SQL flow of executions
  • IF Statement
  • Simple IF Statement
  • IF-THAN-ELSE Statement Execution Flow
  • IF-THAN-ELSE Statement
  • IF-THAN-ELSIF Statement
  • Logic Tables
  • Boolean Conditions.
  • Iterative controlling loop statement
  • Nested Loops and Labels.
  • Writing Explicit cursors
  • About cursors
  • Explicit cursor functions
  • Controlling explicit cursor
  • Opening the cursor
  • Fetching Data cursor
  • Cursor and records
  • Cursor for loop using sub queries
  • Advance Explicit cursor
  • Cursor with parameters
  • For update Clause
  • Where current of Clause
  • Cursor with sub queries
  • Handling Exception
  • Handling Exception with PL/SQL
  • Predefined Exceptions
  • User Defined Exceptions
  • Non-Predefined Error
  • Function for trapping Exception
  • Trapping user-defined Exception
  • Raise Application Error Procedure
  • Overview of subprograms
  • PL/SQL Subprograms
  • What is Procedure
  • Syntax for creating Procedure
  • Creating Procedure with parameter
  • Example of Passing parameters
  • Declaring Subprogram
  • Procedures – Developing procedures, removing procedures
  • Benefits of subprograms
  • Procedural Parameter Modes
  • Actual vs. Formal Parameters
  • Methods for passing parameters
  • Function – Creation, overview, syntax
  • Restrictions on calling from SQL
  • Advantages of user defined functions in SQL expressions
  • Comparing procedures and functions
  • Benefits of stored procedures and functions
  • Detecting compilation errors
  • L/SQL records
  • Using Pl/SQL Table method and example
  • Creating PL/SQL Table
  • Packages – Objective, overview, component,
    developing, removing, advantages
  • Creating the package specification/example
  • Declaring Public construct
  • Public and private construct
  • Invoking package construct
  • Referencing a public variable from
    a standalone procedure
  • Guide lines for deploying packages
  • Overloading
  • Using forward declaration
  • One time only procedure
  • Package functions
  • User define package function
  • Persistent state of package function
  • Persistent state of package variable
  • Controlling the persistent state of package cursor
  • Purity end
  • Using supplied package
  • Using native dynamic SQL
  • Execution flow
  • Using DBMS-SQL package
  • Using DBMS-DDL package
  • Submitting jobs
  • Interacting with operating system links
  • Triggers – Definition, objective and its event type
  • Application & database triggers
  • Business application scenarios for implementing triggers
  • Define DML triggers
  • Define Non – DML triggers
  • Triggers event type & body
  • Creating DML triggers using the create triggers statement
  • Define statement level triggers v/s low level triggers
  • Triggers firing sequence: single row manipulation
  • Creating a DML statement triggers
  • Using old and new qualifiers
  • Old and new qualifiers
  • Instead of triggers
  • Managing triggers using the alter & drop SQL statement
  • Testing triggers
  • Viewing trigger information
  • Describe user triggers
  • What is a compound trigger and working with it
  • Compound trigger structure for tables
  • Trigger restrictions on mutating tables
  • Compound trigger restrictions
  • Using a compound trigger to resolve the mutating table error
  • Creating triggers on system events
  • LOGON and LOGOFF triggers example
  • Call statements in triggers
  • Benefits of database-event triggers
  • System privileges required to manage triggers
  • Dynamic SQL-objectives
  • Describe execution flow of SQL statements
  • Dynamic SQL with a DDL statement-example
  • Working with dynamic SQL
  • Native Dynamic SQL(NDS)
  • Using the executive immediate statement-example
  • Using native dynamic SQL to compile PL/SQL code
  • Using DBMS-SQL with a DML statement
  • Using the DBMS-SQL package subprograms
  • Parameterized DML statement
  • Managing Dependencies
  • Objectives, overview of schema object dependencies
  • Direct local dependencies
  • Querying direct object dependencies
  • Displaying direct and indirect dependencies
  • Fine-Grained dependency management
  • Changes to synonym dependencies
  • Maintaining valid PL/SQL program units and views
  • Object revalidation
  • Concepts of remote dependencies
  • Setting the remote dependencies mode parameter
  • Recompiling PL/SQL program unit
  • Packages and Dependencies
  • Successful and unsuccessful recompilation
  • Recompiling procedures

 

Learnfly Academy is a forward-thinking educational ecosystem. We train extraordinary people for the emerging professions of the 21st century according to industry demand. We fill a crucial gap between learners and companies to train and hire the best talent in the market. Learning from Learnfly Academy increases your chances by 95% to get you the right job.

Live Class is a live streaming of teacher from our location. Learnfly Academy instructors deliver live classes in an online environment. Attendees join a WebEx session from their preferred location and connect to a hosted lab environment to practice what they learn. We run classes as per Indian Standard time.

Each attendee needs a computer with a high-speed Internet connection in order to connect to

  • A WebEx web conference session and
  • A hosted lab environment.
and For best results, we recommend the following browsers: PC - Internet Explorer or FireFox. Mac - 64-bit browser (Safari of FireFox). or Google Chrome We also highly recommend that you use a computer headset and microphone (VOIP) and that you attend from a quiet workspace to allow you to concentrate.

 

We have a very transparent fee structure. Please see the course fee next to the “Add to Cart” button on this page.

We only provide certified and industry expert trainers to our learners. Our teachers/instructors are highly qualified in their training verticals. Our instructors could be an individual teachers from colleges or working professionals from multi national companies like google, Facebook or Microsoft.

Of course you should. That’s what applications are for, don't worry. It's our responsibility to make sure that you are ready for any course you will attend. If it's not right for you, we'll let you know. We're not shy about things like that.

Yes. We do offer full job assistance once you do the certification from Learnfly. We have partnered ourselves with multiple small business and multi national companies to provide you the best working platform. We also conduct in-house campus events and send you invitations to experience multiple job opportunities at one place. We offer 99% job placement, if you do 2-3 job oriented courses from our catalogs.

Currently, you can attend our class’s in English or Hindi Language.

Yes Off course! You can reschedule a class with your assigned teacher or request for a pre-recorded session on your email.

We accept payments via credit cards, debit cards, net banking & NEFT. You can also pay us via paypal & paytm. Use the “Add to Cart” button provided on this page and checkout by making the online payment. You will receive an automated confirmation on your email after a success-full payment with further instructions.

Once you purchase training, we'll send you an email with registration instructions. Also, One of our counsellor will get in touch with you to assign you an online teacher and decide the class timings. We can either assign you to the existing running batch or add you in the upcoming batches.

You may cancel an order within 30 days of purchase for a full refund, but not inside of 3 days of your scheduled course.

 

Step 1 : Make an Online Payment


Step 2 : Our Counsellor will contact you within few minutes after payment.


Step 3 : Choose your time to attend your live class with our counsellor


Step 4 : Connect with a Live Teacher from your PC, Phone or a tablet & attend the class from anywhere in the world.


You may be interested in:


Customer Reviews

Based on 5 reviews Write a review