Application Timeline
Create an Account
Fill Out Application
Review Application
Submit Application
Payment
Unsure which option to select? Check out our FAQ centre for support.
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.
CEUs/ILUs: 4.8
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
Unit 2: Table Management
Unit 3: Selecting and Retrieving Data
Unit 4: Filtering Data
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
Unit 6: Using Clauses in Structured Query Language
Unit 7: Creating Table Joins
Unit 8: Creating Subqueries
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 10: Creating Advanced Joins
Unit 11: Creating Union Queries
Unit 12: Transaction Processing, Stored Procedures, Triggers
Start Date
September 3, 2024
Length
48 Hours
Tuition
Corporate Training & Continuing Education
In the classroom. Online. On site.
We can even develop a program for you.
Suncrest College
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.
10
Percent
Higher Averages When Compared to Larger Class Sizes
#
More
You are more than just a number, we know you by name
$
Spend Less
Live where you learn, spend less on the extras
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.
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.
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:
Check out these similar offerings
Create an Account
Fill Out Application
Review Application
Submit Application
Payment
Please use your existing Suncrest College account to sign-in and start or complete your application using the Sign in button below. The credentials should be included in your Welcome Email.
If you have forgotten your username and/or password use the forgot your password link on the sign in page.
Select from the options below.
Click the "Start Application" button to begin.
Click the "Start Registration" button to begin.
We have sent an email to containing your activation link. Please follow the link provided to activate your account and continue with your application.
Your activation email may take a few minutes to arrive, and sometimes it can end up in your junk folder. If you still can’t see it, click here to resend it.
Listed are applications that are in progress. Please select one from the list to continue to completion.
Starting in
Loading Stage Resources...
Listed are applications that have previously been completed.
Starting in
Loading Stage Resources...
Nice work ! Almost at the finish line. Here’s an overview of your application. Expand a section to review and make changes if you need to.
Term:
Location:
Learning Style:
Date:
to |
Organization
Address Line 1
Address Line 2
City
Province/State
Postal/Zip Code
Country
Birthday
Gender
Marital Status
First Language
Country of citizenship
Date of citizenship
Are you a permanent resident of Canada?
Do you have any disabilities?
Do you have any dependants?
Are you sponsored?
Type | Does Consent |
---|---|
An e-mail has been sent to you providing details on alternate payment methods. You may now close this window. Thank you!
Your application does not require any payment, you're all done. An e-mail has been sent to you providing the details. You may now close this window. Thank you!
We have received your payment successfully. An e-mail has been sent to you providing details and receipt of payment. You may now close this window. Thank you!
Please choose your application path based on your residency.
Select this option if you are coming from outside of Canada.
Select this option if you are currently a permanent resident of Canada.
Unsure which option to select? Check out our FAQ centre for support.
Unsure which option to select? Check out our FAQ centre for support.