CSE 132A: Database Systems Principles

What this course is about

The course presents the basic concepts of database systems, emphasizing the relational model. Several major issues of relational database theory are covered: relational queries (algebra and calculus), query processing, data dependencies and their use in schema design and query optimization, basic concurrency control. Students become familiar with SQL and JDBC. Working knowledge of Java is assumed.


Requirements and tentative weights

Two SQL Labs, each counting for 3% of the final grade (6% total)
Three written problem sets, counting for 5%, 2%, and 3% of the final grade (10% total)
An SQL programming assignment, which counts for 17% of the final grade
A JDBC programming assignment, which counts for 17% of the final grade
One midterm, which counts for 25% of the final grade
A final exam, which counts for 25% of the final grade

All assignments are individual.


Logistics

The class website will be hosted on Canvas. Lectures will be delivered remotely, sychronously via zoom and recoded for asynchronous viewing. Attendance is optional but strongly encouraged. The lecture recordings will be made available on Canvas and lecture slides will be posted at least one day before each lecture. The weekly discussion session and the exams will take place in person. Office hours will be offered both in person and via zoom.


Contact

For questions please contact the instructor, Victor Vianu, at vianu@ucsd.edu