Application Timeline
Select Your Program
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
Application Deadline
February 6, 2023
Start Date
February 9, 2023
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
Select Your Program
Create an Account
Fill Out Application
Review Application
Submit Application
Payment
Your application will feature four sections, starting with the program you’d like to apply to and moving on to some details about your educational history.
To start your application, please tell us which program you’d like to apply to. You can review your choices at the end.
To start your application, please confirm this is the program you intend to apply for.
Term:
Location:
Learning Style:
Date:
to |
Please enter your email address and password below to access your application. Don’t have an account yet? Click here to create one.
Select from the options below.
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.
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.
Starting
We have recieved your application. Please select a method of payment, or if you need help, check out our Payment FAQs for support.
Here's what to do next:An e-mail has been sent to you providing details on alternate payment methods. 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!
| Remove |
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.
