ANA660 v1

Rischert, A. (2009). Oracle SQL by example. Prentice Hall.


Read the following chapters to get acquainted with the example database used throughout the book. You’ll need to understand the tables for the lab exercises as well:
Chapter 1 - The STUDENT Schema Diagram (pp.35-41)
Read the following chapter on how to use SQL*Plus (you can skip this chapter if you already know how to use SQL*Plus or are familiar with Oracle SQL execution environment):
Chapter 2 - An Introduction to SQL*Plus (pp. 81-94)
Readings for lectured class content:
Chapter 10 - Complex Join/Outer Join (pp. 399-405. Skip “The Outer Join and the UNION ALL Operator” and “Full Outer Join Using the UNION Operator” sections)
Chapter 6 - Aggregate Functions, GROUP BY, and HAVING Clauses (pp. 263-277)
Chapter 3 – The ORDER BY Clause (pp. 118-119)
Chapter 17 – ROLLUP and CUBE Operators (pp. 782-788)