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
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.
Requirements:
- Windows 10 or later. Macs are not compatible.
- Necessary rights (local administrative rights) to install programs on the computer.
- Windows 10 or later. Macs are not compatible.
- Necessary rights (local administrative rights) to install programs on the computer.
CEUs/ILUs: 1.6
One Month Course
Length (in hours): 16
Price in USD $245.00
Price in CAD $329.00
Agenda
Unit 1
The Relational Database and Structured Query Language
-
The relational database structure
-
Structured Query Language
-
Table creation and data insertion
-
Constraints and referential integrity
-
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
Hear from our past students
The course has a very nice pace and fits into one schedule seamlessly I like how it's structured reading material first, then presentation to reinforce the content read and then a quiz to put into practice what you have learned. With this being a new skill I am pursuing I must say I am pleased with how things going so far. - Keangelo M
I would highly recommend this course as an introduction or even a refresher. Though I use SQL daily, I have taken away new tips and tricks for more effective ways to write queries, making me more efficient and productive. Ms. Cecelia has put together very thoughtful and thought provoking body of lessons to gently move you through each unit. You can tell she thoroughly enjoys SQL and takes great care in the lessons as well as the thoughtful responses to questions. Very impressed and SO glad I took the chance. I'm really looking forward to the Intermediate course! - Kathy S
I love this course, and I'm looking forward to the next two follow up courses to get my SQL certificate. I love the readings, the presentations, the discussions. This is the best I could have hoped for actually after being out of school for several years. - Dorothy R