CS 365: Database Systems
Spring 2011

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

Office Hours:

When		Who	Where
Tuesday	3:10am - 4:00pm	Alex	14-215
Wednsday	9:00am - 12:00pm	Alex	14-215
Thursday	3:10pm - 4:00pm	Alex	14-215

Additional appoinments: send email.

News and Notes

• Welcome to CSC 365!

Course Materials

Labs

Lab 1, Part 1	Due: September 22	Why databases?	Postscript	PDF	Lab Data	[September 18, 2011]
Lab 1, Part 2	Due: September 27	Why databases?	Postscript	PDF	Lab Data	[September 23, 2011]
Lab 2	Due: October 4	SQL DDL, DML	Postscript	PDF	Lab Tests	[September 27, 2011]
Lab 3	Due: October 18	SQL DDL, DML	Postscript	PDF	Lab Info	[October 6, 2011]
Lab 4	Due: October 25	Simple SQL Queries	Postscript	PDF	Lab Data	[October 18, 2011]
Lab 5	Due: November 3	Counting with SQL	Postscript	PDF		[October 27, 2011]
Lab 6	Due: November 15	Complex SQL Queries	Postscript	PDF	Lab Data	[November 3, 2011]
Lab 7	Due: December 1	JDBC	Postscript	PDF		[November 10, 2011]
Lab 8	Due: December 1	PL/SQL				[]

JDBCTest.java
ojdbc14.jar (JDBC driver)

PL/SQL examples

example1.sql	Inserts a row into table	[November 13, 2007]
example2.sql	Simple use of cursor	[November 13, 2007]
example4.sql	Cursor + loop	[November 13, 2007]
example5.sql	for-loop for cursors	[November 13, 2007]
example3.sql	paremeterized cursor	[November 13, 2007]
example10.sql	Stored procedure: insert a row into table	[May 29, 2008]
example11.sql	anonymous block that uses example10 procedure	[May 29, 2008]
example12.sql	stored function: max price for given food type	[May 29, 2008]
pack.sql	Package	[June 3, 2008]
example15.sql	using the package	[June 3, 2008]

Course Datasets

Lecture Notes

• SQL-92 Syntax description.

Oracle

General Database Resources

• DBLP - Database and Logic Programming Bibliography server. (ACM mirror. Original site is here).[posted: Sep 25]

• ACM SIGMOD (Special Ineterst Group on Management Of Data).

  • ACM SIGMOD Repository of publically available database software.