Current Semester
Spring 2009
YU Links
Prior Semesters
Fall 2008
Spring 2008
Fall 2007
Spring 2007
Fall 2006
Spring 2006
Fall 2005
Fall 2002 - Spring 2005

INF3560: Database Design

Class Materials

GENERAL MATERIALS

(Weblink) Website for Database Design, Application Development & Administration by Mannino
(Powerpoint) Review of SQL Select Statement
(Powerpoint) Transactions
MATERIALS FOR MURACH BOOK
(PDF file) Student Workbook for "Murach's SQL for SQL Server"
(Powerpoint) SQL Server Scripts (Murach - chap 13)
(Powerpoint) SQL Server Stored Procedures (Murach - chap 14)
(Powerpoint) (Murach - chap 15)
(Powerpoint) (Murach - chap 16)
(Powerpoint) (Murach - chap 17)

SQL SERVER DOCUMENTATION

(Link) Installing SQL Server 2000 (developer edition)
(WebLink) Microsoft SQL Server 2000 Homepage
(WebLink) "Transact" SQL Reference
(WebLink) SQL Server data types
(WebLink) How to copy a SQL Server database to another computer.