Oracle PL/SQL Fundamentals - Part 1

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.
Course info
Rating
(641)
Level
Beginner
Updated
Mar 3, 2014
Duration
4h 27m
Table of contents
Course Introduction
Anonymous Blocks
PL/SQL Commonly Used Datatypes
Loops
Conditional Execution
Cursors
Exceptions
Debugging
Description
Course info
Rating
(641)
Level
Beginner
Updated
Mar 3, 2014
Duration
4h 27m
Description

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.

Course FAQ
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.

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
About the author

Experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development.

More from the author
Oracle REST Data Services
Beginner
5h 30m
Feb 13, 2018
Getting Productive with SQL Developer
Beginner
3h 53m
Apr 20, 2017
More courses by Pankaj Jain