Pl-SQL Training Course

Pl-SQL Training Course

Click on the buttons inside the tabbed menu:

Course Description

The Pl-SQL program is designed to help the participant to understand the application development in a RDBMS environment and to successfully work in this domain.

There are multiple courses available to fit the requirement of students and working Professionals.

1. Pl-SQL for Oracle RDBMS.

2. t-SQL for SQL Server Environment

;
What skills will the student gain?
After the completion of this course, the student will be able to:

  • Understand the basics of writing code in PlSQL environment.
  • ·   Learn about writing and compiling code in a database environment
  • ·   Learn about the different types of programs like procedure, function and packages in RDBMS
  • ·   Working with triggers in RDBMS
  • ·   Understand different types of delivered packages by Oracle
  • ·   Use Pl-SQL programs to insert, update and delete multiple records through a single program.

Mode of Training

The Pl-SQL training is delivered in the following modes - Regular Classroom, Fast-track, Self-Study and Online live trainer

Locations:

The training is offered in locations like Chennai, Bangalore, Kolkata, Mumbai and NCR.

To know more about the schedules in those cities click here -->

Schedule for Kolkata

Outside the country it is delivered in Dhaka, Thimpu, Singapore, Kuala Lumpur, Middle East, Africa and Australia.

The course outline delivered during the class is as follows -

  • Introduction to PLSQL

  • istory of PL/SQL language
  • he anonymous PLSQL block
  • ariables &  Data types
  • SQL operators,  Nested blocks
  • SELECT … INTO statement
  • How to Manage, Test and Remove Triggers
    • Triggers

    • Describe Triggers
    • Identify the Trigger Event Types and Body
    • Business Application of Triggers
    • Create DML Triggers using the CREATE TRIGGER Statement and SQL Developer
    • Identify Trigger Event Types, Body & Firing
    • Differences in Statement & Row Level Triggers
    • Create Instead of and Disabled Triggers

Composite data types

  • Parsing %ROWTYPE
  • SQL Records & Table of Records

Oracle Utilities

  • SQL*loader (sqlldr)
  • Spool and spool append commands.
  • Profiling PL/SQL code using DBMS_HPROF supplied package.

Using Oracle Supplied Packages

  • BMS_OUTPUT & DBMS_UTILITY
  • TL_FILE, UTL_MAIL
  • BMS_RANDOM & EXECUTE IMMEDIATE

Package Features

  • Overloading package subprograms
  • Forward declaration of subprograms
  • Creating bodiless package
  • Persistent state of package variables & cursor

Creating Packages (PL/SQL API Development)

  • What are packages and what is an API ?
  • Package Body & Specification
  • Private and Public Package level data
  • Calling package functions, procedures
  • Referencing package-level constants & variables

Creating Procedures (Stored sub-programs)

  • Stored sub-programs (Procedure/Functions)
  • d for Procedures – create syntax
  • Use of Parameters ( IN , OUT & IN OUT)
  • Executing procedures & trapping Exceptions

Creating Functions

  • Syntax of CREATE FUNCTION
  • Restrictions on function calls
  • Dropping functions

Exceptions and Exception handling

  • What are Exceptions?
  • Need for handling & types of exceptions
  • The raise_application_error built-in procedure & User defined exceptions
  • Raising & Trapping Exceptions
  • Exception propagation in nested calls
  • Use of SQLCODE & SQLERRM
  • Testing of these statements.
  • Use of  FOR Loop &  WHILE Loop
  • How to label a loop and how to nest a loop.

Iterative and Conditional control structures

  • sing cursors in procedures
  • OPEN. FETCH CLOSE construct
  • The %NOTFOUND operator
  • FOR UPDATE cursors, Pl-SQL Case
  • Use of  IF-THEN-ELSE statement

Schedule

If you are located outside Kolkata or would like to attend our session during your visit to Kolkata then please feel free to write us at palium.skills@gmail.com for any queries related to program,
upcoming schedule and fee. Call: +91-9051092035 or WhatsApp: +91-9051092035

Schedule for AWS Training in 2018 is as follows:
Month Dates No of Hours
January Completed
February Completed
March Completed
April Completed
May Completed
June Completed
July Completed
August Completed 30
September Completed 30
October TBA 30
November Completed 30
December 2nd - fast-track, 4th - weekday 30

Study Mode & Fees

Course/Certification Name Delivery Mode Fees Special Offers
Pl-SQL Fundamentals Classroom Rs. 6,000+ 18% GST best offers for 3+ enrollments
Oracle Pl-SQL Certification Exam Online Exam Rs. 11,000 + 18% GST Payable directly to Oracle, discounts available from time to time
Pl-SQL Fundamentals Fast-track Classroom training talk to us best offers available
Pl-SQL Fundamentals Online live trainer Rs. 6,000+ 18% GST best offers available
Pl-SQL Fundamentals Self-study Rs. 1,500 + 18% GST --

FAQs

The commonly asked questions pertaining to Oracle Pl-SQL training are -

Q: What are the pre-requisites for taking the Pl-SQL course?

A: Good knowledge of SQL Fundamentals is a must.

Q: Will this be theoretical or hands-on?

A: This is a complete hands-on training where the trainer will demonstrate each feature and participants will follow and do the same on the system.

Q: Will I get access to the database?

A: Yes, trainer will demonstrate how to access the instance.

Q: Will I incur any charges for accessing the application?

A: The standard features are available for free. There are some premium services for which charges maybe imposed by service provider.

Q: What if I have doubts after completing the class?

A: You can gather your doubts and come by prior appointment to get your doubts cleared.

Q: What help will I get for clearing the Certification Exam?

A: Our trainer is a Certified person and will provide guidance and tips for clearing the exam. Besides, you will get access to question bank for preparing for the exam

Q: Will I receive a certificate for the course?

A: Yes, participants receive a certificate after completing the course provided they have attended 90% of the class.

Get help now
CONTACT US +91-9051092035 (24×7)
WhatsApp +91-9051092035 (24×7)
Enquire Now

A Few Things You’ll Love!

  • Experienced Training Partner
  • Certified & Industry Experts Trainers
  • Multiple Training Delivery Models
  • Customized Course
  • 24/7 e-Learning Access
  • Assessments and Mock Tests
  • Placement Assistance

Palium Skills