vcc.ca

LERN 2000: SQL Certificate 

Effective date

January 2021 

Department

LERN UGotClass 

School

Continuing Studies 
 




Description

Structured Query Language (SQL) is the industry standard database programming language. It is one of the most in demand skills in occupations that require interaction with data and analyzing data. Through your knowledge of Structured Query Language, you will become more marketable in computer related career fields that pertain to database administration. Learning SQL can also lead to a job that is specific to analyzing data such as a data analyst, a quality assurance analyst, or a business analyst. You’ll first learn about relational database structures, the history and uses of Structured Query Language, and how to use Structured Query Language to create a database, add records to database tables, and how to use SQL queries to extract meaningful data from database tables. You will quickly progress from creating simple SQL queries that query a single table to querying multiple tables simultaneously. You’ll also learn how to alter data in a database and how to gather significant statistics from data stored in a database. Finally, you'll learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. This certificate will enhance your competitiveness in the field of database administration and data analyst jobs. 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:

Prior Learning Assessment & Recognition (PLAR)

None 

Hours

Lecture, Online, Seminar, Tutorial: 48
Total Hours: 48
 

Instructional Strategies

 

Grading System

Satisfactory/Unsatisfactory 

Passing grade

S - based on: 1. Make at least one comment every week in the discussion. 2. Take every Unit self-quiz. Completion timeframe - the requirements should be done by the last day of the course 
 

Evaluation Plan

None

Course topics

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.
Generated at: 12:39 pm on Mar. 28, 2024