INFO 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.

Lecture slides and workshops/labs can be found HERE

(Week. Content -- dates)

1. Introduction to database concepts & Data Models -- Jan 23

   Readings

   • Hoffer: Ch. 1 - DB Environment and Development Process
   • Docker 101

2. Database planning and Conceptual Design -- Jan 30

   Readings

   • Hoffer: Ch. 2 - Modeling Data in the Organization
   • Zachman Framework

   Docker Workshop 1 assigned

   Assignment 1 assigned

3. SQL and Database Access -- Feb 6

   Readings

   • Hoffer: Ch. 5 - Introduction to SQL
   • Hoffer: Ch. 6 - Advanced SQL - Processing Multiple Tables - (Equi, Natural, Outer and Self Join Sections)

   Assignment 2a assigned

4. Organizing Information into a Database (logical database design) & Normalization -- Feb 13

   Readings

   • Hoffer: Ch. 4 - Logical DB Design and the Relational Model
   • Hoffer: Ch. 6 - Advanced SQL

   Assignment 2b assigned

5. Enhanced ER Model and Normalization -- Feb 20

   Readings

   • Hoffer: Ch. 3 - Enhanced ER Model
   • Hoffer: Ch. 4 - Introduction to Normalization

   Assignment 1 & 2a Due (Feb 20)

6. Physical Design & Intro. to Database Applications -- Feb 27

   Readings

   • Hoffer: Ch. 7 - DBs in Applications

7. Python + Workshop I: Creating database driven web applications -- Mar 5

   Python + Flask Workshop I

8. Python + Workshop II: Creating database driven web applications -- Mar 12

Python + Flask Workshop II

• 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
Assignment 2b due (Mar 12) & Assignment 3 Assigned

9. Big Data Technologies - NoSQL and NewSQL -- Mar 19

   Readings

   • Hoffer: Ch. 10 - Big Data Technologies

10. Spring Break -- Mar 26

11. Database Design: Physical Design and Access Methods -- Apr 2

    Readings

    • Hoffer: Ch. 8 - Physical DB Design and DB Infrastructure

12. Data Warehousing -- Apr 9

    Readings

    • Hoffer: Ch. 9 - Date Warehousing and Data Integration

13. Analytics -- Apr 16

    Readings

    • Hoffer: Ch.11 - Analytics and its implications

14. Big Data - MapReduce, Hive, Pig -- Apr 23

    Readings

    • Hoffer: Ch.10 - Big Data Technologies

15. Final Project Workshop -- Apr 30

16. Final Project Presentations -- May 7

    • Final Project Presentations