Class Materials and Deliverables Listing


Week 

Tuesday

Thursday

1

1/19

Before Class:
  • Purchase your textbook "Databases Demystified" a.k.a DbD
In Class:

1/21

Before Class:
In Class:
2

1/26

Before Class:
In Class:

1/28

Before Class:
In Class:
3

2/2

Before Class:
In Class:

2/4

Before Class:
In Class:
4

2/9

Before Class:
In Class:
  • Demo: SQL Select Statement, Joins
  • Turn in S04, L03

2/11

Before Class:
In Class:
5

2/16

No Class: -illness
  • No Class

2/18

In Class:
  • Work on A1
6

2/23

Before Class:
In Class:
  • Demo: SQL Aggregates, sub-queries, views
  • Turn in S05, L04

2/25

Before Class:
In Class:
7

3/2

Before Class:
In Class:
  • Demo: SQL Programming Stored Procedures / Functions
  • Turn in S06, L05

3/4

Before Class:
In Class:
8

3/9

Before Class:
In Class:
  • Review for Exam 1
  • Turn in L06

3/11

Before Class:
  • Study for Exam 1
In Class:
9

3/16

No Class:
  • Spring Break

3/18

No Class:
  • Spring Break
10

3/23

Before Class:
In Class:

3/25

Before Class:
In Class:
11

3/30

Before Class:
  • Read: DbD Chapter 7 and 8
  • Watch: Understanding Logical Modeling
  • Notes: Logical Modeling
  • Complete Study Guide S09
In Class:

4/2

Before Class:
  • Watch: Logical Data Modeling with Microsoft Visio
In Class:
12

4/6

Before Class:
  • Read: DbD Chapter 6
  • Watch: Understanding Data Normalization
  • Notes: Data Normalization
  • Complete Study Guide S10
In Class:
  • Slides: Normlization
  • Normalization Exercises
  • Turn in S10, L09

4/8

Before Class:
  • Watch: Data Normalization
In Class:
13

4/13

Before Class:
  • Putting it all together Conceptual, Logical, Normalization case study
  • Read: Cheep Web Hosting Case Study
  • Complete Study Guide: S11 (conceptual and logical model for the case study)
In Class:
  • Discuss your diagrams for the case study - CWH
  • Turn in S11

4/20

Before Class:
  • Complete lab L11 (Normalization of the case study sample data)
In Class:
  • Discuss your normalized data model
  • Turn in : L11
14

4/20

Before Class:
In Class:

4/22

Before Class:
  • None
In Class:
15

4/27

Before Class:
In Class:

4/29

Before Class:
  • None
In Class:
16

5/4

Before Class:
In Class:
  • Q and A session on Practice Exams and Answers
  • Turn in L13

5/6

Before Class:
  • Study for Exam 2
  • Your in-class exam will be the same format as the practice exam.
In Class: