Monday

Wednesday

Friday

January

7

9 (Wednesday)

Introduction, policies, syllabus. What is data? What is a database? (notes)

Project 0: Introduce assigned

Reading: Skim Chapters 1 & 2

10 (Thursday)

High level view - architectural concerns, client-server architecture. History of databases.  Modern developments. (notes)

Reading: Chapter 6: “Basic SQL”

11

Informal introduction to queries in SQL. (notes)

Project 0 due

Project 1: Connect assigned

14

SQL functions and operators. (notes)

16

Joins; naming. (notes)

18

Types; table creation. (notes)

Project 1 due

Project 2: Query (1) assigned

21

Martin Luther King Jr. Day

23

Insert, update, and delete. (notes)

Reading: Chapter 5: “The Relational Data Model and Relational Database Constraints”

25

Constraints, keys, indexes. (notes)

Project 2 due

Project 3: Make assigned

28

Miscellaneous DDL – default column values, sequences, ALTER TABLE, views, indexes, DROP. (notes)

Reading: Chapter 7: “More SQL: Complex Queries, Triggers, Views, and Schema Modification”

30

Subqueries. (notes)

February

1

Grouping and aggregation. (notes)

Project 4: Query (2) assigned

Project 3 due

4

Miscellaneous topics: DISTINCT, JOIN, set operations, WITH, bulk loading, workflow (notes)

6

Miscellaneous, continued.

8

Database modeling & design

Entity-Relationship Diagrams (ERD) (notes)

Reading: Chapter 3: “Data Modeling Using the Entity-Relationship Model”

11

ERD, continued.

Project 4 due

Reading: Chapter 9.1: “Relational Database Design Using ER-to-Relational Mapping”

13

(maybe) ERD, continued.

Quiz 1 review.

15

Quiz 1 (SQL)

18

President’s Day

20

ERD, continued.

22

CLASS CANCELED

25

Converting ERD to a SQL database. (notes)

Project 5: Design assigned

27

Functional dependencies. (notes)

Reading: Chapter 14: “Basics of Functional Dependences and Normalization for Relational Databases”, through section 14.6

March

1

NO CLASS

4

Normalization; Boyce-Codd normal form. (notes)

6

Go over quiz 1.

Multivalued dependencies and 4th normal form. (notes)

Project 5 due

8

Programming against the database (overview). (notes)

Project 6: Convert assigned

Project 9: Create (final project) assigned

11

Programming against the database: Python (example code)

13

SNOW DAY – Class canceled

15

Programming against the database: Java (example code)

18

Project 6 due

Quiz 2 (ERD)

20

Server-side programming

22

Project 7: Normalize assigned

Project 6 due

25

SPRING BREAK

27

29

April

1

Guest lecture – Dr. Wendy Fisher

3

Guest lecture on Security - Weiping Pei and Ahmed Alshehri

5

Guest lecture on ORM – Taylan Dillion

8

Disks, file organization, B-Trees, indexing (notes)

Reading: Chapter 18: “Strategies for Query Processing”

10

CLASS CANCELED

Project 7 due

12

E-Days

15

Quiz 3 (Normalization)

Extra Credit Project: Program assigned

17

B-Trees, etc., continued

19

Return quizzes

Intro to NoSQL (notes)

22

Midterm review

24

Midterm exam (in class)

26

MongoDB

29

May

1

Project 9 due

Extra credit project due

3

Dead Day