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.
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.
Status
4 seats remaining as of Dec 10, 2019 10:13 am (PST). Availability may change at any time.
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 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.
Status
1 seat remaining as of Dec 10, 2019 10:13 am (PST). Availability may change at any time.
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 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 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).
Status
3 seats remaining as of Dec 10, 2019 10:13 am (PST). Availability may change at any time.
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).
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).
Status
This course offering is full. Please check this page for other currently available offerings or subscribe to receive email updates.
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.
Status
This course offering is full. Please check this page for other currently available offerings or subscribe to receive email updates.
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.
Status
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:
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.