Suncrest College

Overview

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. LERN offers an online SQL Certificate.

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.

Courses

CEUs/ILUs: 4.8

Modules

Introduction to SQL

Learn how to write SQL code to create and populate database tables and how to write simple SQL queries that are capable of retrieving vast amounts of information from a database. In this course, you will discover the power of the relational database, how to create and manage database tables, and how to use SQL SELECT statements to precisely pinpoint and retrieve data from a database.

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

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.

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

Unit 5: Creating Calculated Fields and using Aggregate Functions

Structured Query Language Review
Creating calculated fields
Concatenating columns
Using aggregate functions

Unit 6: 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

Unit 7: Creating Table Joins

Creating Inner joins
Creating Outer joins
Creating Self joins

Unit 8: Creating Subqueries

Creating subqueries
Creating subqueries that contain calculated fields
Creating subqueries that contain aggregate functions

Advanced SQL

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.

Students should have a competency in the Introductory and Intermediate levels of SQL.

Unit 9: 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 10: Creating Advanced Joins

Creating inner joins review
Creating outer joins review
Creating joins with aggregate functions
Creating nested joins

Unit 11: Creating Union Queries

Creating UNION queries
Creating UNION ALL queries
Creating a WHERE clause and multiple UNION queries

Unit 12: Transaction Processing, Stored Procedures, Triggers

Implementing transaction processing
Implementing stored procedures
Implementing triggers

Costs and Fees

Applying Online

Check the program intake information within the intake banner below the program title OR contained with the sidebar of this page, if it matches what you want proceed to step 3; otherwise
Click the Configure Intake link within the intake banner OR sidebar to adjust the intake to your liking
With your desired intake selected, click the Apply for this Intake button to start the application process

Please add GST and PST to the listed tuition.

Details

Application Deadline

September 5, 2025

Start Date

September 2, 2025

Length

48 Hours

Tuition

Domestic: $799.00

Suncrest College delivers customized training the way you need it.

Corporate Training & Continuing Education

In the classroom. Online. On site.
We can even develop a program for you.

Suncrest College

Why Study Here?

Students who attend Suncrest College can expect smaller class sizes and an easier transition. At Suncrest College students typically receive more one-on-one time with instructors. Our staff will know your name not just your student number.

Percent

Higher Averages When Compared to Larger Class Sizes

You are more than just a number, we know you by name

Spend Less

Live where you learn, spend less on the extras

Cancellation Policy

Notice of cancellation must be received 3 business days prior to the course.

Students are considered registered when:

Payment is received
OR
Sponsorship by employer or funding agency is confirmed.

Funding Opportunities Available

Our professional certificate programs may qualify for the Canada Training Credit, Canada-Saskatchewan Job Grant or other sources of funding.

Canada Training Credit

For 2019 and subsequent taxation years, the budget proposes a new refundable tax credit called the Canada training credit, which may be used for eligible tuition and fees paid for courses taken in 2020 and subsequent taxation years.

Find out more

Canada-Saskatchewan Training Grant

The Canada-Saskatchewan Job Grant is now accepting applications from eligible employers, pending available funding.

The Canada-Saskatchewan Job Grant is an employer-driven program that:

Helps businesses and non-profit organizations train new or existing employees for available jobs; and
Provides more opportunities for unemployed and underemployed workers to receive training.
Through the program, the employer contributes one-third of the training cost, while the federal and provincial governments contribute the remaining two-thirds.

Learn more and apply here

Need more Information?

EMAIL US

Contact the Corporate Training Team

306.786.2760

learn.corporatetraining@suncrestcollege.ca

LEARN MORE

Check out these similar offerings

Certificates

Website Coding

Coding is becoming one of the most in-demand skills in the workplace today. As a result, coding has become a core skill that bolsters one’s chances of becoming a higher value to organizations.

Term 1 Online

SQL

SQL

Overview

Courses

Modules

Introduction to SQL

Intermediate SQL

Advanced SQL

Costs and Fees

Applying Online

Details

Suncrest College delivers customized training the way you need it.

Why Study Here?

Cancellation Policy

Funding Opportunities Available

Need more Information?

Contact the Corporate Training Team

Website Coding

SQL

SQL

Overview

Courses

Modules

Introduction to SQL

Intermediate SQL

Advanced SQL

Costs and Fees

Applying Online

Details

Suncrest College delivers customized training the way you need it.

Why Study Here?

Cancellation Policy

Funding Opportunities Available

Need more Information?

Contact the Corporate Training Team

Website Coding

Application Timeline

Create an account

Account Details

Account Sign In

You're signed in!

Great! Your activation email was sent

Can’t find an email from us?

Ongoing Applications

Selected Courses

Completed Applications

Selected Courses

Fill Out Application

Address

Phone

Demographics

Disabilities Detail

Sponsors Detail

Ancestry

Consents

Review Your Application

Please check that your details are correct

Your selected programs and courses:

Please review your application information below:

Submit Your Application

We have all the information we require for your application

Submit Your Application

We have all the information we require for your application

Application Submitted without Payment

You have chosen to pay later.

Payment

Last step, please enter your payment information below

Application Complete

All done!

Payment Complete

All done!