• General course information
• Syllabus
• Criteria for grading
  

• In-class/take-home exercises, Sept. 30th, part 1
• In-class/take-home exercises, Sept. 30th, part 2
• In-class/take-home exercises, Oct. 7th
• In-class/take-home exercises, Oct. 14th, part 1
• In-class/take-home exercises, Oct. 14th, part 2
• In-class/take-home exercises, Oct. 21st, part 1
• In-class/take-home exercises, Oct. 21st, "mixed" outer joins
• In-class/take-home exercises, Oct. 28th, part 1
• In-class/take-home exercises, Nov. 4th
• In-class/take-home exercises, Nov. 18th
• In-class/take-home exercises, Nov. 25th
• In-class/take-home exercises for Dec. 2nd (Internet questions)
• Internet discussion questions for Dec. 9th

• Quiz 1 answer set
• Quiz 2 answer set

• Examples using string and math functions
• String and date functions and functions for handling nulls
• Gaps in a time series, adapted from Celko's text
• Examples using IS NULL and LIKE
• String manipulation examples:   complex sorting;     proper case
• Examples using IN and EXISTS
• Examples using ANY and ALL
• Grouping and aggregate functions
• More on aggregate functions; control-of-flow
• All triggers in pubs2.
• Stored procedures (pubs2 and my database)
• Statistics: Avg, mode, median (pubs2)
• Cumulative statistics: Running counts, sums

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

• Using the isql Utility
• Using the bcp Utility
• Using and Creating Datatypes
• Using The Built-In Functions In Queries
• Converting datatypes (includes date styles)  (Local file - internal links may not work)
• String functions  (Local file - internal links may not work)
• Mathematical functions  (Local file - internal links may not work)
• Date functions   (Local file - internal links may not work)
• Triggers (from Transact-SQL User's Guide)


• Triggers: Enforcing Referential Integrity
• Triggers (local files - internal links may 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
• Batches and Control-of-Flow (from Transact-SQL User's Guide)


• Using Batches and Control-of-Flow Language
• Diagram of the pubs2 Database

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