IS 257: Database Management

Description

Mission statement

Outline & Schedule

Instructor / TA

Enrolling

Grading

Assignments

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 19 -- 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
   • Slides from Lecture 3 download PPT

   Assignment 1 assigned (Jan 26)

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 9 -- 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 16 -- Hoffer: Ch. 5

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

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

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

   Assignment 2a due (Feb 23)

   Assignment 1 due (Feb 27)

7. Python + Flask Workshop I: Creating database driven web applications Mar 2 -- 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 Mar 9

   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
   • Slides from Lecture 13 download PPT download PDF
   • Slides from Lecture 14 download PPT download PDF

   Assignment 2b due (Mar 9)

   Assignment 3 assigned

9. Database Administration - Backup and Recovery & Object-Relational DBMS -- Mar 16 -- 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 23 -- Hoffer: Ch. 12

11. Slides from Lecture 17 download PPT
12. Additional Slides from Lecture 17 download PPT
//-
13. The slides below have similar content, but are not exactly the same as the videos shown in class: video 1 - Mike Stonebraker video 2 - VoltDB Architecture
14. Slides similar to Lecture 18 (Stonebraker) download PPT download PDF
15. Additional Slides from Lecture 18 (VoltDB Internals) download PPT download PDF
//-

Assignment 3 due Apr 3

16. Spring Break

17. Data Warehouses - Intro. & Database Application Building Workshop -- Apr 5 Hoffer: Ch. 6

    • Slides from Lecture 19 download PPT

18. Big Data Introduction - MapReduce, HBase, Hive, Pig -- Apr 13

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

19. Final Project Workshop -- Apr 20

    • Slides from Lecture 24 Intro. (sorry but no slides for the video) download PPT download PDF

20. TBD Apr 27

    • Slides from Lecture 25 download PPT download PDF
    • Slides from Lecture 26 download PPT download PDF
    -->

21. Final Project Presentations -- May 4

    Assignment 4 due May 4

    • Final Project Presentations