Database Systems
CSC 355
SQL
SQL Fundamentals
by John Patrick (introductory book on SQL for Access and Oracle)
Practical SQL Handbook
by Bowman, Emerson, Darnovsky (book covers several SQL dialects)
SQL for Smarties
, Joe Celko, Morgan Kaufmann, 4th edition, 2011. (Everything you always wanted to ask about SQL but were afraid to ask.)
Oracle SQL Reference
(by Oracle)
PL/SQL
(Ullman/Widom). (Introductory reference for PL/SQL.)
triggers
(Ullman/Widom).
Database Systems
H2 Database Engine
(web-based engine)
Microsoft Access tutorials:
Access 2007
(by Microsoft)
SQL Developer
(not a database system, but a development interface to Oracle's sqlplus)
Relational Database Model
Codd's
Twelve Rules
database security:
little Bobby Tables
the danger of entity integrity:
NO TAGS article
Copyrighting the average
B
ooks, Tutorials, etc.
A First Course in Database Systems
, Ullman, Widom, Prentice-Hall, 3rd edition, 2007. (The textbook for the class.)
Lecture notes
by Ullman and Widom
SQL Antipatterns
, Karwin, Pragmatic Bookshelf, 2010. (Excellent collection of common bad habits in databases, how to recognize them and how to avoid them.)
W3 Schools SQL Tutorial
Marcus Schaefer
Last updated: April 25th, 2014.