This course introduces students to PL/SQL, Oracle’s procedural extension language for SQL and the Oracle relational database. Participants explore the differences between SQL and PL/SQL. They also examine the characteristics of PL/SQL and how it is used to extend and automate SQL to administer the Oracle database. This course culminates with a project that challenges students to program, implement, and demonstrate a database solution for a business or organization.

Course Duration : 180 hours

Prerequisites | Required

  •    Previous experience with at least one programming language

Prerequisites | Suggested

  •    Previous Experience with a database application
  •    Oracle Academy Course – Database Design and Database Programming with SQL

  Variables and Datatypes
  Using SQL in PL/SQL
  Cursors and Parameters
  Using Composite Datatypes
  Exception Handling
  Using and Managing Procedures
  Using and Managing Functions
  Using and Managing Packages
  Getting the Best out of Packages
  Improving PL/SQL Performance
  Using and Managing Triggers
  Managing Dependencies
  Using the PL/SQL Compiler
  Using Conditional Compilation
  Hiding Your Source Code

Hands On Exercises

Course Completion Certificate

Live Project

Certification Exam

Suggested Next Courses

  •    Getting Started with Java Using Alice
  •   Creating Java Programs with Greenfoot
  •   Java Fundamentals
  •   Java Programming