Sept. 9

• Topics:
• Introduction and course overview
• Lab:
• UNIX account setup: log on, change password, set username
• Account setup for Sybase: .localalias and .localenv files
• Readings:
• Advanced SQL Programming, Chapters 3-4 - String and Numeric Datatypes
• Transact-SQL User Guide, Chapter 10

• Topics:
• String and math functions(/LI>
• Handling dates and times
• Cleaning and formatting data
• Reading:
• Advanced SQL Programming, Chapters 3-5 - String, Numeric, and Temporal Datatypes
• Lab:
• Create and populate sample tables
• Examples using assorted datatypes

• Topics:
• Missing values
• Reading:
• Advanced SQL Programming, Chapter 6 - Nulls
• Advanced SQL Programming, Chapter 7 - Other Expressions

• Topics:
• The WHERE clause
• Reading:
• Advanced SQL Programming, Chapters 11-15 - IS NULL, Like, Between, In, Exists

• Topics:
• Control of flow
• Reading:
• Transact-SQL User's Guide, Chapter 13 - Batches and Control of Flow Language
• Transact-SQL User's Guide, Chapter 16 - Triggers

• Topics:
• Stored procedures
• Reading:
• Transact-SQL User's Guide, Chapter 14 - Using Stored Procedures

• Topics:
• Subqueries and Joins
• Reading:
• Advanced SQL Progamming, Chapters 16-17 - Subqueries, Joins

• Topics:
• Subqueries and Joins, continued
• Reading:
• Advanced SQL Programming, Chapters 16-17 - Subqueries, Joins

• Topics:
• Views and temporary tables
• Reading:
• Advanced SQL Programming, Chapter 18 - Views and Temporary Tables
• Advanced SQL Programming, Chapter 22 - Auxiliary Tables

• Topics:
• Partitioning and grouping
• Reading:
• Advanced SQL Programming, Chapter 19 - Partitioning Data
• Advanced SQL Programming, Chapter 20 - Grouping Operations

• Topics:
• Aggregate functions
• Reading:
• Advanced SQL Programming, Chapter 21 - Aggregate Functions

• Topics:
• Statistics and regions
• Reading:
• Advanced SQL Programming, Chapter 23 - Statistics in SQL
• Advanced SQL Programming, Chapter 24 - Regions, Runs, and Sequences

• Topics:
• Sets and subsets
• Reading:
• Advanced SQL Programming, Chapter 26 - Set Operations
• Advanced SQL Programming, Chapter 27 - Subsets

• Topics:
• Optimizing queries
• Reading:
• Advanced SQL Programming, Chapter 31 - Optimizing Code

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