• General course information
• Syllabus
• Criteria for grading
  


• SQL exercises and results


• In-class exercise, Sept. 23rd
• Homework assignment 1
• In-class exercises, Oct. 7th, part 1
• In-class exercises, Oct. 7th, part 2
• Money conversion example
• In-class exercises, Oct. 14th


• 10/21/00 practice questions 1-3
• 10/21/00 practice question 4
• 10/21/00 practice question 5, 8-10
• 10/21/00 practice questions 6-7 (compute)
• In-class exercises, Oct. 28th (amended 11/15)
• 11/04/00 practice questions
• Homework assignment 2 (11/4)
• Homework assignment 3 (11/18)
• Trigger examples


• Quizzes
• Quiz 1 answer set
• Quiz 2 answer set


• "Real-world" examples
• "Real-world" SQL - Problem set 1 with proposed solutions


• Course project


• Database project (Revised 11/02/00)

• WWW links to Sybase

 
• Sybase Web site
• Contents of the Adaptive Server Enterprise 11.5 (Generic) Collection
• Transact-SQL User's Guide
• Specific topics from Sybooks

 
• SQL Server 11.0.x Technical Overview
• Using the isql Utility

 
• Using and Creating Datatypes
• Converting datatypes (includes date styles)
  (Local file - internal links do not work)
• String functions
  (Local file - internal links do not work)
• Date functions
  (Local file - internal links do not work)
 
• Triggers (from Transact-SQL User's Guide)

 
• Triggers: Enforcing Referential Integrity
• Triggers (local files - internal links do not work)

 
• How Triggers Work
• Creating Triggers
• Using Triggers to Maintain Referential Integrity
• Multirow Considerations
• Nesting Triggers
• Rules Associated with Triggers
• Getting Information About Triggers
• Diagram of the pubs2 Database

• Links to database information on the Web

 
• University of Texas Internet Resources Collection
• Database Normalization Basics
• Online database journals/magazines

 
• Intelligent Enterprise
• The Data Administration Newsletter
• DM Review

Page last modified on Dec. 8, 2000
If you have questions, send e-mail to evelyn@udel.edu