Oracle SQL & PL/SQL Developer Course

Become Oracle Certified and expand your IT job opportunities.

Quick Details

Towson University’s self-paced 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.

Course Format: Self-paced, online

Total Hours: 120 hours

Program Duration: Must be completed in 12 months

Tuition: $1,999

This course is delivered by our education partners at Ed2Go.

Set up a 15 minute meeting to chat about this course.

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 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.

Students are supported by both an assigned instructor and assigned advisor throughout the duration of the course. Students receive contact information for both upon enrollment and all communication is handled via email. Students should allow up to two business days for responses.

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.

*NOTE: WIOA and other tuition assistance programs are not eligible for course discounts.