PL/SQL Programming  «Prev  Next»

Lesson 1

Introduction to Oracle PL/SQL Programming

Welcome to the second course in the Introduction to Oracle Certification Series, Programming in PL/SQL.
As the name implies, this series focuses on preparing you for certification in Oracle.

What is this series about?

The information covered in this series helps you get started on the Oracle Certified Database Administrator and/or Certified Application Developer paths. Another important goal of this series is to enable you to
  1. create advanced SQL queries,
  2. write beginning to intermediate PL/SQL blocks, and
  3. familiarize you with Oracle's unique SQL extensions.
PL/SQL is an integral part of the Oracle database engine.
This course will introduce you to PL/SQL and explain how you can build PL/SQL programming structures. PL stands for Procedural Language.
This language offers procedural techniques to build your SQL (Structured Query Language) commands.
You can use this language to construct procedures, triggers, functions, packages, and more.

Course goals

After completing the course, you will be able to:
  1. Describe the basic structure of a PL/SQL block
  2. Create a nested PL/SQL block
  3. Describe the different PL/SQL and non-PL/SQL variables
  4. Identify the scope of variables when using nested blocks
  5. Apply best practices for naming conventions and commenting your code
  6. Gain an overview of the different PL/SQL datatypes, including composite datatypes such as PL/SQL RECORD and TABLE
  7. Place identifiers and use literals and operators within a PL/SQL block
  8. Build logic by using PL/SQL control structures, including loops, labels, and the GOTO statement
  9. Use explicit cursors to process multiple records
  10. Raise implicit and explicit exceptions

Learning Technologies

In this course, you will learn and practice PL/SQL skills with MouseOvers and Slide Shows.

Oracle Series

Programming in PL/SQL is the second of three courses in the Introduction to Oracle Certification Series. In the next lesson, the Oracle PL/SQL Course Requirements will be discussed.