Outline and Schedule
This is a preliminary outline for the course. It is expected to change during the semester.
(Week. Content -- dates -- readings)
Introduction to database concepts & Data Models -- Aug 28 -- Hoffer: Ch. 1
- Slides from Lecture 1 download
Database planning and Conceptual Design -- Sep 2, 4 -- Hoffer: Ch. 2 & 3 & 14
TBA --
Sep 9, 11 -- Hoffer: Ch. 4 & 5- Workshop on SQL
- Workshop on Personal DB
Organizing Information into a Database (logical database design) & Normalization --
Sep 16, 18 -- Hoffer: Ch. 4 & 5Assignment 1 due Thurs Sep 18th.
Relational DBMS & Relational Algebra and Calculus : Introduction to SQL -- Sep 23, 25 -- Hoffer: Ch. 7 & App. C
Database Design: Physical Design and Access Methods -- Sept 30, Oct. 2 -- Hoffer: Ch. 7
Physical Design & Intro. to Database Applications -- Oct 7, 9 -- Hoffer: Ch. 8
Database Applications & PHP & JDBC -- Oct 14, 16 -- Hoffer: Ch. 10
Database Security and Integrity & Database Administration -- Oct 21, 23 -- Hoffer: Ch. 10
Object-Relational DBMS & Triggers and User-Defined Functions & NoSQL -- Oct 28, 30 -- Hoffer: Ch. 12
Database Application Building Workshop -- Nov 4, 6 Hoffer: Ch. 9
Data Warehouses, Data Mining and Text Mining Applications -- Nov 11, 13
- Slides from Lecture 16 download
- Assignment 4 due Thursday Nov. 13th.
Big Data and Databases -- Nov 18, 20
MapReduce, HBase, Hive -- Nov 25, 27
- Slides from Lecture 19 download
- Thanksgiving Holiday Thursday
Big Data and NewSQL & Wrapup -- Dec 2, 4
RRR Period -- Dec 10, 12
- RRR Period - no lectures
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.