SQL/Sybase Programming, Fall 1999
Syllabus
Sep. 14, 1999
- 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
Sep. 21, 1999
- Topics:
- Database design
- Querying an existing database: the select statement
- Lab:
- UNIX concept: Scripting
- Using ISQL
- Reading: The Practical SQL Handbook, Chapter 2
Sep. 28, 1999
- 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
- Lab: simple queries in ISQL
- Database project: Preliminary (draft) design (due Oct. 5)
Oct. 5, 1999
- Due: Database project: Preliminary (draft) design
- Topics:
- More about tables: Indexes
- Adding, changing, and removing data
- Lab: More simple queries, updates
- Reading: The Practical SQL Handbook, Chapter 3, pp. 62-86
Oct. 12, 1999
- Topics: Querying the database: the select statement
- Lab: Creating tables and database design
- Reading: The Practical SQL Handbook, Chapter 4
- Database project: Database design proposal (due Oct. 19)
Oct. 19, 1999
- Due: Database project: Database design proposal
- Topics:
- Querying the database – use of distinct
- Sorting data
- Aggregate functions
- Lab: Data entry and deletion
- Reading: The Practical SQL Handbook, Chapter 5
Oct. 26, 1999
- Topics: Querying the database – grouping data
- Lab: Advanced queries and subqueries
- Reading: The Practical SQL Handbook, Chapter 6
Nov. 2, 1999
- Complete by the end of class: Tables and representative data for database
project.
- Reading: The Practical SQL Handbook, Chapter 7
Nov. 9, 1999
- Topics: Querying the database – joining tables in a query
- Lab: Joins and subqueries
- Reading: The Practical SQL Handbook, Chapter 8
Nov. 16, 1999
- Due: Database Articles and summary
- Topics: Queries with subqueries
- Lab: Database design and index creation
- Reading: The Practical SQL Handbook, Chapter 10
Nov. 23, 1999
- Topics : Database management issues – security, performance, integrity
- Lab: Aggregate functions
- Reading: The Practical SQL Handbook, Chapter 9
Nov. 30, 1999
- Topics: Database views
- Reading: The Practical SQL Handbook, Chapter 11
- Open lab (database project and/or labs still due)
Dec. 7, 1999
-
Topics:
-
"Real world" database queries
-
Troubleshooting
- Reading: The Practical SQL Handbook, Chapters 12
-
Open lab (database project)
Dec. 14, 1999
-
Database project lab/presentation
-
Database project to be handed in by the end of class.