Ready to learn more?

Next Cohort: Apr 14-Jun 30

By submitting your email address, you acknowledge and agree to CourseCompare.ca's Terms of Service and Privacy Policy.

Duration

12 weeks

Tuition

$798

  ,

Apr 14-Jun 30

Plus 3 other start dates

Apr 25 - Jul 11 2026

May 4 - Jul 20 2026

May 7 - Jul 30 2026

Commitment

Part-Time

Delivery

Classroom

Year Founded

1960

Scholarships

no

BCIT’s Relational Database Design and SQL course is an intensive, hands-on introduction to relational database concepts and industry-standard practices. Students learn how to model, design, and implement databases using Relational Database Management Systems (RDBMS) in a Windows 11 environment. The curriculum emphasizes SQL for defining and manipulating data, covering topics such as functional dependencies, normalization, entity-relationship modeling, and UML diagramming, alongside DDL, DML, views, triggers, stored procedures, and transaction management.

In addition to core database design skills, the course explores current industry trends, including replication, data warehousing, OLAP, and cloud-based database applications. Students engage in group work, labs, and online activities, preparing them to develop fully functional database applications and progress to advanced courses in database administration, SQL Server development, business intelligence, and data quality improvement. COMP 1630 also serves as a prerequisite for several BCIT Computing programs and certificates.

Share

Facebook LinkedIn Twitter email

Ready to get started?

Next Cohort: Apr 14-Jun 30

By submitting your email address, you acknowledge and agree to CourseCompare.ca's Terms of Service and Privacy Policy.

Student Reviews (7)

Write a Review

British Columbia Institute of Technology (BCIT)

World-class facility when it comes to teaching trades and technology.

Mike B

January 30, 2024

Graduated From

Web Development and Design 1

Overall:

5 out of 5

Instructors:

5 stars

Curriculum:

5 stars

Job Assistance:

5 stars

In my opinion, it's a world-class facility when it comes to teaching trades and technology. I've taken a lot of post-secondary education at more places than I care to admit, and the courses I took at BCIT were among the best overall.

I took a va...

In my opinion, it's a world-class facility when it comes to teaching trades and technology. I've taken a lot of post-secondary education at more places than I care to admit, and the courses I took at BCIT were among the best overall.

I took a variety of classes in Business Admin and then - a few years later - in Web Design. When I left the classes, I felt as though I'd really learned something useful that I could apply right away. (Other places tend to give you a lot of theory, but you're not always confident that you could apply those skills right away.)

I worked in the Human Resources sector for a few years, and someone with a BCIT program on their resume was someone whose resume got read. If you have a chance to study there, take it.

British Columbia Institute of Technology (BCIT)

Teachers are well rounded with knowledge from may sectors of the industry

Kevin Spivak

January 30, 2024

Graduated From

not provided

Overall:

5 out of 5

Instructors:

5 stars

Curriculum:

5 stars

Job Assistance:

na

Studied to be a heavy duty equipment technician. I took the foundations course it was a long 9 months but we'll worth it got an apprenticeship as a heavy equipment mechanic 7 months into the course teachers are well rounded with knowledge from many sec...

Studied to be a heavy duty equipment technician. I took the foundations course it was a long 9 months but we'll worth it got an apprenticeship as a heavy equipment mechanic 7 months into the course teachers are well rounded with knowledge from many sectors of the industry.

Other courses in Agile Software Development