LERN 1010: Introduction to SQL
Effective date
January 2021
Department
LERN UGotClass
School
Continuing Studies
Description
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.
This course is offered in partnership with Learning Education Resource Network - UGotClass. For more information see http://yougotclass.org/index.cfm/VCC
Year of study
General Interest
Course Learning Outcomes
Upon successful completion of this course, students will be able to:
- Understand the structure of a relational database and how SQL is used to query a relational database structure.
- Learn how to use SQL script to create and populate database tables.
- Be able to use SQL script to select, retrieve, and filter data from a database.
Prior Learning Assessment & Recognition (PLAR)
None
Hours
Lecture, Online, Seminar, Tutorial: 16
Total Hours: 16
Grading System
Satisfactory/Unsatisfactory
Passing grade
S - based on:1. Make at least one comment every week in the discussion.
Course topics
- The Relational Database and Structured Query Language
The relational database structure
Structured Query Language
Table creation and data insertion
Defining datatypes and constraints
Creating Indexes
- Table Management
Table management
Adding columns to a table
Deleting columns from a table
Deleting a table
- 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
- 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
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.