Oracle PL/SQL Training and Certification

Our Oracle PL/SQL certification training course lets you learn the PL/SQL language for querying Oracle databases. We provide the best online training classes to help you learn the database tools, query language, subprogram, syntax query, basic and advanced DML and scripting. In this program, you will work on real-world industry projects.

Get DWH & Erwin or MsExcel selfpaced course free. Enroll Now

Key Features

  • Instructor Led Training : 24 Hrs
  • Self-paced Videos : 24 Hrs
  • Exercises & Project Work : 28 Hrs
  • Get Certified & Job Assistance
  • Flexible Schedule
  • Lifetime free upgrade
  • 24 x 7 Lifetime Support & Access

About Oracle PL/SQL Training and Certification Course

This PL/SQL online training course provides you the complete skills needed to create, implement and manage robust database applications using the Oracle Database tools. Some of the topics covered are: understanding of the Basic Procedural Language/Structured Query Language, subprogram, section and syntax query, DML, advanced DML and scripting. The entire training is in line with the Oracle PL/SQL certification.

What will you learn in this PL/SQL online training course?

  1. Designing, building and managing database applications in Oracle 12c
  2. Writing PL/SQL codes for developing stored procedures, triggers and packages
  3. Managing and creating database sequence, synonym and tables
  4. Improving data security, performance and integrity
  5. Using SQL Developer for manipulation and retrieval of data efficiently
  6. Various PL/SQL sections like Declaration, Execution and Exception Handling
  7. SQL command major groups: DDL, DML, DCL and TCL
  8. Preparing for Oracle PL/SQL Developer Certified Associate

Who should take up the PL/SQL training course?

  • Software Developers
  • Database Administrators
  • SQL and Analytics Professionals
  • BI and Data Warehousing Professionals
  • Those aspiring for a career in Oracle PL/SQL

What are the prerequisites for learning PL/SQL?

There are no particular prerequisites to learn PL/SQL. Although, having prior knowledge of SQL can be beneficial.

Why should you take up the PL/SQL training course?

  • 70% of companies say that analytics is integral to making decisions – IBM Study
  • Big Data and Analytics sales will reach $187 billion by 2019 – IDC Research
  • A PL/SQL Developer can earn $92,000 in the United States – indeed.com

The Oracle PL/SQL is a high-performance transaction processing language that is deployed regardless of the operating system and the front-end tools used. It basically works on the server, and you can program it for complex business logic and rules to get the desired output. This PL/SQL bootcamp training gives you the desired technical know-how to learn PL/SQL and work on challenging industry requirements. You can apply for highly desirable jobs upon the completion of this PL/SQL certification training.

view more
Read Less

Oracle PL SQL Course Content

Introduction to Oracle SQL

What is RDBMS, Oracle versions, Architecture of Oracle Database Server, Installation of Oracle 12c

Hands-on Exercise – Install Oracle 12c

Using DDL Statements to Create and Manage Tables

Categorize the main database objects, Review the table structure, List the data types that are available for columns, Create a simple table, Explain how constraints are created at the time of table creation, Describe how schema objects work

Hands-on Exercise – Create a database table Person with two column (Name, Age) with constraint on age not greater than 100, Insert records using insert query

Retrieving Data Using the SQL SELECT Statement

List the capabilities of SQL SELECT statements, Execute a basic SELECT statement

Hands-on Exercise – Use a basic select statement to retrieve all the records in the Person table

Restricting and Sorting Data

Limit the rows that are retrieved by a query, Sort the rows that are retrieved by a query, Ampersand substitution to restrict and sort output at runtime

Hands-on Exercise – Write a select query to retrieve records where age is more than 60 yrs, Write a select query to sort the records by name, Write a select query to sort the records by age in descending order, Use ampersand substitution to restrict and sort output at runtime

General functions

The general functions in SQL, working with any data type and handling Null values, using COALESCE() and Null function, Constructing and executing SQL query that applies the NUL, NUL1, NUL2 and COALESCE()

Hands-on Exercise – Use NULL function to deal with null values in data

Using Single-Row Functions to Customize Output

Describe various types of functions (character, number, date, string etc.) available in SQL

Hands-on Exercise – Create a table with columns of type char, number and date, Use character, number, and date functions in SELECT statements

Large Object Functions

Large object functions – BFILENAME, EMPTY_BLOB, EMPTY_CLOB, Aggregate or Group functions – COUNT, COUNT(*),MIN,MAX,SUM,AVG,etc…,Group BY Clause, HAVING Clause

Hands-on Exercise – Count records based on a condition, Use Count(*) to know the count of all records, Find Max, Min, Sum, Avg

OLAP Functions

The various OLAP functions, cube, model clause, roll up and grouping functions

Hands-on Exercise – Working with OLAP commands – Cube, Roll Up, etc.

Using Conversion Functions and Conditional Expressions

Describe various types of conversion functions that are available in SQL, Conditional expressions in a SELECT statement

Hands-on Exercise – Group data by using the GROUP BY clause, Include or exclude grouped rows by using the HAVING clause

Displaying Data from Multiple Tables

Joins, Inner Join, Outer Join, Left Join, Right Join, Equijoins and Non-equijoins

Hands-on Exercise – Write SELECT statements to access data from more than one table using equijoins and non equijoins, Join a table to itself by using a self-join, View data that generally does not meet a join condition by using outer joins, Generate a Cartesian product of all rows from two or more tables

Using Subqueries to Solve Queries

Define subqueries, Describe the types of problems that the subqueries can solve, List the types of subqueries

Hands-on Exercise – Write single-row and multiple-row subqueries

Using the Set Operators

Describe set operators, UNION [ALL], INTERSECT, MINUS Operators

Hands-on Exercise – Use a set operator to combine multiple queries into a single query Control the order of rows returned

Manipulating Data using SQL

Describe data manipulation language (DML) statement, Insert, Update, Delete Statements, Control transactions

Hands-on Exercise – Insert rows into a table, Update rows in a table, Delete rows from a table

Database Transactions

What is a database transaction, Properties of a transaction (Atomic, Consistent, Isolated, Durable – ACID), Avoiding error/fault in manipulating database records using transaction

Hands-on Exercise – Begin a transaction, Execute queries to update or insert or delete records, If no error, commit the transaction Else roll back the transaction and end it

Creating Other Schema Objects

Views – simple and complex, Sequences, Index, Synonym

Hands-on Exercise – Create simple and complex views, Retrieve data from views, Create, maintain, and use sequences, Create and maintain indexes, Create private and public synonyms

Writing Cursor and Conditional Statement

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.

Hands-on Exercise – Use Boolean condition on a select query, Use logic table, Create nested loops and labels

Introduction to Explicit Cursor

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

Hands-on Exercise – Write an explicit cursor, Use cursor function, Fetch data cursor

Advance concepts of explicit Cursor

Advance Explicit cursor, Cursor with parameters, For update Clause, Where current of Clause, Cursor with sub queries

Hands-on Exercise – Use cursor with subquery, Use Where Current clause to retrieve data

Exception Handling

Handling Exception, Handling Exception with PL/SQLPredefined Exceptions, User Defined Exceptions, Non-Predefined Error, Function for trapping Exception, Trapping user-defined Exception, Raise Application Error Procedure

Hands-on Exercise – Use Predefined exception, Write user defined exception, Generate and handle exception, Use a function for trapping an exception

Writing Subprogram, Procedure and passing parameters

Overview of subprograms, PL/SQL Subprograms, What is Procedure, Syntax for creating Procedure, Creating Procedure with parameter, Example of Passing parameters, Referencing a public variable from a standalone procedure, Declaring Subprogram

Hands-on Exercise – Create a parameterized procedure, Pass parameters in a procedure call, Access a public variable from a standalone procedure

Creating PL/SQL Package

PL/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, Guide lines for deploying packages

Hands-on Exercise – Create a package, Deploy the created package

Advance Package Concepts and functions

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

Hands-on Exercise – Use supplied package, Use native dynamic SQL, Use DBMS-SQL package, Use DBMS-DDL package, Submit a job

Introduction and writing Triggers

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

Hands-on Exercise – Create a DML statement trigger, Use old and new qualifiers, Manage a trigger using the alter & drop SQL statement, Test the created triggers

Compound Triggers

Viewing trigger information, Describe user triggers, What is a compound trigger and working with it, Compound trigger structure for tables, Timing-point sections of a table compound trigger, Compound trigger structure for views, 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

Hands-on Exercise – View a trigger’s information, Use a compound trigger structure for views, Use a compound trigger to resolve the mutating table error, Create triggers on system events, Use LOGON and LOGOFF triggers, Call statements in triggers

Working with Dynamic SQL

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

Hands-on Exercise – Use the executive immediate statement, Use native dynamic SQL to compile PL/SQL code, Create DBMS-SQL with a DML statement, Create a DBMS-SQL package subprograms

Advance level- Scripting

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 re-validation, Concepts of remote dependencies, Setting the remote dependencies mode parameter, Recompiling PL/SQL program unit, Packages and Dependencies, Successful and unsuccessful recompilation, Recompiling procedures

Hands-on Exercise – Query direct object dependencies, Display direct and indirect dependencies, Set the remote dependencies mode parameter, Recompile PL/SQL program unit, Edit a procedure and recompile it

view more
Read Less

Oracle PL SQL Projects

What projects I will be working on this Oracle PL SQL training?

Project 1 : Performing DML operations on database

Industry : General

Problem Statement : How to manipulate data with DML

Topics : In this project you will learn about the Data Manipulation Language (DML), understand all about the DML triggers which are a special type of stored procedures that are automatically executed when DML operation is performed. You will learn about the various DML operations like INSERT, UPDATE, or DELETE which when fired on a Table or View can activate a DML Trigger. This project involves working with database and application Triggers, deploying the Triggers for various business applications and testing of the DML Triggers.

Highlights :

  • Manipulating data with DML
  • Working with DML Triggers
  • Various DML operations.

Project 2 :  Streamlining banking data with PL/SQL

Industry :  Banking and finance

Problem Statement :  Get information on customer accounts spread across geographies and the history of transactions done.

Description :  In this project you will create a model to capture details of bank, its different branches and store customer information based on geography. With this model you should be able to identify a customer having multiple accounts in different geographies as well as what transactions have been done in the past at all the branches.

Highlights :

  • Create a model and validate it for all use cases
  • Create the tables with required Constraints
  • Insert the appropriate Data
  • Apply Joins & get the required results.

Project 3 : Creating Detailed Patient Report

Industry : Healthcare

Problem Statement : How to analyze the condition of various patients based on disparate data sets

Description : In this PL SQL project you will be working on creating tables and columns based on various entities and insert the sample data. Write SQL queries to extract the data that can be used for analysis purpose. Based on that you shall create a detailed report about the patient, medications taken, any adverse conditions and so on.

Highlights :

  • PL/SQL for coding program blocks
  • Write procedures for IF ELSE conditions
  • Deploy PL/SQL functions & Packages.

Project 4 : Working on university data set

Industry : Education

Problem Statement : How to improve the teaching process of a university

Description : In this PL SQL project you have the Student and Staff data in tables. You will create the Course table and insert data into it. Then you will join the three tables and analyze the data. This includes coming up with all the courses with corresponding students and the teachers associated. Then finally you will create a detailed report on the teaching structure and ways to improve it.

Highlights :

  • Inserting data in table and joining tables
  • Querying the data for various conditions
  • Prepping the data for analysis.
view more
Read Less Project

Sample Oracle PL/SQL Video Tutorials

view more
View Less Sample Videos

Oracle PL/SQL Certification

This course is designed for clearing the Oracle PL/SQL Developer Certified Associate exam and learning PL/SQL as per the needs of the industry. The entire course content is in line with the certification program and helps you clear the certification exam with ease and get the best jobs in top MNCs.

As part of this training, you will be working on real-time projects and assignments that have immense implications in the real-world industry scenarios, thus helping you fast-track your career effortlessly.

At the end of this training program, there will be a quiz that perfectly reflects the type of questions asked in the certification exam and helps you score better marks.

Intellipaat Course Completion Certificate will be awarded upon the completion of the project work (after the expert review) and upon scoring at least 60% marks in the quiz. Intellipaat certification is well recognized in top MNCs like Ericsson, Cisco, Cognizant, Sony, Wipro, Standard Chartered, TCS, Genpact, Tata Communication, etc.

view more
Read Less Certification

Oracle PL/SQL Training Reviews

view more
View Less Reviews Video
  1. Profile photo of prakash.dhurde181085 Prakash Dhurde 

    Thank you Intellipaat

    It is only because of Intellipaat that even a beginner like me can confidently appear interviews for getting into the best companies. The online training class was completely worth the investment. Thank you!

  2. Profile photo of harry poul Harry Poul 

    Very good online platform

    I think the course is doing an excellent job in giving a comprehensive understanding of each topic and putting emphasis on most important questions. This training gives you deep knowledge of the course.

  3. Raksha 

    Good course

    Thanks. A very good course to achieve the Oracle DB basic knowledge.

  4. Profile photo of john wilson john wilson 

    valuable content

    This is probably one of the best courses I have ever done. I think the course is doing an excellent job in giving a comprehensive understanding of each topic.

  5. Profile photo of Anjali Srivastava Anjali Srivastava 

    Well-produced content

    It was a very informative course with well-produced content. It was also enjoyable and well segmented.

  6. Profile photo of Vikram seth Vikram seth 

    Awesome course

    The Oracle PL/SQL training course is awesome, and I really found it interesting to learn PL/SQL.

Frequently Asked Questions on Oracle PL SQL

Why should I learn PL/SQL from Intellipaat?

Intellipaat provides industry-leading PL/SQL training. This comprehensive PL/SQL training will help you master the creation, implementation and management of very large database applications. You will learn PL/SQL programming, procedural language, creating subprograms and understand section and syntax query and Data Manipulation Language. The entire training is aimed towards clearing the Oracle PL/SQL Developer Certified Associate exam.

You will be working on real-time projects and step-by-step assignments that have high relevance in the corporate world, and the course curriculum is designed by industry experts. Upon the completion of the training course, you can apply for some of the best jobs in top MNCs around the world at top salaries. Intellipaat offers lifetime access to videos, course materials, 24/7 support and course material upgrading to the latest version at no extra fee. Hence, it is clearly a one-time investment.

What are the different modes of training that Intellipaat provides?
At Intellipaat you can enroll either for the instructor-led online training or self-paced training. Apart from this Intellipaat also offers corporate training for organizations to upskill their workforce. All trainers at Intellipaat have 12+ years of relevant industry experience and they have been actively working as consultants in the same domain making them subject matter experts. Go through the sample videos to check the quality of the trainers.
Can I request for a support session if I need to better understand the topics?
Intellipaat is offering the 24/7 query resolution and you can raise a ticket with the dedicated support team anytime. You can avail the email support for all your queries. In the event of your query not getting resolved through email we can also arrange one-to-one sessions with the trainers. You would be glad to know that you can contact Intellipaat support even after completion of the training. We also do not put a limit on the number of tickets you can raise when it comes to query resolution and doubt clearance.
Can you explain the benefits of the Intellipaat self-paced training?
Intellipaat offers the self-paced training to those who want to learn at their own pace. This training also affords you the benefit of query resolution through email, one-on-one sessions with trainers, round the clock support and access to the learning modules or LMS for lifetime. Also you get the latest version of the course material at no added cost. The Intellipaat self-paced training is 75% lesser priced compared to the online instructor-led training. If you face any problems while learning we can always arrange a virtual live class with the trainers as well.
What kind of projects are included as part of the training?
Intellipaat is offering you the most updated, relevant and high value real-world projects as part of the training program. This way you can implement the learning that you have acquired in a real-world industry setup. All training comes with multiple projects that thoroughly test your skills, learning and practical knowledge thus making you completely industry-ready. You will work on highly exciting projects in the domains of high technology, ecommerce, marketing, sales, networking, banking, insurance, etc. Upon successful completion of the projects your skills will be considered equal to six months of rigorous industry experience.
Does Intellipaat offer job assistance?
Intellipaat actively provides placement assistance to all learners who have successfully completed the training. For this we are exclusively tied-up with over 80 top MNCs from around the world. This way you can be placed in outstanding organizations like Sony, Ericsson, TCS, Mu Sigma, Standard Chartered, Cognizant, Cisco, among other equally great enterprises. We also help you with the job interview and résumé preparation part as well.
Is it possible to switch from self-paced training to instructor-led training?
You can definitely make the switch from self-paced to online instructor-led training by simply paying the extra amount and joining the next batch of the training which shall be notified to you specifically.
How are Intellipaat verified certificates awarded?
Once you complete the Intellipaat training program along with all the real-world projects, quizzes and assignments and upon scoring at least 60% marks in the qualifying exam; you will be awarded the Intellipaat verified certification. This certificate is very well recognized in Intellipaat affiliate organizations which include over 80 top MNCs from around the world which are also part of the Fortune 500 list of companies.
Will The Job Assistance Program Guarantee Me A Job?
In our Job Assistance program we will be helping you land in your dream job by sharing your resume to potential recruiters and assisting you with resume building, preparing you for interview questions. Intellipaat training should not be regarded either as a job placement service or as a guarantee for employment as the entire employment process will take part between the learner and the recruiter companies directly and the final selection is always dependent on the recruiter.
view more
Read Less FAQ
Self-paced
$97
Lifetime Access and 24/7 Support
You have of $0 in your cart.
Online Classroom
$400

$237

15

Dec
Sat & Sun
8 PM IST (GMT +5:30)

21

Dec
Sat & Sun
8 PM IST (GMT +5:30)

28

Dec
Sat & Sun
8 PM IST (GMT +5:30)
Drop Us a Query

Call Us

Training in Cities: Bangalore, Hyderabad, Chennai, Delhi, Kolkata, UK, London, Chicago, San Francisco, Dallas, Washington, New York, Orlando, Boston

Training in Cities: Bangalore, Hyderabad, Chennai, Delhi, Kolkata, UK, London, Chicago, San Francisco, Dallas, Washington, New York, Orlando, Boston

Select Currency
}

Sign Up or Login to view the Free Oracle PL/SQL Training and Certification course.