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 Gradiance SQL Labs, each counting for 2% of the final grade (4% total)
Three written problem sets, counting for 4%, 2%, and 3% of the final grade (9% total)
An SQL programming assignment, which counts for 14% of the final grade
A JDBC programming assignment, which counts for 13% of the final grade
One midterm, which counts for 30% of the final grade
A final exam, which counts for 30% of the final grade

All assignments are individual.

Logistics

The class website is hosted on Canvas. Lectures and discussions and will be podcast. Attendance is optional but strongly encouraged. Lecture slides will be posted at least one day before each lecture. 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