Course Overview
In this course, students will learn the structure of a database and how to query a database. Students will use various relational database management systems as platforms for hosting a database. Students will create a relational database, write SQL statements to extract information, create entity relationship diagrams (ERDs) to depict a database, and analyze table designs.
Prerequisite(s)
- No prerequisites are required for this course.
Credits
5.0
- Not offered this term
- This course is not offered this term. Notify me to receive email notifications when the course opens for registration next term.
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Describe the structure of a database
- Deploy a relational database management system to host a database
- Analyze database requirements
- Apply database design techniques
- Create relational tables and database objects
- Create user forms and generate reports
- Perform queries with SQL
- Describe data definition language (DDL) and data manipulation language (DML)
- Create an Entity Relationship Diagram (ERD)
- Identify functional dependencies
- Implement steps for table normalization
- Discuss current trends in databases including data warehousing
Effective as of Fall 2018
Related Programs
Database Essentials (CISA 1350) is offered as a part of the following programs:
- Indicates programs accepting international students.
- Indicates programs eligible for students to apply for Post-graduation Work Permit (PGWP).
School of Energy
- Computer Information Systems Administration
Diploma Full-time
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.