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. This course is offered in partnership with Learning Education Resource Network - UGotClass. For more information see http://yougotclass.org/index.cfm/VCC
Prerequisites
Missing prerequisites?
Learn more about VCC's academic upgrading or English as a Second Language (ESL) courses, or discover which university transfer options are right for you.
What you will learn
- 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 - Creating Advanced Joins
Creating inner joins review
Creating outer joins review
Creating joins with aggregate functions
Creating nested joins - Creating Union Queries
Creating UNION queries
Creating UNION ALL queries
Creating a WHERE clause and multiple UNION queries - Transaction Processing, Stored Procedures, Triggers
Implementing transaction processing
Implementing stored procedures
Implementing triggers
How to register
This course is offered as part of a VCC program only.
Course schedules
Select your program to see the available course schedules.
| CRN# | Duration | Delivery | Location | ||
|---|---|---|---|---|---|
| 12254 |
April 2, 2026 to April 30, 2026 |
Online | See full schedule |
Online courses listed without scheduled meeting times can be completed on your own schedule.
| CRN# | Duration | Delivery | Location | ||
|---|---|---|---|---|---|
| 22501 |
May 4, 2026 to May 29, 2026 |
Online | Online | See full schedule |
Online courses listed without scheduled meeting times can be completed on your own schedule.
| CRN# | Duration | Delivery | Location | ||
|---|---|---|---|---|---|
| 22502 |
June 1, 2026 to June 26, 2026 |
Online | Online | See full schedule |
Online courses listed without scheduled meeting times can be completed on your own schedule.
| CRN# | Duration | Delivery | Location | ||
|---|---|---|---|---|---|
| 22503 |
July 6, 2026 to July 31, 2026 |
Online | Online | See full schedule |
Online courses listed without scheduled meeting times can be completed on your own schedule.
| CRN# | Duration | Delivery | Location | ||
|---|---|---|---|---|---|
| 22504 |
August 3, 2026 to August 28, 2026 |
Online | Online | See full schedule |
Online courses listed without scheduled meeting times can be completed on your own schedule.
| CRN# | Duration | Delivery | Location | ||
|---|---|---|---|---|---|
| 22591 |
August 3, 2026 to August 28, 2026 |
Online | See full schedule |
Online courses listed without scheduled meeting times can be completed on your own schedule.
| CRN# | Duration | Delivery | Location | ||
|---|---|---|---|---|---|
| 22592 |
July 6, 2026 to July 31, 2026 |
Online | See full schedule |
Online courses listed without scheduled meeting times can be completed on your own schedule.
| CRN# | Duration | Delivery | Location | ||
|---|---|---|---|---|---|
| 22593 |
June 1, 2026 to June 26, 2026 |
Online | See full schedule |
Online courses listed without scheduled meeting times can be completed on your own schedule.
| CRN# | Duration | Delivery | Location | ||
|---|---|---|---|---|---|
| 22597 |
May 4, 2026 to May 30, 2026 |
Online | See full schedule |
Online courses listed without scheduled meeting times can be completed on your own schedule.
Contact us
If you have any question, please email at advising@vcc.ca.
† This information is intended as a guideline only. Program and course details are subject to change with the approval of VCC's Board of Governors.