UC Berkeley School of Information

INFO 257: Database Management

Outline and Schedule

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

Lecture slides and workshops/labs can be found HERE

(Week. Content -- dates)

  1. Introduction to database concepts & Data Models -- Jan 23

    Readings

    • Hoffer: Ch. 1 - DB Environment and Development Process
    • Docker 101
  2. Database planning and Conceptual Design -- Jan 30

    Readings

    Docker Workshop 1 assigned

    Assignment 1 assigned

  3. SQL and Database Access -- Feb 6

    Readings

    • Hoffer: Ch. 5 - Introduction to SQL
    • Hoffer: Ch. 6 - Advanced SQL - Processing Multiple Tables - (Equi, Natural, Outer and Self Join Sections)

    Assignment 2a assigned

  4. Organizing Information into a Database (logical database design) & Normalization -- Feb 13

    Readings

    • Hoffer: Ch. 4 - Logical DB Design and the Relational Model
    • Hoffer: Ch. 6 - Advanced SQL

    Assignment 2b assigned

  5. Enhanced ER Model and Normalization -- Feb 20

    Readings

    • Hoffer: Ch. 3 - Enhanced ER Model
    • Hoffer: Ch. 4 - Introduction to Normalization

    Assignment 1 & 2a Due (Feb 20)

  6. Physical Design & Intro. to Database Applications -- Feb 27

    Readings

    • Hoffer: Ch. 7 - DBs in Applications
  7. Python + Workshop I: Creating database driven web applications -- Mar 5

  8. Python + Workshop II: Creating database driven web applications -- Mar 12

  9. Assignment 2b due (Mar 12) & Assignment 3 Assigned
  10. NoSQL and NewSQL -- Mar 19

  11. Spring Break -- Mar 26

  12. Database Design: Physical Design and Access Methods -- Apr 2

    Readings

    • Hoffer: Ch. 8 - Physical DB Design and DB Infrastructure
  13. Database Administration - Backup and Recovery & Object-Relational DBMS -- Apr 9

  14. Data Warehouses -- Apr 16

  15. Big Data Introduction - MapReduce, HBase, Hive, Pig -- Apr 23

  16. Final Project Workshop -- Apr 30

  17. Final Project Presentations -- May 7

    • Final Project Presentations