• General course information
• Syllabus
• Criteria for grading
  


• SQL exercises and results


• In-class assignment 1
• In-class assignment 2
• In-class assignment 3
• Example using "compute"
• 10/21/99 practice questions 1-5
• 10/21/99 practice questions 6-7
• 10/21/99 practice question 8
• 10/21/99 practice questions 9-12
• 10/28/99 practice questions
• 11/04/99 practice questions
• 11/11/99 joins and subqueries
• Quiz 1 answer set
• Quiz 2 answer set


• "Real-world" SQL questions with proposed solutions
• More "real-world" SQL questions with proposed solutions
• Additional examples, "real world" and Chapt. 12


• Course project


• Database project

• 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 isql

 
• System and User-Defined Datatypes
• Converting datatypes (local file)
• String functions (local file)
• Date functions (local file)

 
• Triggers (from Transact-SQL User's Guide)

 
• Triggers: Enforcing Referential Integrity
• Triggers (local files)

 
• How Triggers Work
• Creating Triggers
• Using Triggers to Maintain Referential Integrity
• Multirow Considerations
• Nesting Triggers
• Rules Associated with Triggers
• Getting Information About Triggers
• Stored procedures (local files)

 
• How Stored Procedures Work
• Creating and Executing Stored Procedures
• Getting Information About Stored Procedures
• System Procedures
• The pubs2 Database (including diagram)

• 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. 15, 1999
If you have questions, send e-mail to evelyn@udel.edu