Skip to content

SQL Certificate (Online at your own pace)


Adult Enrichment / Computers & Technology -
Online Certificates and Courses 2025

Structured Query Language (SQL) is the industry standard database programming language. It is one of the most in demand skills in occupations that require interaction with data and analyzing data. Through your knowledge of Structured Query Language, you will become more marketable in computer related career fields that pertain to database administration. Learning SQL can also lead to a job that is specific to analyzing data such as a data analyst, a quality assurance analyst, or a business analyst. You’ll first learn about relational database structures, the history and uses of Structured Query Language, and how to use Structured Query Language to create a database, add records to database tables, and how to use SQL queries to extract meaningful data from database tables. You will quickly progress from creating simple SQL queries that query a single table to querying multiple tables simultaneously. You’ll also learn how to alter data in a database and how to gather significant statistics from data stored in a database. Finally, you'll learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. This certificate will enhance your competitiveness in the field of database administration and data analyst jobs. 

Requirements:

  • Windows 8 or later. Macs are not compatible.
  • Necessary rights (local administrative rights) to install programs on the computer.

This Certificate must be taken in the following order:

  1. Introduction
  2. Intermediate
  3. Advanced

Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ


Class Details:
Introduction to SQL
Unit 1: The Relational Database and Structured Query Language
    The relational database structure
    Structured Query Language
    Table creation and data insertion
    Defining datatypes and constraints
    Creating Indexes


Unit 2: Table Management
    Table management
    Adding columns to a table
    Deleting columns from a table
    Deleting a table

Unit 3: Selecting and Retrieving Data
    Creating a SELECT statement to retrieve data
    Using DISTINCT to display unique values in a column
    Using the AS keyword to create an alternate name for a column
    Merging columns
Unit 4: Filtering Data
    Creating a WHERE clause
    Using comparison, character, and logical operators to match conditions
    Using the IN operator to match a condition
    Using the BETWEEN operator to match a condition
Intermediate SQL
Unit 1: The Relational Database and Structured Query Language
    The relational database structure
    Structured Query Language
    Table creation and data insertion
    Defining datatypes and constraints
    Creating Indexes
Unit 2: Table Management
    Table management
    Adding columns to a table
    Deleting columns from a table
    Deleting a table
Unit 3: Selecting and Retrieving Data
    Creating a SELECT statement to retrieve data
    Using DISTINCT to display unique values in a column
    Using the AS keyword to create an alternate name for a column
    Merging columns
Unit 4: Filtering Data
    Creating a WHERE clause
    Using comparison, character, and logical operators to match conditions
    Using the IN operator to match a condition
    Using the BETWEEN operator to match a condition
Advanced SQL
Unit 1: Creating Advanced Subqueries
    Structured Query Language Review
    Using the IN keyword to link queries
    Using the EXISTS keyword to link queries
    Using the ANY keyword to link queries
    Using the ALL keyword to link queries
Unit 2: Creating Advanced Joins
    Creating inner joins review
    Creating outer joins review
    Creating joins with aggregate functions
    Creating nested joins
Unit 3: Creating Union Queries
    Creating UNION queries
    Creating UNION ALL queries
    Creating a WHERE clause and multiple UNION queries
Unit 4: Transaction Processing, Stored Procedures, Triggers
    Implementing transaction processing
    Implementing stored procedures
    Implementing triggers
Instructor

Cecelia Allison


Dr. Cecelia Allison is a course developer, published author, technical writer, and an online professor with more than 20 years of hands-on experience using and teaching SQL. She has taught over 90,000 students SQL worldwide. Through her past employment as a technical specialist, software tester, and teaching SQL, she has gained extensive experience in writing and implementing SQL. She holds a Bachelor of Science in Finance, a Master of Science in Information Systems, and a Doctor of Business Administration in Management Information Systems.

Filter Course Sections

Date Range
Start
End
Time Range
Start
End
OE-62130a-ugc
Min Age   18 yr.
Su
M
Tu
W
Th
F
Sa
Cecelia Allison
Price: $ 595 00
Online
Feb 3 - May 2
12:01 AM - 11:59 AM
OE-62130b-ugc
Min Age   18 yr.
Su
M
Tu
W
Th
F
Sa
Cecelia Allison
Price: $ 595 00
Online
Mar 3 - May 30
12:01 AM - 11:59 AM
Registration begins
Jan. 7th
Enroll
Now
OE-62130c-ugc
Min Age   18 yr.
Su
M
Tu
W
Th
F
Sa
Cecelia Allison
Price: $ 595 00
Online
Apr 7 - Jun 27
12:01 AM - 11:59 AM
Registration begins
Jan. 7th
Enroll
Now
OE-62130d-ugc
Min Age   18 yr.
Su
M
Tu
W
Th
F
Sa
Cecelia Allison
Price: $ 595 00
Online
May 5 - Aug 1
12:01 AM - 11:59 AM
Registration begins
Jan. 7th
Enroll
Now
OE-62130e-ugc
Min Age   18 yr.
Su
M
Tu
W
Th
F
Sa
Cecelia Allison
Price: $ 595 00
Online
Jun 2 - Aug 29
12:01 AM - 11:59 AM
Registration begins
Jan. 7th
Enroll
Now
OE-62130f-ugc
Min Age   18 yr.
Su
M
Tu
W
Th
F
Sa
Cecelia Allison
Price: $ 595 00
Online
Jul 7 - Sep 26
12:01 AM - 11:59 AM
Registration begins
Jan. 7th
Enroll
Now
OE-62130g-ugc
Min Age   18 yr.
Su
M
Tu
W
Th
F
Sa
Cecelia Allison
Price: $ 595 00
Online
Aug 4 - Oct 31
12:01 AM - 11:59 AM
Registration begins
Jan. 7th
Enroll
Now
OE-62130h-ugc
Min Age   18 yr.
Su
M
Tu
W
Th
F
Sa
Cecelia Allison
Price: $ 595 00
Online
Sep 2 - Nov 28
12:01 AM - 11:59 AM
Registration begins
Jan. 7th
Enroll
Now
OE-62130i-ugc
Min Age   18 yr.
Su
M
Tu
W
Th
F
Sa
Cecelia Allison
Price: $ 595 00
Online
Oct 6 - Dec 26
12:01 AM - 11:59 AM
Registration begins
Jan. 7th
Enroll
Now