Online Oracle SQL & PL/SQL Developer Course

Become Oracle Certified and expand your IT job opportunities.

Quick Details

Towson University’s online course will teach you how to use SQL to build applications or generate business reports and will help you master SQL using an Oracle database. You will also learn how to use the PL/SQL extension language to write sophisticated queries against an Oracle database.

This course will prepare you to enter the job market as an entry-level Oracle SQL Developer or take on more responsibility within your current career. Designed for those new to writing SQL queries, this course is perfect for those who love to learn and like working with data.

Total Hours: 120-hour course 

Tuition: $1,999

Location: Online

This course is WIOA approved and is on the Maryland Eligible Training Provider List (ETPL).

This course is delivered by our education partners at Ed2Go.

Upcoming Date Schedule REGISTER
Open enrollment. Begin anytime. Set your own. Must be completed within twelve months of registration. Register

Ask us about payment plan options.

Connect with us

Have questions? We have answers.

Request Information

More About This Course

This online course will teach you how to use SQL to build applications or generate business reports and will help you master SQL using an Oracle database. You will also learn how to use the PL/SQL extension language to write sophisticated queries against an Oracle database.

This course will prepare you to enter the job market as an entry-level Oracle SQL Developer or take on more responsibility within your current career. Designed for those new to writing SQL queries, this course is perfect for those who love to learn and like working with data.

By the end of this course, you will be able to:

  • Build applications or generate business reports using Structured Query Language (SQL)
  • Master SQL using an Oracle database
  • Use PL/SQL extension language to write sophisticated queries against an Oracle database  How you will benefit
  • Turn your passion for working with data into a profession by learning to write SQL queries
  • Prepare to enter the job market as an entry-level Oracle SQL Developer or to take on more responsibility in your current role
  • Set yourself apart from competitors by taking a challenging course in PL/SQL development

Module 1: Oracle SQL and PL/SQL Developer

  • Oracle SQL
  • Relational Database Basics
  • Creating Tables
  • Basic Selects
  • Oracle SQL Functions
  • Aggregate Functions
  • Joins
  • Subqueries
  • Set Operators
  • Conditional Processing with CASE
  • Data Manipulation Language
  • Creating Views

Module 2: Oracle PL/SQL

  • PL/SQL Basics
  • Subprograms
  • Conditional Processing
  • Exceptions
  • Cursors
  • Packages
  • Triggers

Module 3: Oracle SQL Developer Final Project

Outlines are subject to change, as courses and materials are updated.

There are no prerequisites for this course; however, some prior programming language knowledge is helpful.

This course does not prepare you for a certification but prepares you to enter the job market as an entry-level Oracle SQL Developer.

Hardware Requirements

  • This course must be taken on a PC.
  • Dual monitors are helpful but are not required.

Software Requirements

  • PC: Windows 10 or later (not the Home Edition).
  • Browser: The latest version of Chrome (preferred), Microsoft Edge, or Firefox browsers.
  • Oracle Database Express Edition (XE) 12c or 18c: Free edition of Oracle RDBMS (download and installation instructions are provided in course). Please view the required specs ahead of time to make sure that your system is compatible.
  • Oracle SQL Developer: The client interface for connecting to Oracle (download and installation instructions are provided in course).
  • Adobe Acrobat Reader

Other

  • Email capabilities and access to a personal email account.

Instructional Material Requirements

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