Easy to follow introduction to PL SQL Oracle programming

The primary objective of this course is to introduce you to the Oracle plsql programming language fast and to give you the practical skills to be productive as a web developer working with Oracle databases.

In the course you will be introduced to variety of fundamental PL SQL functions like:

How to declare and use PL/SQL Variables

How to create functions and procedures

Use PL/SQL packages to group and contain related objects

Handle run time errors using Exceptions

And much much more...

By the end of the course I will give you practical exercises for you to do to test out your new PL/SQL skills in real time.

You will learn everything you need to jumpstart your PL/SQL programming learning.

WHAT IS PL/SQL (AND WHY IS IT IMPORTANT?)

PL/SQL is a block structured language that can contain any number of nested sub-blocks. Pl/SQL stands for "Procedural Language extension of SQL" that is used in Oracle. Although PL/SQL is closely integrated with SQL language, it adds some programming constraints that are not available in SQL.