Database Technologies
CSC 453

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, 5th edition, 2014. (Everything you always wanted to ask about SQL but were afraid to ask.) You can preview much of the book at books.google, and the whole book is available online through Safari via the library.
• Oracle SQL Reference (by Oracle)
• PL/SQL (Ullman/Widom). (Introductory reference for PL/SQL.)

Database Systems

• H2 Database Engine (web-based engine)
• 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

Books, Tutorials, etc.

• Garcia-Molina, Ullman and Widom's Database Systems. The Complete Book, Prentice-Hall, 2nd edition, 2008. (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.)