IT 4153: Advanced Database

Course Schedule and Materials

Attention: schedule is tentative and will be updated! - Last updated on Mar 30, 2012

** Reading chapters from the textbook: n/a

Week

Date

Topics / Activities / Readings**

Lecture Materials / Resources / Downloads

Work Due and Reminders

1 Jan 9, 11

Course overview; attendance; survey.

Reading: syllabus and tutorial on the right

Downloads: Syllabus

Tutorial: SQL Server Introduction

Example: Northwind sample database (zip)

 
2 Jan 18

Database basics review

Reading:
- Database management system
- Database development life cycle

Lecture Notes: Relational Database Basics Review

Lab 1
3 Jan 23, 25

Advanced modeling and design

Reading:
- Lecture notes
- Data Modeling
- Design basics review - Orlando's notes chapter 2, 3, 6.
- Dr. Chen's Notes on EER

Lecture Notes: Database Design Issues

Tutorial: Visio Database Model

Exercise: Data Modeling and Design

 
4 Jan 30
Feb 1

Database Implementation with SQL Server

Reading: Lecture notes, tutorial

Lecture Notes: Physical Design with SQL Server

Tutorial: Creating Databases in SQL Server

Example: DDL-Project

Lab 2
5 Feb 6, 8

Advanced select query

Reading:
- SQL review
- Lecture notes

Lecture Notes:
- SQL Select Query: Intermediate
- SQL Select Query: Advanced

Exercise: SQL Select Query (all)

 
6 Feb 13, 15

XML and database

Reading:
- Lecture notes
- Hierarchical vs relational xml schema
- Overview of SQL Server XML data type

Lecture Notes:
- XML in Database
- XML Schema

Tutorial: SQL Server SELECT FOR XML

Exercise
- FOR XML
- XML data type

Lab 3
7 Feb 20, 22

Midterm test

  Test 1
8 Fb 27, 29

Midterm summary
- Test review
- Project meetings

Project overview

Feb 28 withdraw day
9 Mar 5, 7

Spring break!

   
10 Mar 12, 14

Database scriting

Reading:
- Working wth T-SQL Variables
- T-SQL if and case

Lecture Notes: T-SQL Bascis

Exercise: T-SQL, Stored Procedure, and Function

Project proposal and plan
11 Mar 19, 21

Database programmability

Reading:
- Stored Procedures

Exercise: T-SQL, Stored Procedure, and Function

Lab 4
12 Mar 26, 28

Data integrity

Reading:
- Triggers
- Transactions

Project meetings

Lecture Notes: Data Integrity

Exercise: Transaction and Triggers

Project progress report 1
13 Apr 2, 4

Business Intelligence

Reading:
- Lecture notes
- SSAS 2008 Tutorial

Lecture Notes:
- Introduction to BI
- Data Warehouse and OLAP

Tutorial: SQL Server OLAP - miniDW

Lab 5
14 Apr 9, 11

Data transfer and integration

Reading:

Guest Speaker - Michael Morgan (April 9)

Project meetings

Download: Guest Lecture

Project progress report 2
15 Apr 16, 18

Test 2

  Test 2 - Monday
16 Apr 23, 25 Project presentations    
17 Apr 30 Course summary   Project report