SQL/Sybase Programming, Spring
1998
Syllabus
Feb. 12, 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 Feb. 19)
Feb. 19, 1998
-
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 Feb. 26)
Feb. 26, 1998
-
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 Mar. 5)
Mar. 5, 1998
-
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
Mar. 12, 1998
-
Topics: Querying the database: the select statement
-
Reading: The Practical SQL Handbook, Chapter 4
-
Take-home lab 2 (due Mar. 19)
-
Database project: Create tables, enter representative data (due Apr. 2)
Mar. 19, 1998
-
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 Mar. 26)
Mar. 26, 1998
-
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 Apr. 16)
Apr. 2, 1998
-
Complete by the end of class: Tables and representative data for database
project.
-
SQL / Relational database article summary presentations
Apr. 9, 1998 – no class: Spring Break
Apr. 16, 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 Apr. 23)
Apr. 23, 1998
-
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 Apr. 30)
Apr. 30, 1998
-
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 May 7)
May 7, 1998
-
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)
May 14, 1998
-
Topics:
-
"Real world" database queries
-
Troubleshooting
-
Reading: The Practical SQL Handbook, Chapters 11 and 12
-
Open lab (database project)
May 21, 1998
-
Database project lab/presentation
-
Database project to be handed in by the end of class.