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.)

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
• the danger of entity integrity: NO TAGS article

Books, 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.)