Ready to learn more?

Next Cohort: Sep 18-Dec 4

  • This field is for validation purposes and should be left unchanged.

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

Duration

12 weeks

Tuition

$677

  ,

Sep 18-Dec 4

Commitment

Part-Time

Delivery

Classroom

Year Founded

1960

Scholarships

no

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 in this course 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.

Ready to get started?

Next Cohort: Sep 18-Dec 4

  • This field is for validation purposes and should be left unchanged.

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

Student Reviews (3)

British Columbia Institute of Technology

Applied analytics certificate

Vancouver •

Graduated From

Applied Data Analytics

Overall:

5 out of 5

Instructors:

5 stars

Curriculum:

5 stars

Job Assistance:

5 stars

Practical, job-focused skills designed to get you a job in the field faster. That's what BCIT promises and that's what I got when I enrolled in the analytics program.

Practical, job-focused skills designed to get you a job in the field faster. That's what BCIT promises and that's what I got when I enrolled in the analytics program.

British Columbia Institute of Technology

Resume booster

Vancouver •

Graduated From

Applied Data Analytics

Overall:

4 out of 5

Instructors:

4 stars

Curriculum:

4 stars

Job Assistance:

5 stars
This program helped me get my resume in good shape for new job opportunities in the analytics industry. I was a marketer, so the combination of marketing work experience and analytics skills made finding good work relatively easy. Having said that, thi...
This program helped me get my resume in good shape for new job opportunities in the analytics industry. I was a marketer, so the combination of marketing work experience and analytics skills made finding good work relatively easy. Having said that, this program won't set you on the PhD track. It's a lot of excel work and all very applied in nature. If you want to learn big data and programming then I'd strongly recommend looking elsewhere. Probably 90% of the class had an IT or business background coming into the program, so some work experience will help you out.

Other courses in Data Analytics