UC Berkeley School of Information

IS 257: Database Management

Outline and Schedule

This is a preliminary outline for the course. It is expected to change during the semester.

(Week. Content -- dates -- readings)

  1. Introduction to database concepts & Data Models -- Jan 19 -- Hoffer: Ch. 1

  2. Database planning and Conceptual Design -- Jan 27 -- Hoffer: Ch. 2 & 3 & 14

    Assignment 1 assigned (Jan 26)

  3. SQL and Database Access -- Feb 3 -- Hoffer: Ch. 6 & 7

  4. Organizing Information into a Database (logical database design) & Normalization -- Feb 9 -- Hoffer: Ch. 4 & 5

    Assignment 2a and 2b assigned

  5. Database Design: Physical Design and Access Methods -- Feb 16 -- Hoffer: Ch. 5

  6. Physical Design & Intro. to Database Applications -- Feb 23 -- Hoffer: Ch. 8

    Assignment 2a due (Feb 23)

    Assignment 1 due (Feb 27)

  7. Python + Flask Workshop I: Creating database driven web applications Mar 2 -- Hoffer: Ch. 7 & App. C

    Source code from class

  8. Python + Flask Workshop II: Creating database driven web applications Mar 9

    Source code from class

    Assignment 2b due (Mar 9)

    Assignment 3 assigned

  9. Database Administration - Backup and Recovery & Object-Relational DBMS -- Mar 16 -- Hoffer: Ch. 10

  10. Triggers and User-Defined Functions - NoSQL and NewSQL -- Mar 23 -- Hoffer: Ch. 12

  11. Slides from Lecture 17 download PPT
  12. Additional Slides from Lecture 17 download PPT
  13. //-
  14. The slides below have similar content, but are not exactly the same as the videos shown in class: video 1 - Mike Stonebraker video 2 - VoltDB Architecture
  15. Slides similar to Lecture 18 (Stonebraker) download PPT download PDF
  16. Additional Slides from Lecture 18 (VoltDB Internals) download PPT download PDF
  17. //-

    Assignment 3 due Apr 3

  18. Spring Break
  19. Data Warehouses - Intro. & Database Application Building Workshop -- Apr 5 Hoffer: Ch. 6

  20. Big Data Introduction - MapReduce, HBase, Hive, Pig -- Apr 13

  21. Final Project Workshop -- Apr 20

  22. TBD Apr 27

    -->
  23. Final Project Presentations -- May 4

    Assignment 4 due May 4

    • Final Project Presentations