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.

Other courses in Data Science