CS 365: Database Systems

Course Datasets

Logs

Date	Logs	Contents
May 31	May31.out	JOIN syntax, set difference, intersection
May 24	May24.out	Nested Queries
May 22	May22.out	Nested Queries
May 19	May19.out	GROUP BY
May 17	May17.out	GROUP BY
May 15	May15.out	GROUP BY and UNION
May 10	May12.out	Aggregations
May 8	May8.out	SELECT
May 5	May5.out	SELECT and relational algebra
April 21	April21.out	UPDATE, ALTER TABLE
April 19	April19.out	ALTER TABLE, DELETE, UPDATE
April 17	April17.out	INSERT, this did not work out well
April 14	April14.out	CREATE TABLE, INSERT, DROP TABLE
April 12	April12.out	Intro to CREATE TABLE

Homeworks

Homework 1

Due: May 8/May 10, 2017

Postscript

PDF

[April 26, 2017]

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