CS 365: Database Systems
Fall 2016

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

Office Hours:
When
Who Where
Wednesday 8:10am - 10:00am Alex 14-210
Thursday 8:10pm - 10:00am Alex 14-210

Additional appoinments: send email.

News and Notes

Old News and Notes

Course Materials

Syllabus Postscript PDF
my.cnf template my.cnf

Labs

<
Lab 1, Part 1 Due: January 8 Why databases? Postscript PDF Lab Data [September 23, 2016]
Lab 1, Part 2 Due: October 1 Why databases? Postscript PDF Lab Data [September 28, 2016]
Lab 2 Due: October 10 SQL DDL, DML Postscript PDF Lab Tests [October 3, 2016]
Lab 3-1 Due: October 14 15 SQL DDL, DML Postscript PDF [Octboer 14, 2016]
Lab 3-2 Due: October 17 SQL DDL, DML Postscript PDF [October 14, 2016]
Lab 4 Due: October 24 SQL SELECT Postscript PDF [October 19, 2016]
Lab 5 Due: October 31 November 2 SQL SELECT and Counting Postscript PDF [October 24, 2016]
Lab 6 Due: November 9 Counting and grouping Postscript PDF [November 2, 2016]
Lab 7 Due: November 19 Complex SQL Queries Postscript PDF [November 11, 2016]
Lab 8 Due: December 10 JDBC Application Postscript PDF [November 28, 2016]

oracle2mysql.py: DATE/TIME conversion functions from Oracle to MySQL
convertdate.py: sample test script for oracle2mysql.py functions.

JDBCTestMysql1.java
mysql Connector/J driver
ojdbc14.jar (Oracle 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]
KATZENJAMMER Dataset (Version 2.0)
README
Albums.csv
Band.csv
Instruments.csv
Performance.csv
Songs.csv
Tracklists.csv
Vocals.csv
KATZENJAMMER.zip
[September 21, 2016]
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 Logs
November 28 November28.log
November 14 November14.log
November 9 November9.log
November 7 November7.log
November 2 November2.log November2-2.log
October 21 October21.log October21-2.log
October 19 October19.log
October 7 October7.log
October 5 October5.log

Homeworks

Homework 1 Due: October 28, 2016 Postscript PDF [October 24, 2016]

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 [January 13, 2015]
Lecture 5 Work with MySQL: Part 1 Postscript PDF [January 13, 2015]
Lecture 5-1 Work with MySQL: Part 2 Postscript PDF [January 15, 2015]
Lecture 6 Relational Algebra Postscript PDF [October 3, 2007]
Lecture 7 MySQL data and time types and built-in functions Postscript PDF [February 10, 2015]
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 14 Database Views Postscript PDF [November 28, 2016]

Other Materials

SQL-92

Oracle

General Database Resources

September 21, 2016, dekhtyar at csc.calpoly.edu