In this course 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.
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?
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.