- Course overview and review of database fundamentals;
- Working with DB indexes;
- Introduction to query processing and optimization;
- Query optimization case studies;
- Working with DB transactions;
- Denormalizing a DB - why, when, and how;
- Introduction to dimensional modeling;
- Designing a star schema;
- Working with DW/OLAP cube;
- Introduction to noSQL databases;
- CRUD operations in noSQL;
- Analytics in noSQL (MapReduce);
- Securing a database system.
Lecture, seminar and hands-on exercises in the lab.
|Assignments/Project:||10% - 25%|
|Quizzes (Minimum 2)||10% - 20%|
|Midterm exam||20% - 30%|
|Final Exam *||30% - 40%|
Some of the assessments may involve group work.
* Practical hands-on computer exam
In order to pass the course, students must, in addition to receiving an overall course grade of 50%, also achieve a grade of at least 50% on the combined weighted examination components (including quizzes, tests, exams).
Students may conduct research as part of their coursework in this class. Instructors for the course are responsible for ensuring that student research projects comply with College policies on ethical conduct for research involving humans, which can require obtaining Informed Consent from participants and getting the approval of the Douglas College Research Ethics Board prior to conducting the research.
At the end of this course, the successful student will be able to:
- Explain the purpose of indexing;
- List different types of indexes;
- Evaluate and explain when to use an index on a column;
- Describe how a SQL query is processed by the DB engine;
- Generate a more efficient query which reduces resource consumption but provides same data results;
- Explain situations when DB transactions should be used;
- Plan a set of queries which could be executed as part of a transaction - including both the success and failure scenarios;
- Describe why and when denormalization is beneficial for a DB system;
- Execute the denormalization process;
- Design a star schema;
- Use a DW/OLAP cube to extract information from data;
- Use a noSQL DB to perform CRUD (Create, Retrieve, Update, Delete) operations;
- Demonstrate application of MapReduce functions;
- Describe common DB security issues and their solutions.
Instructor compiled materials
other textbooks as approved by the department
Min grade C in CSIS 2300
No corequisite courses.
Courses listed here are equivalent to this course and cannot be taken for further credit:
- No equivalency courses
Course Guidelines for previous years are viewable by selecting the version desired. If you took this course and do not see a listing for the starting semester / year of the course, consider the previous version as the applicable version.
|Institution||Transfer Details||Effective Dates|
|Alexander College (ALEX)||ALEX CPSC 2XX (3)||2015/01/01 to -|
|Athabasca University (AU)||DOUG CSIS 2300 (3) & DOUG CSIS 3300 (3) = AU COMP 378 (3) & AU COMP 3XX (3)||2015/01/01 to -|
|Coquitlam College (COQU)||No credit||2015/01/01 to -|
|Kwantlen Polytechnic University (KPU)||KPU INFO 2XXX (3)||2019/05/01 to -|
|Langara College (LANG)||LANG CSIS 2XXX (3)||2015/01/01 to -|
|Okanagan College (OC)||No credit||2015/01/01 to -|
|Simon Fraser University (SFU)||No credit||2015/01/01 to -|
|Thompson Rivers University (TRU)||TRU COMP 3610 (3)||2015/01/01 to -|
|Trinity Western University (TWU)||No credit||2019/05/01 to -|
|University Canada West (UCW)||No credit||2015/01/01 to -|
|University Canada West (UCW)||UCW CPSC 3XX (3)||2006/01/01 to 2014/12/31|
|University of British Columbia - Okanagan (UBCO)||UBCO COSC 3rd (3)||2015/01/01 to 2021/04/30|
|University of British Columbia - Vancouver (UBCV)||UBCV CPSC 2nd (3)||2015/01/01 to -|
|University of Northern BC (UNBC)||UNBC CPSC 3XX (3)||2015/01/01 to -|
|University of Victoria (UVIC)||UVIC CSC 2XX (1.5)||2015/01/01 to -|
|Vancouver Community College (VCC)||No credit||2015/01/01 to -|