Review for Test 2

Chapter 3

1. Know how the comparison operators (AND, OR, NOT) work and the order of operations.
2. Know how the IN operator works
3. How do you order columns in ascending/descending order and how can you reference by column number rather than column name (p.68)?
4. How do you retrieve data based on NULL values?
5. Know how to get data using wildcards and know the wildcard symbols.
6. What clause do you add to sort and how can you sort a specific field ascending or descending?
7. How do you override the sort order of NULLs?

Chapter 4

1. Know the definitions of the following joins: Cartesian, outer, non-equity, self.
2. How do you create outer joins? Know the syntax.
3. Using the JOIN method, how would you join tables with different column name? With the same column name?
4. How do you create table aliases? In what situation can you NOT use a table alias (hint: it’s a JOIN method).
5. How do you perform an equity join on tables that have more than one common column if you just want to join on one of those columns?
6. Know what each of the “set” operators do.

(NOTE: There will be no SQL statements for you to decipher for chapter 4, but there will be for chapter 3. Email me at rcacace@pjc.edu if you have any questions.)