UC Berkeley School of Information

IS 257: Database Management

Announcements

Description

Mission statement

Concepts

Outline & Schedule

Instructor / TA

Enrolling

Grading

Assignments

Laboratory

Textbooks

Useful links

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

  2. Database planning and Conceptual Design -- Sep 2, 4 -- Hoffer: Ch. 2 & 3 & 14

  3. TBA --
    Sep 9, 11 -- Hoffer: Ch. 4 & 5

    • Workshop on SQL
    • Workshop on Personal DB

  4. Organizing Information into a Database (logical database design) & Normalization --
    Sep 16, 18 -- Hoffer: Ch. 4 & 5

    Assignment 1 due Thurs Sep 18th.

  5. Relational DBMS & Relational Algebra and Calculus : Introduction to SQL -- Sep 23, 25 -- Hoffer: Ch. 7 & App. C

  6. Database Design: Physical Design and Access Methods -- Sept 30, Oct. 2 -- Hoffer: Ch. 7

  7. Physical Design & Intro. to Database Applications -- Oct 7, 9 -- Hoffer: Ch. 8

  8. Database Applications & PHP & JDBC -- Oct 14, 16 -- Hoffer: Ch. 10

  9. Database Security and Integrity & Database Administration -- Oct 21, 23 -- Hoffer: Ch. 10

  10. Object-Relational DBMS & Triggers and User-Defined Functions & NoSQL -- Oct 28, 30 -- Hoffer: Ch. 12

    • Slides from Lecture 14 download
    • Slides from Lecture 15 download NoSQL
    • Assignment 3 due Thursday Oct. 30st.

  11. Database Application Building Workshop -- Nov 4, 6 Hoffer: Ch. 9

  12. Data Warehouses, Data Mining and Text Mining Applications -- Nov 11, 13

    • Slides from Lecture 16 download
    • Assignment 4 due Thursday Nov. 13th.

  13. Big Data and Databases -- Nov 18, 20

  14. MapReduce, HBase, Hive -- Nov 25, 27

    • Slides from Lecture 19 download
    • Thanksgiving Holiday Thursday

  15. Big Data and NewSQL & Wrapup -- Dec 2, 4

  16. RRR Period -- Dec 10, 12

    • RRR Period - no lectures

  17. Final Project Papers Due & Presentations -- Dec 15 & 16

    • Dec 15 RRR Period ends.
    • Dec 15 12:00-2:00 OPTIONAL Final Project Presentations (1).
    • Dec 16 12:00-2:00 OPTIONAL Final Project Presentations (2) & Final Project papers due.