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.17 / 5
Average quality
3.67 / 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]
3
3

Not a difficult course at all, got an easy 85% but not a great course either. Not relevant to the current industrial landscape either. Very disorganized under Laks. Tuition is expensive, spend that money on a course that will be worth it. This course is not it.
Difficulty:2
Quality:1
Jose Cuervo, Jun 17 2025, course taken 2024W2
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.
Difficulty:3
Quality:5
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.
Difficulty:4.5
Quality:5
HK, Feb 6 2023, course taken 2022W1

Historical grade information

Grades information from UBC Grades Database