CPSC 404

Advanced Relational Databases

Course Description

Physical database design, indexing, relational query processing and optimization, transaction processing, concurrency control, crash recovery, data warehouses, data cubes, views, special topics.

Average difficulty
3.75 / 5
Average quality
5 / 5
Scroll to see reviews

Add a Review for this course

Please ensure that your review is respectful and constructive. Read about UBC's aim for creating a safe and inclusive learning environment here. These reviews may take several days to process and will be scanned for inappropriate or malicious content.

Please enter a name/username.
Enter a valid url including the 'https://' prefix. (https://www.example.com)
Please enter your course review. [minimum length: 50 characters]

Enter your UBC CWL email here to enter in a raffle to win 50% off a CSSS Hoodie ($22.50 value) or one of five $10 AMS gift cards! Each course review is an entry in the raffle, with a maximum of five entries per person. Raffle will take place at the end of the 2022W2 term. This email will not be visible on the published review.

Email must end in ubc.ca.

Course is well-taught and not too difficult, but quickly gains a lot of content and can be pretty dry at times. No programming or very little involved (some SQL). Took this class with Ed Knorr, his marking scheme is very helpful for students. There are pre-class and in-class exercises with frequent deadlines, but they’re not difficult. Assignments had good instructions on what to follow.
KF, Feb 14 2023, course taken 2022W1
Course is taught well but the material becomes complicated pretty quickly. Took it w Ed Knorr and he had a student-friendly grading policy (3 midterms with worst one being replaced by your final if the latter is better). Each midterm was a month apart and no major assignments that take over your weekends. You could get 13% right-away on the course via clickers, In-Class/Pre-class exercises that are graded based partially on effort and correctness.
HK, Feb 6 2023, course taken 2022W1

Historical grade information

Grades information from UBC Grades Database