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 are expected to be delivered in-person and will be podcast. Attendance is optional but strongly encouraged. Lecture slides will be posted at least one day before each lecture. The weekly discussion sessions are optional and will be podcast. Office hours will be offered daily. The exams will take place in person.


Contact

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