IS 257: Database Management

Description

Mission statement

Outline & Schedule

Instructor / TA

Enrolling

Grading

Assignments

Final Project

Workshop Materials

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

   • Slides from Lecture 1 download

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

   • Slides from Lecture 2 download PPT download PDF
   • Slides from Lecture 3 download PPT download PDF

   Assignment 1 assigned (Jan 27)

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

   • Slides from Lecture 4 download PPT

   • Slides from Lecture 5 download PPT

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

   • Slides from Lecture 6 download PPT

   • Slides from Lecture 7 download PPT

   Assignment 2a and 2b assigned

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

   • Slides from Lecture 8 download PPT
   • Slides from Lecture 9 download PPT

   Assignment 1 due (Feb 17)

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

   • Slides from Lecture 10 download PPT download PDF
   • Slides from Lecture 11 download PPT download PDF

   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
   
   
   • HTML Tutorial
     • Focus on Elements, Attributes, Headings, Paragraphs, Links, Tables, Lists, Forms, Form Elements, Input Types, and Input Attributes
   • Bootstrap Tutorial
     • Focus on Grid Basic, Typography, Tables, Alerts, Buttons, Forms, and Inputs
   • Flask Tutorial
     • Flask and Python Tutorial

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

   Source code from class
   
   
   • Flask Tutorials
     • Flask and Python Tutorial
     • Python + SQLite
   • Bringing it all together
     • How to build a database driven web app part 1
     • How to build a database driven web app part 2

   Assignment 2b due (Mar 10)

   Assignment 3 assigned

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

   • Slides from Lecture 15 download PPT download PDF
   • Slides from Lecture 16 download PPT download PDF

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

Assignment 3 due Apr 4

13. Spring Break

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

    • Slides from Lecture 19 download PPT

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

    • Slides from Lecture 22 download PPT download PDF
    • Slides from Lecture 23 download PPT download PDF

16. Final Project Workshop -- Apr 21

17. Guest Speaker -- Apr 28

18. Final Project Presentations -- May 5

    Assignment 4 due May 5