Databases are at the heart of modern commercial application development. Their use extends beyond this to many other environments and domains where large amounts of data must be stored for efficient update, retrieval, and analysis. The purpose of this course is to provide a comprehensive introduction to the use of management systems for applications. Some topics covered are the following: data models, query languages, query evaluation and optimisation, database design and transactions.
Instructor:
Babak Salimi, bsalimi@ucsd.edu
Course Assistants:
Aditya Lahiri, adlahiri@ucsd.edu
Divija Devarla, ddevarla@ucsd.edu
Lectures:
The lecture for this class will be ASYNCHRONOUS and discussion sections will be SYNCHRONOUS.
Discussion::
Wednesdays 4:00 pm to 4:50 pm
Office Hours:
Mondays 2:00pm to 3:00pm (Gaurav)
Tuesdays 1:00pm to 2:00pm (Divija)
Thursdays 3:30pm to 4:30pm (Babak)
Fridays 10:00am to 11:00am (Aditya)
Zoom Meetings:
Links to the Zoom meetings will appear on the course’s Canvas page.
Piazza: https://piazza.com/ucsd/fall2021/dsc100 (Requires access code posted on Canvas)
Have questions? Please email both Babak Salimi (bsalimi@ucsd.edu) and one of the TAs for questions on logistics. All other questions SHOULD be discussed on Piazza.
(subject to change)
Homework (60%): There will be weekly homeworks. They will be based on the last 1-2 lectures. They are of two types:
Extra Credit:
Book: Although a textbook is not required in the course, the following textbook is optional and recommended. Lecture slides and recorded videos would be sufficient for this class.
Database Systems: The Complete Book, by Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom. 2nd Edition. Prentice Hall. 2008.
Canvas: All weekly homework assignments should be turned in via Canvas.
Gradescope: We will use Gradescope for submission and grading of exams.
Communication and Piazza: All important announcements will be sent through both Piazza and Canvas.
All questions that may be of general interest to the class should be directed to Piazza. You will get your questions answered faster on Piazza than via personal emails to the instructional team, because Piazza is monitored closely by everybody in the class, not just the course staff. You are highly encouraged to answer each others’ questions on Piazza (you will get extra credit for # of good answers on Piazza!) and the instructional team would endorse/add to those answers.