SQL/Sybase Programming, Fall
1999
Syllabus
Sept. 9
- Introductions and course overview
-
Topics:
-
Databases: Definitions, classification, models
-
Sybase: Client / server concepts
-
The relational model
-
The SQL language
-
Lab:
-
UNIX concepts: Log on, change password, change username
-
UNIX files: Create files (Pico editor), file management
-
Pine mail
-
Reading:
-
The Practical SQL Handbook, Chapter 1
-
Sybase System 11 Strategy chapter excerpt
-
Assignment:  :e-mail message (due Sept. 16)
Sept. 16
-
Due by the beginning of class: e-mail assignment
-
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. 23)
Sept. 23
-
Due before class (by e-mail): Database project: Preliminary
design
-
Review: Database design
-
Discuss preliminary database project proposals
-
Topics:
-
Creating a database
-
Creating tables
-
Data types
-
Reading: The Practical SQL Handbook, Chapter 3, pp. 47-62
-
Database project: Database design proposal (due Sept. 30)
Sept. 30
-
Due by the beginning of class: Database project design
proposal
-
In-class lab 1: Creating tables, entering data
-
Topics:
-
More about tables: Indexes
-
Adding, changing, and removing data
-
Reading: The Practical SQL Handbook, Chapter 3, pp. 62-86
Oct. 7
- Topics:
- Querying the database: the select statement
- Transact-SQL mathematical, string, and date functions
-
Reading: The Practical SQL Handbook, Chapter 4
-
Database project: Create tables, enter representative data (due Oct. 28)
Oct. 14
-
Topics:
-
Querying the database – use of distinct
-
Sorting data
-
Aggregate functions
-
Reading: The Practical SQL Handbook, Chapter 5
Oct. 21
-
In-class lab 2: Querying the database and manipulating data
-
Topics: Querying the database – grouping data
-
Reading: The Practical SQL Handbook, Chapter 6
Oct. 28
-
Topics: Querying the database – joining tables in a query
-
Reading: The Practical SQL Handbook, Chapter 7
-
Complete by the end of class: Tables and representative data for database
project.
Nov. 4
-
Topics: Queries with subqueries
-
Reading: The Practical SQL Handbook, Chapter 8
Nov. 11
-
Topics
- Database management issues – security, performance, integrity
- Triggers and stored procedures
-
Reading: The Practical SQL Handbook, Chapter 10
Nov. 18
-
In-class lab 3: Functions, aggregate functions, grouping
-
Topics: Database views
-
Reading: The Practical SQL Handbook, Chapter 9
Nov. 25 – No class: Happy Thanksgiving!
Dec. 2
- Topics
-
"Real world" database queries
-
Troubleshooting
-
Reading: The Practical SQL Handbook, Chapter 11
-
Open lab (database project and practice problems)
Dec. 9
- In class Lab 4: Queries on more than one table
-
Topics: "Real world" database queries and troubleshooting, continued
-
Reading: The Practical SQL Handbook, Chapter 12
-
Open lab (database project)
Dec. 16
-
Database project lab/presentation
-
Database project to be handed in by the end of class.