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 27 -- Hoffer: Ch. 1
- Slides from Lecture 1 download
Database planning and Conceptual Design -- Sep 1, 3 -- Hoffer: Ch. 2 & 3 & 14
Organizing Information into a Database (logical database design) & Normalization --
Sep 8, 10 -- Hoffer: Ch. 4 & 5Database Design: Physical Design and Access Methods -- Sep 15, 17 -- Hoffer: Ch. 6 & App. C
Relational DBMS & Relational Algebra and Calculus : Introduction to SQL -- Sep 22, 24 -- Hoffer: Ch. 7
MySQL -- Sept 29, Oct 1 -- Hoffer: Ch. 7
- Tuesday: Kevin Heard on Using MySQL
- Thursday: No Class - workshop
More on MySQL & Database Applications -- Oct 6, 8 -- Hoffer: Ch. 8
Database Applications: Coldfusion and PHP & More on SQL & MySQL -- Oct 13, 15 -- Hoffer: Ch. 10
Database Security and Integrity & Database Administration -- Oct 20, 22 -- Hoffer: Ch. 12
Object-Relational DBMS -- Oct 27, Oct 29 Hoffer: Ch. 9
- Slides from Lecture 16 download
JDBC for Java Applications & Data Warehouses -- Nov 3, 5
Data Warehousing and Data Mining -- Nov 10, 12 -- Hoffer: Ch: 11
- No class on Tuesday
- Slides from Lecture 19 download
Data and Text Mining Applications -- Nov 17, 19 -- Hoffer: Ch. 13 & 15 & Appendix D.
- Slides from Lecture 20 download download WEKA slides
- Slides from Lecture 21 download
Future of DBMS -- Nov 24
- Slides from Lecture 22 download
- November 26&27 -- Thanksgiving Holiday
Wrapup : Class Project Demos -- Dec 1, 3
Final Projects Due -- Dec 8
- Dec 8 RRR Period - no lecture: Final final project papers due.