Loading...

Course Description

Discover how to write powerful SQL queries that enable you to retrieve data from one table or from multiple tables stored in the database simultaneously. In this course, you will learn how to retrieve more meaningful data from one or more tables stored in a database. You will learn how to merge data from multiple columns, how to create calculated fields, and how to order and group the results from a query. You will also learn how to create a single join query or subquery to obtain data from multiple tables simultaneously.                                                                             

Course Outline

  • Creating Calculated Fields and using Aggregate Functions
  • Using Clauses In SQL
  • Creating Table Joins
  • Creating Subqueries

For more information click here.                                                    

Notes

Instructor: Dr. Cecelia Allison

* Requirements:

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

- Students should have a competency in the Introductory level of SQL.

    ONCE1187: Introduction to SQL
 

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Intermediate SQL
Type
Online, self paced
Dates
Jul 07, 2025 to Aug 01, 2025
Delivery Options
Online  
Course Fee(s)
Course Fee $245.00 Click here to get more information
CEUs
1.6 CEUs
Section Notes
  • Instructor: Cecelia Allison
  • Course Format: Virtual, self-guided.
  • Course Duration: July 7 to August 1. 2025
  • Access to Course: An invitation into the online classroom will be emailed to you typically the Wednesday prior to the start of the course. If you haven’t received the invite by the following morning, you can forward the confirmation email to info@ugotclass.org for a prompt resend.
Section Title
Intermediate SQL
Type
Online, self paced
Dates
Aug 04, 2025 to Aug 29, 2025
Delivery Options
Online  
Course Fee(s)
Course Fee $245.00 Click here to get more information
CEUs
1.6 CEUs
Section Notes
  • Instructor: Cecelia Allison
  • Course Format: Virtual, self-guided.
  • Course Duration: August 4-29, 2025
  • Access to Course: An invitation into the online classroom will be emailed to you typically the Wednesday prior to the start of the course. If you haven’t received the invite by the following morning, you can forward the confirmation email to info@ugotclass.org for a prompt resend.
Section Title
Intermediate SQL
Type
Online, self paced
Dates
Sep 02, 2025 to Sep 26, 2025
Delivery Options
Online  
Course Fee(s)
Course Fee $245.00 Click here to get more information
CEUs
1.6 CEUs
Section Notes
  • Instructor: Cecelia Allison
  • Course Format: Virtual, self-guided.
  • Course Duration: September 2-26, 2025
  • Access to Course: An invitation into the online classroom will be emailed to you typically the Wednesday prior to the start of the course. If you haven’t received the invite by the following morning, you can forward the confirmation email to info@ugotclass.org for a prompt resend.
Section Title
Intermediate SQL
Type
Online, self paced
Dates
Oct 06, 2025 to Oct 31, 2025
Delivery Options
Online  
Course Fee(s)
Course Fee $245.00 Click here to get more information
CEUs
1.6 CEUs
Section Notes
  • Instructor: Cecelia Allison
  • Course Format: Virtual, self-guided.
  • Course Duration: October 6-31, 2025
  • Access to Course: An invitation into the online classroom will be emailed to you typically the Wednesday prior to the start of the course. If you haven’t received the invite by the following morning, you can forward the confirmation email to info@ugotclass.org for a prompt resend.