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
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.
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
Length (in hours): 16
Price in USD $245.00
Price in CAD $329.00
Agenda
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
Hear from our past students
Easy to follow explanations and assignments. - Micaela G
I was able to learn alot during the four weeks. The practice queries helped clarify what I had trouble with, and it all makes sense now. Can't wait to take the next class and apply the info learned in work. - Jake
I really enjoyed this class and feel like it built on the material that I learned in the Intro class. Cecelia does a great job at providing examples for complicated queries that are easy to understand. I am looking forward to taking the Advanced class in August.
- Jason S