CS 348: lecture notes
Reference materials and sample programs are often copyrighted may be used only by the participants of the class.
Week 1:
Introduction
,
Database Management Systems
Mini-tutorial on using IBM/DB2 at UW
(
Assignment 0
,
Sample Database
)
Week 2:
no classes
Week 3:
Database Design: Entity-Relational Model
,
ER-to-Relational
Week 4:
Relational Model, Queries and Constaints
Week 5:
SQL Basics
,
SQL with Duplicates and Aggregates
(
Samples
(Results)
Samples
(Results)
Samples
(Results)
)
Week 6:
SQL Syntactic Sugar
,
SQL Data Manipulation
, (
Samples
(Results)
Samples
(Results)
),
midterm (tentatively)
Week 7:
Uknown Values/NULLS
,
Embedded SQL
(
Samples
)
Week 8:
Dynamic Embedded SQL
, (
Samples
),
midterm
Week 9:
X/Open CLI and ODBC
(
JAVA and SQL
,)
Basic Query Execution
Week 10:
Basics of Database Tuning and Query Optimization
Basics of Transaction Processing
Week 11:
Distributed Data and Information Integration
Functional Dependencies and Normal Forms
Week 12:
Other Dependencies
Extension to Query Languages
, review and slack