Oracle PL/SQL Fundamentals - Part 1

by Pankaj Jain

Get coding quickly and effectively with Oracle PL/SQL, Oracle's database development language. This course is the first of a two part series, covering the essentials and fundamentals of Oracle PL/SQL.

What you'll learn

In this Oracle PL/SQL training, you will learn about the fundamentals of Oracle PL/SQL programming language.

You will gain a solid understanding of PL/SQL datatypes and programming constructs like loops, conditional execution, cursors and exception handling, which will enable you to do effective debugging.

Table of contents

Course FAQ

What is PL/SQL?

PL/SQL stands for "Procedural Language extensions to the Structured Query Language". It is Oracle's database development language. It is a procedural language and an extension of SQL which tells the compiler what to do and how to do it.

What's the difference between SQL and PL/SQL?

The main difference is that SQL executes a single query at a time, while PL/SQL executes an entire block of code at once. PL/SQL is procedural, defining how things need to be done, while SQL is declarative, defining what needs to be done.

What will I learn in this course?

You will learn the essentials and fundamentals of Oracle PL/SQL, including:

  • What is PL/SQL and why learn it?
  • Anonymous blocks
  • Commonly used datatypes in PL/SQL
  • Loops - for loops, while loops, nesting loops, and more
  • Conditional statements - If/else/elseif, etc.
  • Cursors, exceptions, debugging, and more
Are there prerequisites for this course?

This is a beginner course, so you don't need to know much to get started. Because PL/SQL is an extension to SQL, knowing SQL basics would help. Some general programming knowledge would also be helpful, but is not required. If you need a refresher on the Oracle database platform in general then check out this Oracle Database fundamentals course.

Who is this course for?

This course is for anyone who wants to learn Oracle PL/SQL, and anyone who works with large sets of data and wants to become more efficient at understanding it.

About the author

Pankaj Jain is an experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development. He has worked on an array of technologies, with focus on Oracle at the database layer and Java at the web tier. He is a certified Oracle 11g DBA. He lives in Seattle with his wife Simita and boys Ronit and Rohak. When he is not playing with technology, he likes spending time with his kids, travelling and doing photography.

Ready to upskill? Get started