Sept. 10, 1998

• Lab:
• UNIX concepts: Log on, change password, change username
• UNIX files: Create files (Pico editor), file management
• Pine mail
• Topics:
• Databases: Definitions, classification, models
• Sybase: Client / server concepts
• The relational model
• The SQL language
• Reading:
• The Practical SQL Handbook, Chapter 1
• Sybase System 11 Strategy chapter excerpt
• Take-home lab 1 (due Sept. 17)

• Due by the beginning of class: Lab 1
• Topics:
• Database design
• Querying an existing database: the select statement
• Lab:
• UNIX concept: Scripting
• Using ISQL
• Reading: The Practical SQL Handbook, Chapter 2
• Database project: Preliminary (draft) design (due Sept. 24)

• Due by the beginning of class: Database project: Preliminary (draft) design
• Review: Database design
• Discuss database project draft proposals
• Topics:
• Creating a database
• Creating tables
• Datatypes
• Reading: The Practical SQL Handbook, Chapter 3, pp. 47-62
• Database project: Database design proposal (due Oct. 1)

• Due by the beginning of class: Database project: Database design proposal
• Topics:
• More about tables: Indexes
• Adding, changing, and removing data
• Reading: The Practical SQL Handbook, Chapter 3, pp. 62-86
• In-class lab: Creating tables, entering data (due Oct. 8)

• Due by the beginning of class: In-class lab from Oct. 1
• Topics:
• Querying the database: the select statement
• Transact-SQL mathematical, string, and date functions
• Reading: The Practical SQL Handbook, Chapter 4
• Take-home lab 2 (due Oct. 15)
• Database project: Create tables, enter representative data (due Oct. 29)

• Due by the beginning of class: Take-home lab 2
• Topics:
• Querying the database – use of distinct
• Sorting data
• Aggregate functions
• Reading: The Practical SQL Handbook, Chapter 5
• Take-home lab 3 (due Oct. 22)

• Due by the beginning of class: Take-home lab 3
• In-class lab 1
• Topics: Querying the database – grouping data
• Reading: The Practical SQL Handbook, Chapter 6
• Take-home lab 4 (due Oct. 29)

• Complete by the end of class: Tables and representative data for database project.
• SQL / Relational database article summary presentations

Nov. 5, 1998

• Due by the beginning of class: Take-home lab 4
• Topics: Querying the database – joining tables in a query
• Reading: The Practical SQL Handbook, Chapter 7
• Take-home lab 5 (due Nov. 12)

• Due by the beginning of class: Take-home lab 5
• In-class lab 2
• Topics: Queries with subqueries
• Reading: The Practical SQL Handbook, Chapter 8
• Take-home lab 6 (due Nov. 19)

• Due by the beginning of class: Take-home lab 6
• Topics : Database management issues – security, performance, integrity
• Reading: The Practical SQL Handbook, Chapter 10
• Take-home lab 7 (due Dec. 3)

• Due by the beginning of class: Take-home lab 7
• In-class lab 3
• Topics: Database views
• Reading: The Practical SQL Handbook, Chapter 9
• Open lab (database project and/or labs still due)

• Topics:
• "Real world" database queries
• Troubleshooting
• Reading: The Practical SQL Handbook, Chapters 11 and 12
• Open lab (database project)

• Database project lab/presentation
• Database project to be handed in by the end of class.