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 20 -- Hoffer: Ch. 1

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

    Assignment 1 assigned (Jan 27)

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

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

    Assignment 2a and 2b assigned

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

    Assignment 1 due (Feb 17)

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

    Assignment 2a due (Feb 24)

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

    Source code from class

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

    Source code from class

    Assignment 2b due (Mar 10)

    Assignment 3 assigned

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

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

  11. Slides from Lecture 17 download PPT
  12. Additional Slides from Lecture 17 download PPT
  13. Assignment 3 due Apr 4

  14. Spring Break
  15. Data Warehouses - Intro. & Database Application Building Workshop -- Apr 7 Hoffer: Ch. 9

  16. Big Data Introduction - MapReduce, HBase, Hive, Pig -- Apr 14

  17. Final Project Workshop -- Apr 21

  18. Guest Speaker -- Apr 28

  19. Final Project Presentations -- May 5

    Assignment 4 due May 5