Study Guide

You should read and know the following material. You should also implicitly know any set theory it depends on. The emphasis on the test will be on material explicitly covered in class. You must practice queries in lecture notes, quizzes, and homework. I am enumerating here specific sections of Chapters from the book and what you need to know:

Book: The Complete Book by Molina, Ullman and Widom

Chapter 1 (1.1): You must know the why database management systems were developed, and an architectural overview of a DBMS. 

Chapter 2 (2.1-2.5) You must know the basics of relation model. You should know, given a specification in English, how to create a database schema with SQL DDL statements,  alter it,  and express constraints (Advanced constraint specification (CHECK) is in 7.2 and 7.3). Set operations underlying SQL syntax must be understood (Section 2.4).  

Chapter 6 (6.1-6.2, 6.5) You must know Basic SQL and how to insert sample values, and delete rows. 

Chapter 3 (6.3-6.4) You must know Advanced SQL. Practice Joins, GroupBy, subqueries, nested subqueries and correlation subqueries. Try various queries from SQLZoo.net. 

Chapter 9 (9.1-9.6) We have covered it more formally in class than in book.
Try PL/SQL questions on tutorialspoint.com

Chapter 6 (6.6) Transactions in SQL
You must understand ACID, Commit, Rollback, concurrent execution under different isolation levels. 

Chapter 10 (10.2) Recursion in SQL
You must be able to read recursive queries and determine output. 
You must know how to write SQL queries on graph and tree databases, recursive or not.

Chapter 3 (3.1-3.5) Use of FDs as a tool set for normalization; Checks for lossless and dependency preservation; Knowing how to normalize relations. 

All the best!