Oracle SQL and PL/SQL Developer

Oracle SQL and PL/SQL Developers build applications or generate business reports using Structured Query Language (SQL)

About This Program

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.

Become an Oracle SQL and PL/SQL Developer

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.

Enroll Now

SQL Developer jobs can vary based on the state, city, county, and grade level you choose to work in.
SQL Developer jobs can vary based on the state, city, county, and grade level you choose to work in.
What is a SQL Developer?

SQL Developers are basically Database Administrators or Database Architects.

SQL development uses a programming language known as Structured Query Language (SQL) to create SQL databases, thus developers who use this particular programming language are known as SQL developers.

 

.

Set yourself apart from competitors by taking a challenging course in PL/SQL development
Set yourself apart from competitors by taking a challenging course in PL/SQL development

Database Administrators/ Architect Job Outlook

Many database architects and administrators work for businesses that offer computer design services or in industries with big databases, like educational institutions and insurance companies.

Most of these developers typically have full-time jobs in office settings, but many work from home as well.

 

In addition to education and region, factors such as specialty, industry, and employer also influence a SQL Developer salary.
In addition to education and region, factors such as specialty, industry, and employer also influence a SQL Developer salary.

Database Administrator/ Architect Salary Expectations

In 2021, the average Database Administrator/Architect made:

  • an average hourly wage of $46.21
  • an average yearly salary of $96,110

The top 4 States with the highest employment level in Database Administrator/ Architect are:

  1. California
  2. Texas
  3. New York and,
  4. Florida

U.S. Bureau of Labor Statistics

 

This course will provide you with the skills you need to obtain an entry-level position in most cases.
This course will provide you with the skills you need to obtain an entry-level position in most cases.

Database Administrator/ Architect Frequently Asked Questions (F.A.Qs)

Q: Does this course prepare me for a certification?
A: This course does not prepare you for a certification, but prepares you to enter the job market as an entry-level Oracle SQL Developer.

Q: When can I start this course? How long does it take to complete this course?
A: This course is self-paced and open enrollment, so you can start when you want and finish at your own pace. When you register, you'll receive six (6) months to complete the course. The time allotted for course completion has been calculated based on the number of course hours. However, if you are unable to complete the course, contact the student advising team to see what options you may have available to work out a suitable completion date. Please note that an extension fee may be charged.

Course Details

 

What you will learn

  • 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

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

 

  1. Oracle SQL and PL/SQL Developer
    1. Oracle SQL
    2. Relational Database Basics
    3. Creating Tables
    4. Basic Selects
    5. Oracle SQL Functions
    6. Aggregate Functions
    7. Joins
    8. Subqueries
    9. Set Operators
    10. Conditional Processing with CASE
    11. Data Manipulation Language
    12. Creating Views
  2. Oracle PL/SQL
    1. PL/SQL Basics
    2. Subprograms
    3. Conditional Processing
    4. Exceptions
    5. Cursors
    6. Packages
    7. Triggers
  3. Oracle SQL Developer Final Project

Nat Dunn

Nat Dunn founded Webucator in 2003 to combine his passion for technical training with his business expertise and to help companies benefit from both. His previous experience was in sales, business and technical training, and management. Nat has an MBA from Harvard Business School and a B.A. in International Relations from Pomona College.

placeholder

Take Your Education and Career to the Next Level!

Office of Continuing Education and Professional Development

Florida Agricultural and Mechanical University
668 Robert and Trudie Perkins Way
Tallahassee, FL 32310

P: (850) 599-3796, E: famuce@famu.edu


CEPD Home
More Certificate Programs