CSE444 Introduction to Database Systems - Autumn 2007

CSE Home

About Us

Search

Contact Info

Daily Schedule for 444 Note that this schedule will be altered during the quarter. Please make sure to check it regularly. Lecture notes will be posted no later than shortly after the corresponding lecture. Until then, the links will probably not work. Key: Lecture topic Reading assignment Homework information Project milestones Special events Week of Monday Wednesday Friday Sept. 24 ...  Intro; SQL pdf / ppt SQL Reading: Chapter 86 pdf / ppt  Oct. 1 SQL pdf / ppt   SQL pdf / ppt Project 0 due Thur SQL in C#, Project pdf / ppt Reading: Chapter 8 HW1 due Sat. 9pm Oct. 8 Views, Constraints Reading: Chapters 6, 7 pdf / ppt  ER Diagrams pdf / ppt Reading: Chapter 2, 3.2, 3.3  Database Design pdf / ppt Reading: Secs.3.1, 3.4 Project 1 due Sat 9pm Oct. 15 Database Design, cont. XML/XPath/XQuery pdf / ppt Reading: Chapter 4.6, 4.7 XML/XPath/XQuery pdf / ppt  HW2 due Sat 9pm Oct. 22 XML/XPath/XQuery pdf / ppt Security pdf / ppt Reading: SQL Security 8.7 Midterm Review pdf / ppt Transactions pdf / ppt Reading: Sec.8.6 Project 2 due Sat 9pm Oct. 29 Midterm Exam Transactions pdf / ppt Reading: Secs.17.2-17.4 Transaction, Recovery HW3 due Sat 9pm Nov. 5 Concurrency Control Reading: Secs.18.1-18.4, 18.7-18.9 pdf / ppt Concurrency Control 2 Concurrency Control 3 Project 3 due Sun 9pm Nov. 12 Veterans Day No Class Data storage and Indexes pdf / ppt Reading: 12, 13.1, 13.2, 13.3 Query Execution: Relational Algebra Reading: 5.1-5.4 pdf / ppt  Nov. 19 Query Execution 2 pdf / ppt HW4 due 9pm Query Execution 3: Physical Operators Thanksgiving No Class Nov. 26 Query Optimization pdf / ppt Reading: 16.2, 16.5, 16.6, 16.4 Query Optimization Query Optimization Project 4 due Sun 9pm Dec. 3 Query Optimization Guest lecture Gates Commons (CSE 691) ppt Final Review pdf / ppt Dec. 10 Final exam 10:30-12:20       Final Exam: Officially scheduled for 8:30 to 10:20 am, Monday, December 10, but will be given from 10:30-12:20 in our regular room. Contact Hal if this causes a conflict

	Computer Science & Engineering University of Washington Box 352350 Seattle, WA  98195-2350 (206) 543-1695 voice, (206) 543-2969 FAX [comments to perkins]