The CSE 180 course (Database Systems I) covers concepts, approaches, tools, and methodology of database design and querying.
Topics in CSE 180 include:
- Relational Data Model and its history
- SQL language: Data Definition, Queries and Updates, Indexes, Views, Constraints, Rules/Triggers
- Relational Algebra, Query Execution and Transaction Processing
- Database Application Development
- Design Theory: Schemas and Normal Forms
- On-Line Analytical Processing (OLAP)
- Semi-Structured Data Models: XML, JSON, etc.
- Big Data and NOSQL (time permitting)
Lots of practical material and logic, and lots of concepts and theory, particularly in the second half of the course, which most students find ***much tougher*** than the first half of the course.
Students who do not attend Lectures and Labs tend to do poorly in this course. Please keep that in mind if you want to pass this class.
Textbook: “A First Course in Database Systems”, Jeffrey Ullman and Jennifer Widom, Prentice-Hall, 3rd edition. Textbook can be ordered new/used, e.g., from the UCSC Bay Tree Bookstore site, http://www.ucsc.verbacompare.com Kindle ebook is available for a textbook (based on 2cd edition of our textbook but covering other materia as welll, “Database Systems: The Complete Book”, Hector Garcia-Molina, Jeffrey Ullman and Jennifer Widom, Prentice-Hall, 2cd edition.
Some other good database books (not used in this course)
* “Database Management Systems”, 3rd edition, Ramakrishnan and Gehrke, McGraw-Hill.
* “Database System Concepts”, 7th edition, Silberschatz, Korth and Sundarshan, McGraw-Hill. (ebook is here.)
[Science and Engineering Library has these textbooks on Reserve.]
-------------------
General Information
CSE 180, Database Systems I, Fall 2020, via Zoom.
Zoom URLs:
Shel (Lecture and Office Hours): ShelZoomID
Sonali (Lab Section and Office Hours): SonaliZoomID
Jesh (Lab Section and Office Hours): JeshZoomID
Instructor: Sheldon (Shel) Finkelstein, shel@ucsc.edu
Classes: MWF 1:20pm - 2:25pm, via Zoom
Office Hours: Wednesday 9:00am –10:00am
(or by appointment)
Teaching Assistants:
Sonali Suri, sosuri@ucsc.edu
Office Hours:
Monday, 11:00am - noon
Friday, noon – 1:00pm
(or by appointment)
Jeshwanth (Jesh) Bheemanpally, jbheeman@ucsc.edu
Office Hours:
Tuesday, 11:00am-noon
Friday, 5:20pm - 6:20pm
(or by appointment)
Lab Sections, also via Zoom
01A: Tuesday, 3:20pm-5:05pm, Jesh
01B: Wednesday, 4:00pm-5:35pm, Sonali
01C: Thursday, 9:50am-11:25am, Jesh
[There will not be a Lab Section on Thursday, October 1.]
Course Evaluation:
- Gradiance Homeworks 10%
- Lab Assignments 20%
- Midterm 30%
- Final Exam 40%
See Syllabus for tentative Lecture schedule, Homework info, Lab Assignment dates, Midterm/Final dates, and other information about this course, including Learning Support Center, Title IX Statement, Academic Integrity Policy, and Disability Resource Center.
You are responsible for checking Piazza for class announcements, assignments and news. Please post questions on Piazza (or via email), not on Canvas.