Loading...

Course Description

Take your SQL query skills to a new level by learning how to write more advanced SQL queries for enhanced decision making. In this course, you will learn how to write advanced subqueries, advanced join queries, and UNION queries that query more than one table. You will learn how to use transaction processing to ensure SQL statements execute completely or not at all and how to create stored procedures that enable you to store SQL statements for execution.                                                

Course Outline

  • Creating Advanced Subqueries
  • Creating Advanced Joins
  • Creating Union Queries
  • Transaction Processing, Stored Procedures, Triggers
For more information click here.                                                                                                 

Notes

* InstructorDr. 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 and Intermediate levels of SQL.

    ONCE1187: Introduction to SQL
    ONCE1188: Intermediate SQL                                                                                                                                         

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Advanced SQL
Type
Online, self paced
Dates
Jul 07, 2025 to Aug 01, 2025
Delivery Options
Course Fee(s)
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
Advanced SQL
Type
Online, self paced
Dates
Aug 04, 2025 to Aug 29, 2025
Delivery Options
Course Fee(s)
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
Advanced SQL
Type
Online, self paced
Dates
Sep 02, 2025 to Sep 26, 2025
Delivery Options
Course Fee(s)
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
Advanced SQL
Type
Online, self paced
Dates
Oct 06, 2025 to Oct 31, 2025
Delivery Options
Course Fee(s)
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.
Section Title
Advanced SQL
Type
Online, self paced
Dates
Nov 03, 2025 to Nov 28, 2025
Delivery Options
Course Fee(s)
Section Notes
  • Instructor: Cecelia Allison
  • Course Format: Virtual, self-guided.
  • Course Duration: November 3-28, 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
Advanced SQL
Type
Online, self paced
Dates
Dec 01, 2025 to Dec 26, 2025
Delivery Options
Course Fee(s)
Section Notes
  • Instructor: Cecelia Allison
  • Course Format: Virtual, self-guided.
  • Course Duration: December 1-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.