vcc.ca
LERN 1020: Intermediate SQL
Effective date
January 2021
Department
LERN UGotClass
School
Continuing Studies
Description
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. This course is offered in partnership with Learning Education Resource Network - UGotClass. For more information see http://yougotclass.org/index.cfm/VCC
Credits
0.0
Year of study
General Interest
Prerequisites
None
Corequisites
None
Course Learning Outcomes
Upon successful completion of this course, students will be able to:
- Be able to create queries that contain calculated fields.
- Learn how to use the SQL ORDER BY, GROUP BY and HAVING clause.
- Understand how to use create SQL table joins and subqueries to query multiple tables simultaneously.
Prior Learning Assessment & Recognition (PLAR)
None
Hours
Lecture, Online, Seminar, Tutorial: 16
Total Hours: 16
Total Hours: 16
Instructional Strategies
Grading System
Satisfactory/Unsatisfactory
Passing grade
S- subject to you making 2-3 comments each day
Evaluation Plan
None
Course topics
- Creating Calculated Fields and using Aggregate Functions Structured Query Language Review Creating calculated fields Concatenating columns Using aggregate functions
- 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
- Creating Table Joins Creating Inner joins Creating Outer joins Creating Self joins
- Creating Subqueries Creating subqueries Creating subqueries that contain calculated fields Creating subqueries that contain aggregate functions
Notes:
- Course contents and descriptions, offerings and schedules are subject to change without notice.
- Students are required to follow all College policies including ones that govern their educational experience at VCC. Policies are available on the VCC website at:
https://www.vcc.ca/about/governance--policies/policies/. - To find out if there are existing transfer agreements for this course, visit the BC Transfer Guide at https://www.bctransferguide.ca.