Oracle PL/SQL Training

Learn to use PL/SQL to write sophisticated queries against an Oracle database.
SHARE
6 Months / 70 Course Hrs
Open Enrollment
Offered in partnership with your preferred school

ed2go

Why this school?The school has been chosen based on your location or if you've visited this school's website.Change School
Learning method

Course code: T9791

This self-paced SQL training course is perfect for advancing your current SQL skills. While Oracle uses a standard SQL like other major databases, PL/SQL is specific to Oracle. PL/SQL is a procedural language with variables, conditions, loops, subprograms, stored procedures, and functions. By course completion, you will understand and know how to use PL/SQL's main features, including declaring, naming, and assigning variables.

What you will learn

  • How to write a simple block of PL/SQL code and about subprograms in PL/SQL.
  • To create and call procedures and functions.
  • To write IF conditions, to use the CASE statement and to handle exceptions in PL/SQL.
  • To use implicit and explicit cursors.
  • To use triggers for validating data and auditing changes to the database.

How you will benefit

  • Gain skills that every developer needs
  • Bring your advanced SQL/PL skills to any web development job
  • Advance your career as an Oracle developer

What you will learn

  • How to write a simple block of PL/SQL code and about subprograms in PL/SQL
  • To create and call procedures and functions
  • To write IF conditions, use the CASE statement, and handle exceptions in PL/SQL
  • To use implicit and explicit cursors
  • To use triggers for validating data and auditing changes to the database

How you will benefit

  • Gain skills that every developer needs
  • Bring your advanced SQL/PL skills to any web development job
  • Advance your career as an Oracle developer

How the course is taught

  • Self-paced, online course
  • 6 Months access
  • 70 course hours
  1. PL/SQL Basics
  2. Subprograms
  3. Conditional Processing
  4. Cursors
  5. Packages
  6. Triggers

Prior to enrolling in this course, we recommend having an intermediate understanding of SQL or taking the Oracle SQL Training course.

Hardware Requirements:

  • This course must be taken on a PC. Macs are not compatible.

Software Requirements:

  • Windows 8 or newer.
  • Oracle Database Express Edition (XE) 12c or 18c - Free edition of Oracle RDBMS.
  • Oracle SQL Developer - The client interface for connecting to Oracle. (Software not included)
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
  • Adobe Acrobat Reader.
  • Software must be installed and fully operational before the course begins.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

You can start this course at any time your schedule permits.

You have 6 month access to the course. After enrolling, you can learn and complete the course at your own pace, within the allotted access period.

There is no time limit to complete each lesson, other than completing all lessons within the allotted access period.

Because this course is self-paced, no extensions will be granted after the start of your enrollment.