In this Learning Oracle PL/SQL training course, expert author Darryl Hurley will teach you how to write solid and secure code. This course is designed for users that already have a basic understanding of Oracle PL/SQL.
You will start by learning the basics, including block structure, scalar variables, nested tables, and loops. From there, Darryl will teach you about errors, data manipulation, and database procedure. This video tutorial also covers packages, triggers, and functions. You will also learn about code compilation, code assessment, security, and dynamic SQL. Finally, you will learn about Data Definition Language (DDL), transactions, and PL/SQL in SQL.
Once you have completed this computer based training course, you will have learned everything you need to know to be able to write effective code with PL/SQL. Working files are included, allowing you to follow along with the author throughout the lessons.