Introduction to SQL

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

Prerequisites

What you will learn

• 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

How to register

This course is offered as part of a VCC program only.

Contact us

If you have any question, please email at advising@vcc.ca.

† This information is intended as a guideline only. Program and course details are subject to change with the approval of VCC's Board of Governors.