Mastering PL/SQL

Master PL/SQL and become a database expert.

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Dr. Parteek Bhatia

architecture icon Teaching & Academics,Online Education,PL/SQL


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

No application in the modern era is possible without utilizing databases. Experts in databases are in greater demand everywhere in the world. And this course aims to close that gap. The purpose of this PL/SQL course is to better prepare learners for their academic and professional endeavors. 

Mastering PL/SQL Overview

You will learn to use PL/SQL statements to build business logic using Cursors, Procedures, Functions, and Triggers in this course. To make learning engaging and interesting, several examples are used to illustrate each of these principles.

The course's key merit is that it clearly explains each concept using real-world examples. It is designed for beginners and will help them advance from being a PL/SQL novice to an expert. Learners will master PL/SQL in this course using Oracle, the most popular database software worldwide.


What will you learn in this course:

  • Prepare for DBMS.

  • Learn the basics of PL/SQL, from its syntax and concepts to its advanced features.

  • Develop skills needed to use PL/SQL to build business logic, such as using cursors, procedures, functions, and triggers.

  • Prepare for a career in database development or other related fields.


What are the prerequisites for this course?

  • Basic understanding of SQL.

Mastering PL/SQL


Check out the detailed breakdown of what’s inside the course

Basics of PL/SQL
6 Lectures
  • play icon PL/SQL Introduction 07:29 07:29
  • play icon Architecture of PL/SQL 03:27 03:27
  • play icon PL/SQL Language Elements 05:26 05:26
  • play icon Structure of PL/SQL Block 02:54 02:54
  • play icon Demonstartion of Live SQL (Software used for execution of code) 04:03 04:03
  • play icon Reading Material for Section-1
6 Lectures
Conditional, Looping and Sequential Statements.
8 Lectures
Exception Handling
12 Lectures
Cursor Handling
14 Lectures
Sub Programs
15 Lectures
16 Lectures

Instructor Details

Dr. Parteek Bhatia

Dr. Parteek Bhatia

Simplifying Computer Education

Dr. Parteek Bhatia is Associate Professor in the Department of Computer Science and Engineering and Former Associate Dean of Student Affairs at Thapar Institute of Engineering and Technology, Patiala. He is currently on sabbatical for Post doctorate at Tel Aviv University, Tel Aviv, Israel.

He is recipient of Young Faculty Research Fellowship from Ministry of Electronics & Information Technology, Govt. of India. He has more than twenty years of academic experience, including six years at D.A.V College Amritsar.

He has earned his B.Tech from SLIET and MS from BITS Pilani. He is doctorate in the field of NLP from Thapar University. He is PhD title is “UNL Based Machine Translation System for Punjabi Language”.

He has published more than 100 research papers and articles in Journals, Conferences and Magazines of repute. His research work with UNDL foundation, Geneva, Switzerland involved participation in Advanced UNL School at Alexandria, EGYPT in 2012 and at Geneva, Switzerland in 2013 and 2014.

He is a winner of Gold Medal at International competition UNL Olympiad II,UNL Olympiad III and UNL Olympiad IV conducted by UNDL Foundation in year 2013 and 2014.

He is well known author and published text books in the field of Databases and Data Mining. His latest book titled “Data Mining and Data Warehousing: Principles and Practical Techniques” Published by Cambridge University Press in 2019. He is a author of popular books like “Simplified Approach to DBMS”, “Simplified Approach to Visual Basic” and “Simplified Approach to Oracle” and “NoSQL in a Day”.

He has handled research projects of more than one crore rupees sponsored by International and National funding agencies. He is acting as Principal Investigator of DST Funded research project on “Automatic Generation of Sign Language from Hindi Text for Communication and Education of Hearing Impaired people”.

He has completed Royal Academy of Engineering (UK) funded research project on “Innovative Research in Pedagogy with Mini-MOOCs blended with instruction strategies to enhance quality in Higher Education” as Co-PI. He has successfully completed research Project on Development of Indradhanush: An Integrated WordNet for Bengali, Gujarati, Kashmiri, Konkani, Oriya, Punjabi and Urdu Sponsored By Department of Information Technology, Ministry of Communication and Information Technology, Govt. of India.

He is passionate about teaching masses through modern platforms like MOOCs. He has more than 15,000 students on his very popular Udemy Course on “Learning SQL: A Simplified Approach”. He is also running his YouTube Channel “Parteek Bhatia: Simplifying Computer Education” for sharing video sessions on Machine Learning, Big Data, DBMS, SQL, PL/SQL and NoSQL.

He has research interest in area of NLP, Machine Learning and Assistive Technologies. He is member of IEEE, ACM and ISTE.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best



Ashok Kumar.R

very good


Mohd Khairil Rajaie Bin Mohd Khairon

Thank you!

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us