CS 365: Database Systems
Winter 2013

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

Office Hours:
When
Who Where
Monday 9:10am - 11:00pm Alex 14-215
Tuesday 9:10am - 10:00am Alex 14-215
Wednsday 9:10am - 11:00pm 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: January 9 Why databases? Postscript PDF Lab Data [January 7, 2013]
Lab 1, Part 2 Due: January 14 Why databases? Postscript PDF Lab Data [January 13, 2012]
Lab 2 Due: January 22 SQL DDL, DML Postscript PDF Lab Tests [January 14, 2013]
Lab 3 Due: January 28 SQL DDL, DML Postscript PDF Lab Info [January 22, 2013]
Lab 4 Due: February 4 SQL DDL, DML Postscript PDF Lab Info [January 28, 2013]
Lab 5 Due: February 11 SQL SELECT Postscript PDF Lab Info [February 4, 2013]
Lab 6 Due: February 18 Complex Joins Postscript PDF Lab Data [February 13, 2013]
Lab 7 Due: February 25 Counting and grouping Postscript PDF [February 19, 2013]
Lab 8 Due: March 4 Complex SQL Queries Postscript PDF [February 25, 2013]
Lab 9 Due: March 15 JDBC Application Postscript PDF [March 4, 2013]

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 Section 01 log (size) Section 03 log (size)
February 25, 2013 Log 1 Log 1
February 15, 2013 Log 1
February 13, 2013 Log 1 Log 1
February 11, 2013 Log 1
February 6, 2013 Log 1 Log 1
February 4, 2013 Log 1 (349Kb) Log 1 (101Kb)
Log 2 (359Kb)
January, 22 2013 Log 1 (350Kb) Log 1 (13Mb)
January, 16 2013 Log 1 (9Kb) Log 1 (19Kb)
Log 2 (7Kb)

Homeworks

Homework 1 Due: February 11, 2013 Postscript PDF

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