Course Offerings

The job market for professionals with Structured Query Language (SQL) skills is experiencing a robust and growing demand across a variety of industries, making now a great time to pursue training in this field. For example, Indeed reports that the average salary for a SQL developer is $92,295 per year in the U.S.

This online Oracle SQL course teaches you how to use SQL to build applications or generate business reports and helps you master SQL using an Oracle database. In the Oracle PL/SQL training module, you also learn how to use the PL/SQL extension language to write sophisticated queries against an Oracle database.

Designed for those new to writing SQL queries, this course is perfect for those who love to learn and like working with data. You cover essential topics such as relational database basics, table creation and data manipulation language. The curriculum focuses on helping you learn and apply key concepts, including SQL functions, joins, subqueries and PL/SQL programming techniques like subprograms and triggers. By the end of this Oracle training program, you will apply your knowledge in a final SQL-focused project.

Your training concludes with you learning advanced concepts such as AI-assisted coding, which enables developers to enhance productivity and efficiency using tools like ChatGPT and other AI resources. Prepare to enter the job market as an entry-level Oracle SQL developer or take on more responsibility within your current career!

Course Objectives

Build applications or generate business reports using Structured Query Language (SQL)

Use PL/SQL extension language to write sophisticated queries against an Oracle database

Outline of Instruction

Oracle SQL and PL/SQL Developer

Oracle PL/SQL

Oracle SQL Developer Final Project

AI-Assisted Oracle

Contact Hours

150

CEUs

No

Industry Standard, State or National Certification

Certification

None

Website

None

Certification Learning Outcomes/Requirements

CE or CU Articulation

No

Prerequisites

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

Learning Supplies Needed

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.

Clinical Site/Special Facilities

N/A

Requirements for Successful Completion

85% attendance

Accreditation/Special Approval Requirements

N/A

Intended Audience

Specific Industry or Business Support Needs

N/A

Wake County Need for Industry Positions

N/A

Industry or Job Titles Related to Training Outcomes for Employment

Related Courses

Course Contact Information

Courtney Boney
919-532-5581
[email protected]