British Columbia Institute of Technologywww.bcit.ca/study/courses/comp1630

Important Notice: No skyrain strike - Dec 10, 6:30 am

BCIT

COMP 1630 - Relational Database Design and SQL

Computer Systems Part-time Studies Course

School of Computing and Academic Studies

Course Details

This intensive, hands-on course is the prerequisite for all advanced database courses in BCIT Computing programs. COMP 1630 is equivalent to the Full-time CST and CIT Diploma database courses and provides an introduction to relational database design concepts and industry standards. Students learn the tools and processes for data modeling in Relational Database Management Systems (RDBMS) in a Windows PC lab environment. They also focus on the Structured Query Language, SQL to define and manipulate data. Topics include functional dependencies, normalization, database design methodologies, entity relationship modeling and the use of UML as a diagramming notation. Advanced topics include: an introduction to SQL, DDL- data definition language and DML- data manipulation language, views, security, transaction management, triggers and stored procedures. Current trends in database such as replication, object-relational DBMS, data warehousing, OLAP- online analytical processing and database uses web technology are discussed. Students in COMP 1630 are required to attend one face to face meeting each week, participate in group work, and an online component, plus complete reading and assignments outside of class. Upon successful completion, participants will be able to design and implement a database application and be prepared to move on to higher level database courses including: Data Warehouse, Data Quality, MySQL, MS Business Intelligence, MS SQL Server and Oracle.

Prerequisite(s)

COMP 1002 or equivalent knowledge of a Windows PC and file management.

Credits

5.0

Cost

$683.26 - $691.83 See individual course offerings below for actual costs.

Winter 2020

Below are 10 offerings of this course for the Winter 2020 term.

CRN 86176

Mon Jan 06 - Mon Apr 06 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 06 - Apr 06 Mon 18:00 - 21:00 DTC Rm. 370
Jan 06 - Apr 06 Online

Instructor

TBD

Course Outline

TBD

Cost

$683.26

Notes

  1. This class meets once per week for 3 hours face to face and requires an additional 2 hours per week as an online class component. Reading, homework and assignments may require 5+ hours per week outside of class. The typical total commitment for this course is 8-10 hours each week. Course is 60 hours - 36 in class and 24 online. Late registration is not permitted. No class on February 17 (Family Day) and March 09.

4 seats remaining as of Dec 10, 2019 10:13 am (PST). Availability may change at any time.

CRN 87308

Wed Jan 08 - Wed Mar 25 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 08 - Mar 25 Wed 18:00 - 21:00 DTC Rm. 370
Jan 08 - Mar 25 Online

Instructor

TBD

Course Outline

TBD

Cost

$683.26

Notes

  1. This class meets once per week for 3 hours face to face and requires an additional 2 hours per week as an online class component. Reading, homework and assignments may require 5+ hours per week outside of class. The typical total commitment for this course is 8-10 hours each week. Course is 60 hours - 36 in class and 24 online. Late registration is not permitted.

CRN 80046

Thu Jan 09 - Thu Mar 26 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 09 - Mar 26 Thu 18:00 - 21:00 DTC Rm. 370
Jan 09 - Mar 26 Online

Instructor

TBD

Course Outline

TBD

Cost

$683.26

Notes

  1. This class meets once per week for 3 hours face to face and requires an additional 2 hours per week as an online class component. Reading, homework and assignments may require 5+ hours per week outside of class. The typical total commitment for this course is 8-10 hours each week. Course is 60 hours - 36 in class and 24 online. Late registration is not permitted.

1 seat remaining as of Dec 10, 2019 10:13 am (PST). Availability may change at any time.

CRN 86178

Thu Jan 09 - Thu Mar 26 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 09 - Mar 26 Thu 18:00 - 21:00 DTC Rm. 372
Jan 09 - Mar 26 Online

Instructor

TBD

Course Outline

TBD

Cost

$683.26

Notes

  1. This class meets once per week for 3 hours face to face and requires an additional 2 hours per week as an online class component. Reading, homework and assignments may require 5+ hours per week outside of class. The typical total commitment for this course is 8-10 hours each week. Course is 60 hours - 36 in class and 24 online. Late registration is not permitted.

CRN 74012

Fri Jan 10 - Fri Mar 27 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 10 - Mar 27 Fri 18:00 - 21:00 DTC Rm. 372
Jan 10 - Mar 27 Online

Instructor

TBD

Course Outline

TBD

Cost

$683.26

Notes

  1. This class meets once per week for 3 hours face to face and requires an additional 2 hours per week as an online class component. Reading, homework and assignments may require 5+ hours per week outside of class. The typical total commitment for this course is 8-10 hours each week. Course is 60 hours - 36 in class and 24 online. Late registration is not permitted.

CRN 74013

Sat Jan 11 - Sat Mar 28 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 11 - Mar 28 Sat 09:00 - 12:00 BBY SE06 Rm. 106
Jan 11 - Mar 28 Online

Instructor

TBD

Course Outline

TBD

Cost

$691.83

Notes

  1. This class meets once per week for 3 hours face to face and requires an additional 2 hours per week as an online class component. Reading, homework and assignments may require 5+ hours per week outside of class. The typical total commitment for this course is 8-10 hours each week. Course is 60 hours - 36 in class and 24 online. Late registration is not permitted. Class will be in session February 15 (Family Day).

3 seats remaining as of Dec 10, 2019 10:13 am (PST). Availability may change at any time.

CRN 82098

Sat Jan 11 - Sat Mar 28 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 11 - Mar 28 Sat 13:00 - 16:00 BBY SE06 Rm. 106
Jan 11 - Mar 28 Online

Instructor

TBD

Course Outline

TBD

Cost

$691.83

Notes

  1. This class meets once per week for 3 hours face to face and requires an additional 2 hours per week as an online class component. Reading, home work and assignments may require 5+ hours per week outside of class. The typical total commitment for this course is 8-10 hours each week. Course is 60 hours - 36 in class and 24 online. Late registration is not permitted. Class will be in session February 15 (Family Day).

CRN 74486

Mon Jan 06 - Mon Mar 30 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 06 - Mar 30 Mon 18:30 - 21:30 BBY SE06 Rm. 104
Jan 06 - Mar 30 Online

Instructor

TBD

Course Outline

TBD

Cost

$691.83

Notes

  1. This class meets once per week for 3 hours face to face and requires an additional 2 hours per week as an online class component. Reading, homework and assignments may require 5+ hours per week outside of class. The typical total commitment for this course is 8-10 hours each week. Course is 60 hours - 36 in class and 24 online. Late registration is not permitted. No class on February 17 (Family Day).

This course offering is full. Please check this page for other currently available offerings or subscribe to receive email updates.

Full

CRN 74443

Tue Jan 07 - Tue Mar 24 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 07 - Mar 24 Tue 18:00 - 21:00 DTC Rm. 370
Jan 07 - Mar 24 Online

Instructor

TBD

Course Outline

TBD

Cost

$683.26

Notes

  1. This class meets once per week for 3 hours face to face and requires an additional 2 hours per week as an online class component. Reading, homework and assignments may require 5+ hours per week outside of class. The typical total commitment for this course is 8-10 hours each week. Course is 60 hours - 36 in class and 24 online. Late registration is not permitted.

This course offering is full. Please check this page for other currently available offerings or subscribe to receive email updates.

Full

CRN 74021

Wed Jan 08 - Wed Mar 25 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 08 - Mar 25 Wed 18:30 - 21:30 BBY SE06 Rm. 104
Jan 08 - Mar 25 Online

Instructor

TBD

Course Outline

TBD

Cost

$691.83

Notes

  1. This class meets once per week for 3 hours face to face and requires an additional 2 hours per week as an online class component. Reading, homework and assignments may require 5+ hours per week outside of class. The typical total commitment for this course is 8-10 hours each week. Course is 60 hours - 36 in class and 24 online. Late registration is not permitted.

This course offering is full. Please check this page for other currently available offerings or subscribe to receive email updates.

Full

Related Programs

COMP 1630 is offered as a part of the following programs:

School of Computing and Academic Studies

  1. Advanced .NET Development
    Part-time   Associate Certificate
  2. Agile Development
    Part-time   Associate Certificate
  3. Applied Computer Information Systems (ACIS)
    Part-time   Associate Certificate
  4. Applied Data Analytics
    Part-time   Certificate
  5. Applied Database Administration and Design
    Part-time   Associate Certificate
  6. Applied Web Development
    Part-time   Associate Certificate
  7. Computer Systems
    Part-time   Certificate

Programs and courses are subject to change without notice.

Find Courses

English Language Proficiency

BCIT's Part-time Studies English Language Proficiency Standard is English 12 (or equivalency). Students who do not meet this requirement should upgrade their English skills prior to any future registration.

Payment Changes At BCIT

We've changed the way we accept payments.

Find out more

Course Navigation, Related Links & Tools

Registration News

Registration is now open for the Winter 2020 term.

Classroom Locations

Classroom locations are subject to last minute changes. Please check the Part-time Studies Classroom Locations listing at www.bcit.ca/rooms on the first day of any course you are registered for.

Part-time Studies Financial Aid

Will you be studying at BCIT part-time? Do you need assistance funding your studies? Find out if you qualify for Part-time Studies financial aid ›

© BCIT