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.
COMP 1002 or equivalent knowledge of a Windows PC and file management.
5.0
$671.73 - $706.86 See individual course offerings below for actual costs.
Below are nine offerings of this course for the Winter 2021 term.
Mon Jan 04 - Mon Mar 29 12 Weeks
Dates | Days | Times | Locations |
Jan 04 - Mar 29 | Mon | 18:00 - 21:00 |
Online Delivery See Notes below |
Jan 04 - Mar 29 |
Online Delivery See Notes below |
Benjamin Yu
$706.86
This course offering is in progress. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.
In Progress
Thu Jan 07 - Thu Mar 25 12 Weeks
Dates | Days | Times | Locations |
Jan 07 - Mar 25 | Thu | 18:00 - 21:00 |
Online Delivery See Notes below |
Jan 07 - Mar 25 |
Online Delivery See Notes below |
Benjamin Yu
$696.86
This course offering is in progress. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.
In Progress
Fri Jan 08 - Fri Mar 26 12 Weeks
Dates | Days | Times | Locations |
Jan 08 - Mar 26 | Fri | 18:00 - 21:00 |
Online Delivery See Notes below |
Jan 08 - Mar 26 |
Online Delivery See Notes below |
Frank Wegener
$696.86
This course offering is in progress and full. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.
In Progress and Full
Sat Jan 09 - Sat Mar 27 12 Weeks
Dates | Days | Times | Locations |
Jan 09 - Mar 27 | Sat | 09:00 - 12:00 |
Online Delivery See Notes below |
Jan 09 - Mar 27 |
Online Delivery See Notes below |
Frank Wegener
$706.86
This course offering is in progress. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.
In Progress
Sat Jan 09 - Sat Mar 27 12 Weeks
Dates | Days | Times | Locations |
Jan 09 - Mar 27 | Sat | 13:00 - 16:00 |
Online Delivery See Notes below |
Jan 09 - Mar 27 |
Online Delivery See Notes below |
TBD
TBD – see Learning Outcomes in the interim
$706.86
This course offering has been cancelled. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.
Cancelled
Tue Jan 12 - Tue Mar 30 12 Weeks
Dates | Days | Times | Locations |
Jan 12 - Mar 30 | Tue | 18:30 - 21:30 |
Online Delivery See Notes below |
Jan 12 - Mar 29 |
Online Delivery See Notes below |
Alexander Volkov
$706.86
This course offering is in progress. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.
In Progress
Tue Jan 12 - Tue Mar 30 12 Weeks
Dates | Days | Times | Locations |
Jan 12 - Mar 30 | Tue | 18:30 - 21:30 |
Online Delivery See Notes below |
Jan 12 - Mar 30 |
Online Delivery See Notes below |
Sam Meech-Ward
$706.86
This course offering is in progress and full. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.
In Progress and Full
Wed Jan 13 - Wed Mar 31 12 Weeks
Dates | Days | Times | Locations |
Jan 13 - Mar 31 | Wed | 18:30 - 21:30 |
Online Delivery See Notes below |
Jan 13 - Mar 31 |
Online Delivery See Notes below |
TBD
TBD – see Learning Outcomes in the interim
$706.86
This course offering has been cancelled. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.
Cancelled
Wed Jan 13 - Wed Mar 31 12 Weeks
Dates | Days | Times | Locations |
Jan 13 - Mar 31 | Wed | 18:30 - 21:30 |
Online Delivery See Notes below |
Jan 13 - Mar 31 |
Online Delivery See Notes below |
TBD
TBD – see Learning Outcomes in the interim
$706.86
This course offering has been cancelled. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.
Cancelled
Below are six offerings of this course for the Spring/Summer 2021 term.
Sat Apr 10 - Sat Jul 03 12 Weeks
Dates | Days | Times | Locations |
Apr 10 - Jul 03 |
Online Delivery See Notes below |
Frank Wegener
TBD – see Learning Outcomes in the interim
$671.73
A portion of seats are temporarily held for domestic students. International students: this may impact your ability to register. Learn why.
}12 seats available as of Feb 25, 2021 11:17 am (PST). Of these 12, 6 are currently reserved for domestic students only. Availability may change at any time.
Sat Apr 10 - Sat Jul 03 12 Weeks
Dates | Days | Times | Locations |
Apr 10 - Jul 03 |
Online Delivery See Notes below |
Frank Wegener
TBD – see Learning Outcomes in the interim
$671.73
A portion of seats are temporarily held for domestic students. International students: this may impact your ability to register. Learn why.
}19 seats available as of Feb 25, 2021 11:17 am (PST). Of these 19, 13 are currently reserved for domestic students only. Availability may change at any time.
Tue Apr 13 - Tue Jun 29 12 Weeks
Dates | Days | Times | Locations |
Apr 13 - Jun 29 | Tue | 18:30 - 21:30 |
Online Delivery See Notes below |
Apr 13 - Jun 29 |
Online Delivery See Notes below |
Alexander Volkov
TBD – see Learning Outcomes in the interim
$706.86
A portion of seats are temporarily held for domestic students. International students: this may impact your ability to register. Learn why.
}7 seats available as of Feb 25, 2021 11:17 am (PST). Of these 7, 3 are currently reserved for domestic students only. Availability may change at any time.
Wed Apr 14 - Wed Jun 30 12 Weeks
Dates | Days | Times | Locations |
Apr 14 - Jun 30 | Wed | 18:30 - 21:30 |
Online Delivery See Notes below |
Apr 14 - Jun 30 |
Online Delivery See Notes below |
Alexander Volkov
TBD – see Learning Outcomes in the interim
$706.86
A portion of seats are temporarily held for domestic students. International students: this may impact your ability to register. Learn why.
}16 seats available as of Feb 25, 2021 11:17 am (PST). Of these 16, 10 are currently reserved for domestic students only. Availability may change at any time.
Wed Apr 14 - Wed Jun 30 12 Weeks
Dates | Days | Times | Locations |
Apr 14 - Jun 30 | Wed | 18:00 - 21:00 |
Online Delivery See Notes below |
Apr 14 - Jun 30 |
Online Delivery See Notes below |
Maryam Khezrzadeh
TBD – see Learning Outcomes in the interim
$696.86
A portion of seats are temporarily held for domestic students. International students: this may impact your ability to register. Learn why.
}13 seats available as of Feb 25, 2021 11:17 am (PST). Of these 13, 7 are currently reserved for domestic students only. Availability may change at any time.
Tue May 04 - Tue Jul 20 12 Weeks
Dates | Days | Times | Locations |
May 04 - Jul 20 | Tue | 18:30 - 21:30 |
Online Delivery See Notes below |
May 04 - Jul 20 |
Online Delivery See Notes below |
Sam Meech-Ward
TBD – see Learning Outcomes in the interim
$706.86
This course offering is full. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.
Full
Upon successful completion of this course, the student will be able to:
Effective as of Winter 2011
COMP 1630 is offered as a part of the following programs:
The BCIT bookstore carries textbooks, general reference books, software, and stationery. Please visit bcit.ca/bookstore for more information.
Books for Winter 2021 offerings of this course are available in the following BCIT online bookstores. Please choose the bookstore appropriate for the offering you are considering.
If you are taking this course at the BCIT Downtown Campus (DTC), please purchase books for this course at the BCIT Downtown Campus Bookstore.
Cei Digital: Mindtap W Etext For Database Systems, 13Th Ed (180 Days) | |
---|---|
Author | Coronel |
Copyright | 2017 |
Binding | Digital Version |
ISBN | 978-1-33762-793-1 |
Price | $105.50 |
Choose One |
Database Systems: Design, Implementation, & Mgmt, 13Th Ed | |
---|---|
Author | Coronel |
Copyright | 2019 |
Binding | Hardback |
ISBN | 978-1-33762-790-0 |
Price | $181.95 |
Choose One |
No information on books is currently available for Spring/Summer 2021 offerings of this course.
If you have a comment or question about this course, please complete and submit the form below.
Interested in being notified about future offerings of COMP 1630 - Relational Database Design and SQL? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.