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
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.
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 9
Creating Advanced Subqueries
-
Structured Query Language Review
-
Using the IN keyword to link queries
-
Using the EXISTS keyword to link queries
-
Using the ANY keyword to link queries
-
Using the ALL keyword to link queries
Unit 10
Creating Advanced Joins
-
Creating inner joins review
-
Creating outer joins review
-
Creating joins with aggregate functions
-
Creating nested joins
Unit 11
Creating Union Queries
-
Creating UNION queries
-
Creating UNION ALL queries
-
Creating a WHERE clause and multiple UNION queries
Unit 12
Transaction Processing, Stored Procedures, Triggers
-
Implementing transaction processing
-
Implementing stored procedures
-
Implementing triggers
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
The instruction was clear and easy to understand. Great course. - Jessica G
I enjoyed the Advanced SQL class. I feel that it built nicely on the topics from the Intro and Intermediate classes. I feel like I have a good understanding of a broad spectrum of topics in SQL. It was great having Cecelia as the instructor, she is extremely knowledgeable and is able to explain complicated queries/statements in a clear manner. I would recommend the certificate program to anyone interested in learning about SQL. Thank you. - Jason S