Course overview; attendance; survey.

Reading: syllabus and tutorial on the right

Downloads: Syllabus

Tutorial: SQL Server Introduction

Example: Northwind sample database (zip)

Database basics review

Reading:
- Database management system
- Database development life cycle

Lecture Notes: Relational Database Basics Review

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

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

Advanced select query

Reading:
- SQL review
- Lecture notes

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

Exercise: SQL Select Query (all)

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

Midterm test

Midterm summary
- Test review
- Project meetings

Project overview

Spring break!

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

Database programmability

Reading:
- Stored Procedures

Exercise: T-SQL, Stored Procedure, and Function

Data integrity

Reading:
- Triggers
- Transactions

Project meetings

Lecture Notes: Data Integrity

Exercise: Transaction and Triggers

Business Intelligence

Reading:
- Lecture notes
- SSAS 2008 Tutorial

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

Tutorial: SQL Server OLAP - miniDW

Data transfer and integration

Reading:

Guest Speaker - Michael Morgan (April 9)

Project meetings

Download: Guest Lecture

Test 2