Course Schedule and Materials

Attention: schedule is tentative and will be updated! - Last updated on July 27, 2010

Session
Topic/Readings
Lecture/Activities
Reminder
1. 06/14/2010

Course overview

Reading: Syllabus

- Attendance and survey

Software Training:
- Elluminate Live
- uLearn

 First class meet in the classroom CS 203

Part 1: Basic Concepts

2. 06/16/2010

Introduction to Relational Database

Reading: chapter 1, chapter 3 (part 1)

Lecture:
- Introduction to database [new]
- Relational model [new]

Software Training:
- MS Access Review
(Northwind database Access file)
- SQL Server 2008: Introduction [new] (Northwind database SQL Server file)

  
3. 06/21/2010

Database Query

Reading:
- Chapter 2, sqlcourse2.com
- Chapter 10

Lecture: Database Query with SQL [new]

Software Training:
- SQL Server 2008: Database Query [new](Northwind database SQL Server file)

  
4. 06/23/2010

Normalization

Reading:
- Chapter 3 (part 2)
- Normalization in Wikipedia: up to 3NF

Lecture: Normalization [new]

  

Part 2: Designing Database

5. 06/28/2010

Database Design using ERD

Reading:
- Database development life cycle (section 2 to 6)
- Chapter 5

Lecture:
- Database design [new]
- Conceptual Design using ERD [new]

Software Training:
- Visio 2010: Intro and ERD [new]
(Visio example)

  
6. 06/30/2010

Logical Design

Reading:
- Chapter 6

Lecture: Logical Design [new]

Software Training:
- Visio 2010: Logical Model [new]
(Visio example same as last session)

Semester Mid-point
7. 07/05/2010

Independence Day!

    
8. 07/07/2010

Physical Design and Implementation

Reading:
- Chapter 7 (DDL)

Lecture: Physical Design and DDL [new]

Software Training:
- SQL Server 2008: creating tables and editing data [new]
(DDL script example)
9. 07/12/2010

Mid-term summary and exam preparation.

Exam 1 Guide

  
10. 7/14/2010

Mid-term Exam

    

Part 3: Managing and Using Database
11. 7/19/2010

Database Applications

Reading:
- Chapter 7, 10, 11

Lecture:
- Database Applications and Programmability Overview [new]

Software Training:
- SQL Server 2008 for MS Office [new]

  
12. 7/21/2010

More SQL Query

Reading:
- Chapter 2, 7

Lecture:
- Advanced SQL Query [new]
(Northwind database SQL Server file)

  
13. 7/26/2010

XML and Database

Reading:
- Chapter 12

Lecture:

- XML: Introduction [new]
- XML: from Relational Data [new]
(XML examples)

  
14. 7/28/2010

Business Intelligence

Reading:
- Chapter 13

Lecture:
- Business Intelligence [new]
- Data Warehouse and OLAP [new]
(miniDW.zip)

Software Training:
- Pivot Table and Diagram with Excel, Vsio and SQL Server 2008 [new]

  
15. 8/02/2010 Semester summary, catch-up, and exam preparation.    
16. 8/04/2010

Final exam

Final exam guide