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 26th Aug (Fast-track) 30
September 4th - weekday, 23rd - fast-track 30
October TBA 30
November 4th - fast-track,6th - weekday 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