Douglas College wordmark
Facebook logo Twitter logo Instagram logo Snapchat logo YouTube logo Wordpress logo

Registration for the Fall 2019 semester begins June 25.  Watch your email for more details.

back to search

Database II

Course Code: CSIS 3300
Faculty: Commerce & Business Administration
Credits: 3.0
Semester: 15 Weeks
Learning Format: Lecture, Seminar
Typically Offered: TBD. Contact Department Chair for more info.
course overview

This course will continue on from CSIS 2300 exploring advanced features of database systems. Topics covered will include indexing; query processing and optimization; transaction processing; denormalization; star schema; DW/OLAP cubes; security. NoSQL and MapReduce will also be covered.

Course Content

  1. Course overview and review of database fundamentals;
  2. Working with DB indexes;
  3. Introduction to query processing and optimization;
  4. Query optimization case studies;
  5. Working with DB transactions;
  6. Denormalizing a DB - why, when, and how;
  7. Introduction to dimensional modeling;
  8. Designing a star schema;
  9. Working with DW/OLAP cube;
  10. Introduction to noSQL databases;
  11. CRUD operations in noSQL;
  12. Analytics in noSQL (MapReduce);
  13. Securing a database system.

Methods of Instruction

Lecture, seminar and hands-on exercises in the lab.

Means of Assessment

Participation 0% - 5%
Assignments/Project:    15% - 25%
Quizzes (Minimum 2)* 10% - 20%
Midterm exam * 20% - 30%
Final Exam * 25% - 35%
Total 100%

# Some of the assessments may involve group work.

**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).

Learning Outcomes

The student will be able to:

  1. Explain the purpose of indexing;
  2. List different types of indexes;
  3. Evaluate and explain when to use an index on a column;
  4. Describe how a SQL query is processed by the DB engine;
  5. Generate a more efficient query which reduces resource consumption but provides same data results;
  6. Explain situations when DB transactions should be used;
  7. Plan a set of queries which could be executed as part of a transaction - including both the success and failure scenarios;
  8. Describe why and when denormalization is beneficial for a DB system;
  9. Execute the denormalization process;
  10. Design a star schema;
  11. Use a DW/OLAP cube to extract information from data;
  12. Use a noSQL DB to perform CRUD (Create, Retrieve, Update, Delete) operations;
  13. Demonstrate application of MapReduce functions;
  14. Describe common DB security issues and their solutions.

course prerequisites

CSIS 2300 

Corequisites

Courses listed here must be completed either prior to or simultaneously with this course:

  • No corequisite courses

Equivalencies

Courses listed here are equivalent to this course and cannot be taken for further credit:

  • No equivalency courses

curriculum guidelines

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.

course schedule and availability
course transferability

Below shows how this course and its credits transfer within the BC transfer system. 

A course is considered university-transferable (UT) if it transfers to at least one of the five research universities in British Columbia: University of British Columbia; University of British Columbia-Okanagan; Simon Fraser University; University of Victoria; and the University of Northern British Columbia.

For more information on transfer visit the BC Transfer Guide and BCCAT websites.

assessments

If your course prerequisites indicate that you need an assessment, please see our Assessment page for more information.

noticecurriculum notice

There is an upcoming curriculum change scheduled for .
View upcoming changes