- International Fees
International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Course details
This intensive, hands-on course is the prerequisite for follow-on database courses in several BCIT Computing programs. Students are introduced to relational database design concepts and industry standards. COMP 1630 starts with tools and processes for data modeling in Relational Database Management Systems (RDBMS). Labs and exercises take place in a Windows 11 PC environment. There is also a heavy 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, Data Warehousing, Online Analytical Processing (OLAP), using databases on the web and in the cloud are discussed. Students in are required to participate in group work, there is significant reading and assignments required outside of class. Online activities via the BCIT Learning Hub are mandatory. COMP 1630 is a required course for the Applied Database Administration and Design (ADAD) Associate Certificate; the Applied Data Analytics Certificate (ADAC) and the Computer Systems Certificate (CSC). It is also equivalent to the Full-time COMP 2714 and ACIT 1630 database courses. 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: COMP 3677 Introduction to MS Server Administration Part 1, COMP 3678 SQL Server Development; COMP 3679 Business Intelligence (BI) Tools, and COMP 3839 Data Quality Improvement.
Prerequisite(s)
- 60% in COMP 1002
Credits
5.0
Domestic fees
$725.62 - $782.37 See individual course offerings below for actual costs.
Course offerings
Spring/Summer 2024
Below are eight offerings of COMP 1630 for the Spring/Summer 2024 term.
CRN 57596
Duration
Tue Apr 09 - Tue Jun 25 (12 weeks)
- 12 weeks
- CRN 57596
- Domestic fees $725.62International fees are typically 3.12 times the domestic tuition.
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
Apr 09 - Jun 25 | Tue | 18:30 - 21:30 | Online |
Apr 09 - Jun 25 | N/A | N/A | Online |
Instructor
Alexander Volkov
Course outline
Domestic fees
$725.62
Important information
- Internet delivery format.
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
-
This course is 5.0 credits and has the workload of two courses. Course is 60 contact hours - 36 hours synchronous online classes and 24 hours asynchronous activities/labs. This class meets once per week for 3 hours online and requires an additional 2 hours per week online asynchronously for 5 contact hours per week. Reading, homework and assignments may require an additional 8-10+ hours per week outside of class. The typical total commitment for this course may be 13 -15+ hours each week. Late registration is not permitted.
Status
In Progress
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.
CRN 57600
Duration
Sat Apr 13 - Sat Jun 29 (12 weeks)
- 12 weeks
- CRN 57600
- Domestic fees $725.62International fees are typically 3.12 times the domestic tuition.
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
Apr 13 - Jun 29 | Sat | 09:00 - 12:00 | Online |
Apr 13 - Jun 29 | N/A | N/A | Online |
Instructor
Alexander Volkov
Course outline
Domestic fees
$725.62
Important information
- Internet delivery format.
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
-
This course is 5.0 credits and has the workload of two courses. Course is 60 contact hours - 36 hours synchronous online classes and 24 hours asynchronous activities/labs. This class meets once per week for 3 hours online and requires an additional 2 hours per week online asynchronously for 5 contact hours per week. Reading, homework and assignments may require an additional 8-10+ hours per week outside of class. The typical total commitment for this course may be 13 -15+ hours each week. Late registration is not permitted. Class in session May 18 (Victoria Day) and June 29 (Canada Day).
Status
In Progress
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.
CRN 57598
Duration
Sat May 04 - Sat Jul 20 (12 weeks)
- 12 weeks
- CRN 57598
- Domestic fees $725.62International fees are typically 3.12 times the domestic tuition.
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
May 04 - Jul 20 | N/A | N/A | Online |
Instructor
Frank Wegener
Course outline
Domestic fees
$725.62
Important information
- Internet delivery format.
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
-
This course is 5.0 credits and has the workload of two courses. This course section is delivered online asynchronously. There are optional 90-minute interactive Q&A/Review sessions (via Virtual Classroom) each week in real time Saturday 1000-1100. The exams are synchronous and attendance is required on the scheduled dates and times: MIDTERM exam: Saturday, June 01 at 0900; FINAL exam: Saturday, July 20 at 0900. Course is 60 hours. Depending on the student, the typical total time commitment for this course may be a total of 13-15+ hours each week. Late registration is not permitted. Q&A in session May 18 (Victoria Day) and June 29 (Canada Day).
Status
In Progress
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.
CRN 57599
Duration
Sat May 04 - Sat Jul 20 (12 weeks)
- 12 weeks
- CRN 57599
- Domestic fees $725.62International fees are typically 3.12 times the domestic tuition.
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
May 04 - Jul 20 | N/A | N/A | Online |
Instructor
Frank Wegener
Course outline
Domestic fees
$725.62
Important information
- Internet delivery format.
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
-
This course is 5.0 credits and has the workload of two courses. This course section is delivered online asynchronously. There are optional 90-minute interactive Q&A/Review sessions (via Virtual Classroom) each week in real time Saturday 1200-1300. The exams are synchronous and attendance is required on the scheduled dates and times: MIDTERM exam: Saturday, June 01 at 1300; FINAL exam: Saturday, July 20 at 1300. Course is 60 hours. Depending on the student, the typical total time commitment for this course may be a total of 13-15+ hours each week. Late registration is not permitted. Q&A in session May 18 (Victoria Day) and June 29 (Canada Day).
Status
In Progress and Full
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.
CRN 69462
Duration
Tue May 07 - Tue Jul 23 (12 weeks)
- 12 weeks
- CRN 69462
- Domestic fees $766.48International fees are typically 3.12 times the domestic tuition.
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
May 07 - Jul 23 | Tue | 18:30 - 21:30 | Burnaby SE12 Rm. 318 |
May 07 - Jul 23 | N/A | N/A | Online |
Instructor
Ashok Pamu
Course outline
Domestic fees
$766.48
Important information
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
-
This course is 5.0 credits and has the workload of two courses. Course is 60 contact hours - 36 hours on campus and 24 hours asynchronous activities/labs. This class meets once per week for 3 hours on campus and requires an additional 2 hours per week online asynchronously for 5 contact hours per week. Reading, homework and assignments may require an additional 8-10+ hours per week outside of class. The typical total commitment for this course may be 13 -15+ hours each week. Late registration is not permitted.
Status
In Progress and Full
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.
CRN 68021
Duration
Wed May 08 - Wed Jul 24 (12 weeks)
- 12 weeks
- CRN 68021
- Domestic fees $766.48International fees are typically 3.12 times the domestic tuition.
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
May 08 - Jul 24 | Wed | 18:30 - 21:30 | Burnaby SE12 Rm. 320 |
May 08 - Jul 24 | N/A | N/A | Online |
Instructor
Ashok Pamu
Course outline
Domestic fees
$766.48
Important information
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
-
This course is 5.0 credits and has the workload of two courses. Course is 60 contact hours - 36 hours on campus and 24 hours asynchronous activities/labs. This class meets once per week for 3 hours on campus and requires an additional 2 hours per week online asynchronously for 5 contact hours per week. Reading, homework and assignments may require an additional 8-10+ hours per week outside of class. The typical total commitment for this course may be 13 -15+ hours each week. Late registration is not permitted.
Status
In Progress and Full
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.
CRN 68170
Duration
Thu May 09 - Thu Jul 25 (12 weeks)
- 12 weeks
- CRN 68170
- Domestic fees $725.62International fees are typically 3.12 times the domestic tuition.
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
May 09 - Jul 25 | Thu | 18:30 - 21:30 | Online |
May 09 - Jul 25 | N/A | N/A | Online |
Instructor
Ashok Pamu
Course outline
Domestic fees
$725.62
Important information
- Internet delivery format.
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
-
This course is 5.0 credits and has the workload of two courses. Course is 60 contact hours - 36 hours synchronous online classes and 24 hours asynchronous activities/labs. This class meets once per week for 3 hours online and requires an additional 2 hours per week online asynchronously for 5 contact hours per week. Reading, homework and assignments may require an additional 8-10+ hours per week outside of class. The typical total commitment for this course may be 13 -15+ hours each week. Late registration is not permitted.
Status
In Progress and Full
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.
CRN 68738
Duration
Fri May 10 - Fri Jul 26 (12 weeks)
- 12 weeks
- CRN 68738
- Domestic fees $752.73International fees are typically 3.12 times the domestic tuition.
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
May 10 - Jul 26 | Fri | 18:00 - 21:00 | Downtown DTC Rm. 374 |
May 10 - Jul 26 | N/A | N/A | Online |
Instructor
Frederic Guo
Course outline
Domestic fees
$752.73
Important information
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
-
This course is 5.0 credits and has the workload of two courses. Course is 60 contact hours - 36 hours on campus and 24 hours asynchronous activities/labs. This class meets once per week for 3 hours on campus and requires an additional 2 hours per week online asynchronously for 5 contact hours per week. Reading, homework and assignments may require an additional 8-10+ hours per week outside of class. The typical total commitment for this course may be 13 -15+ hours each week. Late registration is not permitted.
Status
In Progress and Full
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.
Fall 2024
Below are seven offerings of COMP 1630 for the Fall 2024 term.
CRN 35047
Duration
Sat Sep 07 - Sat Nov 23 (12 weeks)
- 12 weeks
- CRN 35047
- Domestic fees $740.33International fees are typically 3.12 times the domestic tuition.
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
Sep 07 - Nov 23 | N/A | N/A | Online |
Instructor
Frank Wegener
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Domestic fees
$740.33
Important information
- Internet delivery format.
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
-
This course is 5.0 credits and has the workload of two courses. This course section is delivered online asynchronously. There are optional 90-minute interactive Q&A/Review sessions (via Virtual Classroom) each week in real time Saturday from 1000-1100. The exams are synchronous and attendance is required on the scheduled dates and times: MIDTERM exam: Saturday, October 5 at 0900-1200. FINAL exam: Saturday, November 23 at 0900-1200. Course is 60 hours. Depending on the student, the typical total time commitment for this course may be a total of 13-15+ hours each week. Late registration is not permitted. BCIT Computing is primarily a Microsoft Windows environment. Students must provide their own current model Windows-compatible PC. i5 or higher equivalent processor, with 8 GB of RAM minimum, and 256 GB minimum storage. Highspeed internet access is needed for online sections and for homework. Mac users must have the ability to manage and support their iOS computer. They may need to create a virtual Windows environment using Parallels or VMWare Fusion. COMP instructors may not be able to assist Mac users with software compatibility issues. BCIT does not provide access to Parallels or support for students to use a Mac to run Windows. Q&A in session September 28 (Truth & Reconciliation), October 12 (Thanksgiving) and November 9 (Remembrance Day).
Status
Sneak Preview
This section is only available for registration starting Wed May 22, 2024 at 9:00 am (PDT)
CRN 43628
Duration
Sat Sep 07 - Sat Nov 23 (12 weeks)
- 12 weeks
- CRN 43628
- Domestic fees $740.33International fees are typically 3.12 times the domestic tuition.
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
Sep 07 - Nov 23 | N/A | N/A | Online |
Instructor
Frank Wegener
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Domestic fees
$740.33
Important information
- Internet delivery format.
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
-
This course is 5.0 credits and has the workload of two courses. This course section is delivered online asynchronously. There are optional 90-minute interactive Q&A/Review sessions (via Virtual Classroom) each week in real time on Saturdays from 1200-1300. The exams are synchronous and attendance is required on the scheduled dates and times: MIDTERM exam: Saturday, October 5 at 1300-1600. FINAL exam: Saturday, November 23 at 1300-1600. Course is 60 hours. Depending on the student, the typical total time commitment for this course may be a total of 13-15+ hours each week. Late registration is not permitted. BCIT Computing is primarily a Microsoft Windows environment. Students must provide their own current model Windows-compatible PC. i5 or higher equivalent processor, with 8 GB of RAM minimum, and 256 GB minimum storage. Highspeed internet access is needed for online sections and for homework. Mac users must have the ability to manage and support their iOS computer. They may need to create a virtual Windows environment using Parallels or VMWare Fusion. COMP instructors may not be able to assist Mac users with software compatibility issues. BCIT does not provide access to Parallels or support for students to use a Mac to run Windows. Q&A in session September 28 (Truth & Reconciliation), October 12 (Thanksgiving) and November 9 (Remembrance Day).
Status
Sneak Preview
This section is only available for registration starting Wed May 22, 2024 at 9:00 am (PDT)
CRN 35596
Duration
Mon Sep 09 - Mon Nov 25 (12 weeks)
- 12 weeks
- CRN 35596
- Domestic fees $740.33International fees are typically 3.12 times the domestic tuition.
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
Sep 09 - Nov 25 | Mon | 18:30 - 21:30 | Online |
Sep 09 - Nov 25 | N/A | N/A | Online |
Instructor
Alexander Volkov
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Domestic fees
$740.33
Important information
- Internet delivery format.
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
-
This course is 5.0 credits and has the workload of two courses. Course is 60 contact hours - 36 hours synchronous online classes and 24 hours asynchronous activities/labs. This class meets once per week for 3 hours online and requires an additional 2 hours per week online asynchronously for 5 contact hours per week. Please Note: Attendance, participation in class and the BCIT Learning Hub are mandatory. You should prepare to spend 2-3 hours on homework for every 1 hour of class time. This course may require an average total time commitment of 15+ hours per week. Late registration is not permitted. BCIT Computing is primarily a Microsoft Windows environment. Students must provide their own current model Windows-compatible PC. i5 or higher equivalent processor, with 8 GB of RAM minimum, and 256 GB minimum storage. Highspeed internet access is needed for online sections and for homework. Mac users must have the ability to manage and support their iOS computer. They may need to create a virtual Windows environment using Parallels or VMWare Fusion. COMP instructors may not be able to assist Mac users with software compatibility issues. BCIT does not provide access to Parallels or support for students to use a Mac to run Windows. Class in session September 30 (Truth & Reconciliation), October 14 (Thanksgiving) and November 11 (Remembrance Day).
Status
Sneak Preview
This section is only available for registration starting Wed May 22, 2024 at 9:00 am (PDT)
CRN 48318
Duration
Tue Sep 10 - Tue Nov 26 (12 weeks)
- 12 weeks
- CRN 48318
- Domestic fees $768.08International fees are typically 3.12 times the domestic tuition.
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
Sep 10 - Nov 26 | Tue | 18:00 - 21:00 | Downtown DTC Rm. 374 |
Sep 10 - Nov 26 | N/A | N/A | Online |
Instructor
Frederic Guo
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Domestic fees
$768.08
Important information
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
-
This course is 5.0 credits and has the workload of two courses. Course is 60 contact hours - 36 hours on campus and 24 hours asynchronous activities/labs. This class meets once per week for 3 hours on campus and requires an additional 2 hours per week online asynchronously for 5 contact hours per week. Please Note: Attendance, participation in class and the BCIT Learning Hub are mandatory. You should prepare to spend 2-3 hours on homework for every 1 hour of class time. This course may require an average total time commitment of 15+ hours per week. Late registration is not permitted. BCIT Computing is primarily a Microsoft Windows environment. Students must provide their own current model Windows-compatible PC. i5 or higher equivalent processor, with 8 GB of RAM minimum, and 256 GB minimum storage. Highspeed internet access is needed for online sections and for homework. Mac users must have the ability to manage and support their iOS computer. They may need to create a virtual Windows environment using Parallels or VMWare Fusion. COMP instructors may not be able to assist Mac users with software compatibility issues. BCIT does not provide access to Parallels or support for students to use a Mac to run Windows.
Status
Sneak Preview
This section is only available for registration starting Wed May 22, 2024 at 9:00 am (PDT)
CRN 48596
Duration
Wed Sep 11 - Wed Nov 27 (12 weeks)
- 12 weeks
- CRN 48596
- Domestic fees $782.37International fees are typically 3.12 times the domestic tuition.
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
Sep 11 - Nov 27 | Wed | 18:30 - 21:30 | Burnaby SE12 Rm. 320 |
Sep 11 - Nov 27 | N/A | N/A | Online |
Instructor
Ashok Pamu
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Domestic fees
$782.37
Important information
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
-
This course is 5.0 credits and has the workload of two courses. Course is 60 contact hours - 36 hours on campus and 24 hours asynchronous activities/labs. This class meets once per week for 3 hours on campus and requires an additional 2 hours per week online asynchronously for 5 contact hours per week. Please Note: Attendance, participation in class and the BCIT Learning Hub are mandatory. You should prepare to spend 2-3 hours on homework for every 1 hour of class time. This course may require an average total time commitment of 15+ hours per week. Late registration is not permitted. BCIT Computing is primarily a Microsoft Windows environment. Students must provide their own current model Windows-compatible PC. i5 or higher equivalent processor, with 8 GB of RAM minimum, and 256 GB minimum storage. Highspeed internet access is needed for online sections and for homework. Mac users must have the ability to manage and support their iOS computer. They may need to create a virtual Windows environment using Parallels or VMWare Fusion. COMP instructors may not be able to assist Mac users with software compatibility issues. BCIT does not provide access to Parallels or support for students to use a Mac to run Windows.
Status
Sneak Preview
This section is only available for registration starting Wed May 22, 2024 at 9:00 am (PDT)
CRN 49052
Duration
Thu Sep 12 - Thu Nov 28 (12 weeks)
- 12 weeks
- CRN 49052
- Domestic fees $740.33International fees are typically 3.12 times the domestic tuition.
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
Sep 12 - Nov 28 | Thu | 18:30 - 21:30 | Online |
Sep 12 - Nov 28 | N/A | N/A | Online |
Instructor
Ashok Pamu
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Domestic fees
$740.33
Important information
- Internet delivery format.
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
-
This course is 5.0 credits and has the workload of two courses. Course is 60 contact hours - 36 hours synchronous online classes and 24 hours asynchronous activities/labs. This class meets once per week for 3 hours online and requires an additional 2 hours per week online asynchronously for 5 contact hours per week. Please Note: Attendance, participation in class and the BCIT Learning Hub are mandatory. You should prepare to spend 2-3 hours on homework for every 1 hour of class time. This course may require an average total time commitment of 15+ hours per week. Late registration is not permitted. BCIT Computing is primarily a Microsoft Windows environment. Students must provide their own current model Windows-compatible PC. i5 or higher equivalent processor, with 8 GB of RAM minimum, and 256 GB minimum storage. Highspeed internet access is needed for online sections and for homework. Mac users must have the ability to manage and support their iOS computer. They may need to create a virtual Windows environment using Parallels or VMWare Fusion. COMP instructors may not be able to assist Mac users with software compatibility issues. BCIT does not provide access to Parallels or support for students to use a Mac to run Windows.
Status
Sneak Preview
This section is only available for registration starting Wed May 22, 2024 at 9:00 am (PDT)
CRN 47506
Duration
Sat Sep 14 - Sat Nov 30 (12 weeks)
- 12 weeks
- CRN 47506
- Domestic fees $740.33International fees are typically 3.12 times the domestic tuition.
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
Sep 14 - Nov 30 | Sat | 09:00 - 12:00 | Online |
Sep 14 - Nov 30 | N/A | N/A | Online |
Instructor
Alexander Volkov
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Domestic fees
$740.33
Important information
- Internet delivery format.
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
-
This course is 5.0 credits and has the workload of two courses. Course is 60 contact hours - 36 hours synchronous online classes and 24 hours asynchronous activities/labs. This class meets once per week for 3 hours online and requires an additional 2 hours per week online asynchronously for 5 contact hours per week. Please Note: Attendance, participation in class and the BCIT Learning Hub are mandatory. You should prepare to spend 2-3 hours on homework for every 1 hour of class time. This course may require an average total time commitment of 15+ hours per week. Late registration is not permitted. BCIT Computing is primarily a Microsoft Windows environment. Students must provide their own current model Windows-compatible PC. i5 or higher equivalent processor, with 8 GB of RAM minimum, and 256 GB minimum storage. Highspeed internet access is needed for online sections and for homework. Mac users must have the ability to manage and support their iOS computer. They may need to create a virtual Windows environment using Parallels or VMWare Fusion. COMP instructors may not be able to assist Mac users with software compatibility issues. BCIT does not provide access to Parallels or support for students to use a Mac to run Windows. Class in session on September 28 (Truth & Reconciliation), October 12 (Thanksgiving) and November 9 (Remembrance Day).
Status
Sneak Preview
This section is only available for registration starting Wed May 22, 2024 at 9:00 am (PDT)
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Describe the database approach, its environment, and database application life cycle.
- Explain the functions and characteristics of the relational model.
- Describe and work through the normalization process.
- Apply UML techniques of database design including:
- Enhanced entity-relationship modeling using UML
- Functional dependencies
- Derivation of relations schema from EER model.
- Use Crow's foot notation to represent relationship among entities in a database system.
- Apply database design process to implement a database application.
- Describe security issues, improve query performance, and data protection techniques in a database environment.
- Explain the use of databases in data warehousing and OLAP.
- Use SQL - DDL to implement a relational database.
- Use SQL for data manipulation with the basic statements: INSERT, UPDATE, DELETE and SELECT.
- Use SQL for advanced manipulation such as Group BY, Having, Correlated subqueries.
- Create stored procedures and triggers.
- Discuss techniques for transaction management and concurrency control.
- Discuss provisioning a Relational Database Management System (RDBMS) in the Cloud.
Effective as of Fall 2023
Related Programs
Relational Database Design and SQL (COMP 1630) is offered as a part of the following programs:
- Indicates programs accepting international students.
- Indicates programs with a co-op option.
School of Computing and Academic Studies
- Agile Development
Associate Certificate Part-time
- Applied Computer Information Systems (ACIS)
Associate Certificate Part-time
- Applied Data Analytics
Certificate Part-time
- Applied Database Administration and Design
Associate Certificate Part-time
- Applied Web Development
Associate Certificate Part-time
- Computer Systems
Certificate Part-time
Contact Us
If you have a question or comment about this course, please complete and submit the form below.
Subscribe
Interested in being notified about future offerings of Relational Database Design and SQL (COMP 1630)? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.
Programs and courses are subject to change without notice.