CS 365: Database Systems
Fall 2012

Instructor: Alexander Dekhtyar, dekhtyar@calpoly.edu, 14-215

Office Hours:
When
Who Where
Tuesday 11:10am - 12:00pm Alex 14-215
Wednsday 9:00am - 12:00pm Alex 14-215
Friday 9:10am - 10:00am Alex 14-215

Additional appoinments: send email.

News and Notes

Old News and Notes

Course Materials

Syllabus Postscript PDF

Labs

Lab 1, Part 1 Due: September 20 Why databases? Postscript PDF Lab Data [September 18, 2012]
Lab 1, Part 2 Due: September 25 Why databases? Postscript PDF Lab Data [September 20, 2012]
Lab 2 Due: October 2 SQL DDL, DML Postscript PDF Lab Tests [September 27, 2011]
Lab 3 Due: October 16 SQL DDL, DML Postscript PDF Lab Info [October 3, 2012]
Lab 4 Due: October 25 Simple SQL Queries Postscript PDF Lab Data [October 17, 2012]
Lab 5 Due: November 1 Counting with SQL Postscript PDF [October 25, 2012]
Lab 6 Due: November 20 Complex SQL Queries Postscript PDF [November 3, 2011]
Lab 7 Due: November 30 JDBC Postscript PDF [November 15, 2012]

JDBCTest.java
ojdbc14.jar (JDBC driver)

Course Datasets

CSU Dataset
README
Campuses.csv
csu-fees.csv
degrees.csv
discipline-enrollments.csv
disciplines.csv
enrollments.csv
faculty.csv
CSU.zip
[September 26, 2007]
CARS Dataset
README
car-makers.csv
car-names.csv
cars-data.csv
continents.csv
countries.csv
model-list.csv
cars.desc
CARS.zip
[September 26, 2007]
BAKERY Dataset
README
customers.csv
goods.csv
items.csv
receipts.csv
BAKERY.zip
[October 1, 2007]
STUDENTS Dataset
README
list.csv
teachers.csv
STUDENTS.zip
[October 1, 2007]
MARATHON Dataset
README
marathon.csv
MARATHON.zip
[October 8, 2007]
AIRLINES Dataset
README
airlines.csv
airports100.csv
flights.csv
AIRLINES.zip
[November 19, 2007]
WINE Dataset
README
appellations.csv
grapes.csv
wine.csv
WINE.zip
[March 27, 2011]
INN Dataset
README
Rooms.csv
Reservations.csv
INN.zip
[April 6, 2011]

Logs

Date log (size)
November 8, 2012 Log (400Kb)
October 25, 2012 Log (700Kb)
October 23, 2012 Log (116Kb)
October 18, 2012 Log (935Kb)
October 16, 2012 Log1 (65Kb)
Log2 (175Kb)
October 2, 2012 Log1 (1MB)
Log2 (35Kb)

Homeworks

Homework 1 Due: October 30, 2012 Postscript PDF [October 18, 2011]

Lecture Notes

Lecture 1 Why Databases ? Postscript PDF [September 14, 2007]
Lecture 2 Databases in a Nutshell Postscript PDF [September 16, 2007]
Lecture 3 Relational Database Model Postscript PDF [September 20, 2007]
Lecture 4 SQL DDL and DML Postscript PDF [September 16, 2007]
Lecture 5 Oracle's SQL*Plus client Postscript PDF [September 16, 2007]
Lecture 6 Relational Algebra Postscript PDF [October 3, 2007]
Lecture 7 SQL DATE type and built-in functions Postscript PDF [October 8, 2007]
Lecture 8 SQL SELECT Postscript PDF [October 8, 2007]
Lecture 9 SQL: Aggregation Operators Postscript PDF [October 23, 2007]
Lecture 10 SQL: GROUP BY and HAVING clauses Postscript PDF [October 25, 2007]
Lecture 10: Example GROUP BY and HAVING clauses Postscript PDF [October 29, 2007]
Lecture 11 SQL: Nested Queries Postscript PDF [October 29, 2007]
Lecture 12 JDBC Postscript PDF [November 5, 2007]
Lecture 13 JOIN syntax, Outer Joins Postscript PDF [November 20, 2012]
Lecture 13 PL/SQL: Part 1 Postscript PDF [November 8, 2007]
Lecture 14 PL/SQL: Part 2 Postscript PDF [November 13, 2007]
Lecture 15 PL/SQL: Part 3 Postscript PDF [November 20, 2007]

Other Materials

SQL-92

Oracle

General Database Resources

August 28, 2007, dekhtyar at csc.calpoly.edu