Courses Courses Arts and Design Arts and Design Animation Graphic Arts Photography Web Design Business Business Accounting Administrative Communication Finance Marketing and Sales Operations Project Management Small Business Soft Skills Career Online High School Career Online High School Online High School Diploma Computer Applications Computer Applications Autodesk Microsoft QuickBooks Windows Computer Science Computer Science Programming Construction and Trades Construction and Trades Construction Environmental and Energy Trades Health and Fitness Health and Fitness Alternative Medicine Dental Fitness Medical Veterinary Wellness Hospitality Hospitality Hospitality Service Information Technology Information Technology Cloud Computing Networking Other Security Language Language Languages Legal Legal Legal Studies Math and Science Math and Science Mathematics and Science Teacher Professional Development Teacher Professional Development Child Development Classroom Technology Math and Science Reading and Writing Test Prep Test Prep Exam Prep Writing Writing Writing and Editing Skill Map Resources Resources About ed2go Externship Programs Financial Assistance Find a School Blog MyCAA

CONTACT US

(855) 520-6806

See all results for ""

See All Courses

ed2go Computer Science Artificial Intelligence Oracle PL/SQL Training
Return to Artificial Intelligence
oracle-pl-sql-training

Oracle PL/SQL Training

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.

6 Months / 70 Course Hrs
Open enrollment

Offered in Partnership with your Preferred School

ed2go

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

Learning Method

Self-Paced

No instructor. Study on your own schedule

Oracle PL/SQL Training

Details + Objectives

Course Code: T9791

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 the course is taught
  • Self-paced, online course
  • 6 months to complete
  • Open enrollment, begin anytime
  • 70 course hours
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

Outline

Expand All
Details
I. PL/SQL Basics
II. Subprograms
III. Conditional Processing
IV. Cursors
V. Packages
VI. Triggers
Requirements

Requirements

Prerequisites:

Prior to enrolling in this course, it is recommended that you have an intermediate understanding of SQL or take the Oracle SQL Training course.

Requirements:

Hardware Requirements:

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

Software Requirements:

  • Windows 7 or later.
  • 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. Click here to download the Acrobat Reader.
  • Software must be installed and fully operational before the course begins.

Other:

  • Email capabilities and access to a personal email account.
Instructional Materials

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

FAQs

Expand All
When can I get started?

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

How does it work?

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

How long do I have to complete each lesson?

There is no time limit to complete each lesson, other than completing all lessons before your six-month access.

What if I need an extension?

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

Browse All