Notice: You are no longer on the Northern Lakes College Continuing Education & Corporate Training website. In registering for courses on this site, your information will be subject to the ugotclass privacy terms. To view their privacy policy, please Click Here.
As a Northern Lakes College student, your information also applies to our FOIP and privacy policy below:
Protection of Privacy: The personal information that you provide to Northern Lakes College is collected pursuant to section 33(c) of the Freedom of Information and Protection of Privacy Act (Alberta) (“FOIPPA”). The information will be used for the purposes of delivering academic and support services, scholarships and awards, marketing and recruitment activities, and related purposes. Collected personal information is protected from unauthorized access, use, and disclosure in accordance with FOIPPA and may be reviewed subject to the provisions of the Act. Questions regarding the collection, use, and disclosure of personal information can be directed to the FOIP Coordinator, 780-751-3259 or foipcoordinator@northernlakescollege.ca
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.
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.
Requirements:
- Windows 10 or later. Macs are not compatible.
- Necessary rights (local administrative rights) to install programs on the computer.
This Certificate must be taken in the following order:
- Introduction
- Intermediate
- Advanced
CEUs/ILUs: 4.8
Length (in hours): 48
Price in USD $595.00
Price in CAD $799.00
Hear from our past students
I liked the layout of the course, and how the videos explained the reading query examples. This was helpful to see the examples visually, which worked well for me. - Jake
(Advanced SQL)
The instruction was clear and easy to understand. Great course. - Jessica G
(Advanced SQL)
Easy to follow explanations and assignments. - Micaela G
(Intermediate SQL)
Course schedule
Introduction to SQL
- May 6 – 31
- Jun 3 – 28
- Jul 1 – 26
- Aug 5 – 30
- Sep 3 – 28
- Oct 7 – Nov 1
- Nov 4 – 29
- Dec 2 – 27
Intermediate SQL
- May 6 – 31
- Jun 3 – 28
- Jul 1 – 26
- Aug 5 – 30
- Sep 3 – 28
- Oct 7 – Nov 1
- Nov 4 – 29
- Dec 2 – 27
Advanced SQL
- May 6 – 31
- Jun 3 – 28
- Jul 1 – 26
- Aug 5 – 30
- Sep 3 – 28
- Oct 7 – Nov 1
- Nov 4 – 29
- Dec 2 – 27