Class Materials and Deliverables Listing


Week 

Monday

Wednesday

1

1/17 -*** No Classes ***

Before Class:
  • Buy your textbook "Databases Demystified" a.k.a DbD
In Class:
  • No Class! MLK Day!

 

1/19 - Introduction / The Database Environment

Before Class:
In Class:
2

1/24 - The database development process / Relational model

Before Class:
In Class:

1/26 - LAB: Introduction to a DBMS  / Relational Model

Before Class:
In Class:
3

1/31 - Introduction to SQL

Before Class:
In Class:

2/2 - LAB: Introduction to SQL

Before Class:
In Class:
4

2/7 - The SQL SELECT statement

Before Class:
In Class:
  • Quiz: Q02
  • Demo: SQL Select Statement, Joins (uses Fudgemart data)

2/9 - LAB: The SQL Select Statement & more DML

Before Class:
In Class:
5

2/14 - Advanced SQL Select  & views

Before Class:
In Class:
  • Quiz: Q03
  • Demo: SQL Aggregates, sub-queries, views
  • Sample Code: Aggregates

2/16 - LAB: SQL Select Aggregates, Sub-Selects, Views

Before Class:
In Class:
6

2/21 - SQL Programming

Before Class:
In Class:

2/23 - LAB: SQL Programming

Before Class:
In Class:
7

2/28 - Data and Database Administration

Before Class:
In Class:

3/2 - LAB: Transaction Management, Security

Before Class:
In Class:
8

3/7 - Review for Exam 1

Before Class:
  • Lab Deliverable L06 due today
In Class:

3/9 - LAB: Exam 1

BBefore Class:
In Class:
  • Exam 1 (E01)
9

3/14 - *** No Classes ***

Before Class:
  • No class
In Class:
  • Spring Break!

3/16 - *** No Classes ***

Before Class:
  • No Class
In Class:
  • Spring Break!
10

3/21 - Database Analysis - Data Modeling

Before Class:
In Class:

3/23 - LAB: Conceptual Modeling in Visio

Before Class:
  • Watch: Conceptual Data Modeling with Microsoft Visio
In Class:
11

3/28 - Logical Database Design, Mapping

Before Class:
  • Read: DbD Chapter 7 and 8
  • Watch: Understanding Logical Modeling
  • Notes: Logical Modeling
  • Lab Deliberable L07 due today
In Class:

3/30 - LAB: Mapping to the Logical Model

Before Class:
In Class:
12

4/4 - Logical Database Design - Normalization

Before Class:
  • Read: DbD Chapter 6
  • Watch: Understanding Data Normalization
  • Notes: Data Normalization
  • Lab Deliverable L08 due today
In Class:

4/6 - LAB: Data Normalization

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

4/11 - Data Modeling - Putting it all together

Before Class:
In Class:

 

4/13 -  Data Modeling start to finish

Before Class:
  • Do the normalization for the case study sample data
In Class:
  • Discuss your normalized data model
  • Compare and contrast both logical models
  • Common Sense Model
14

4/18 - Physical Database Design, Data Migration

Before Class:
In Class:

4/20 - LAB: Data Migration

Before Class:
  • Watch: Data Migration in Action
In Class:
15

4/25 - Review for Exam 2

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

 4/27 - LAB: Exam 2

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

5/2 -  Client/Server, Distributed Databases

Before Class:
In Class:

5/4 - *** No Class ***

No Class: