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.

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

Course Overview

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.

Course Outcomes

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

Course Outline

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.

Prerequisites

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

Certification Exam

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

Instructor Support

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.

Technology Requirements

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.