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. 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 Calculated Fields and using Aggregate Functions
Structured Query Language Review
Creating calculated fields
Concatenating columns
Using aggregate functions - Using Clauses in Structured Query Language
Using the ORDER BY clause
Using the GROUP BY clause
Using the GROUP BY clause and WHERE clause
Using the HAVING clause - Creating Table Joins
Creating Inner joins
Creating Outer joins
Creating Self joins - Creating Subqueries
Creating subqueries
Creating subqueries that contain calculated fields
Creating subqueries that contain aggregate functions
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 | ||
|---|---|---|---|---|---|
| 12250 |
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 | ||
|---|---|---|---|---|---|
| 22497 |
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 | ||
|---|---|---|---|---|---|
| 22498 |
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 | ||
|---|---|---|---|---|---|
| 22499 |
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 | ||
|---|---|---|---|---|---|
| 22500 |
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 | ||
|---|---|---|---|---|---|
| 22587 |
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 | ||
|---|---|---|---|---|---|
| 22588 |
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 | ||
|---|---|---|---|---|---|
| 22589 |
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 | ||
|---|---|---|---|---|---|
| 22590 |
May 4, 2026 to May 29, 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.