SQL for Web Nerds - NFHN Reader

Introduction
Data modeling
simple queries: one table, one table with subquery, JOIN, JOIN with subquery, OUTER JOIN
more complex queries: GROUP BY, aggregates, HAVING
Transactions (inserts and updates)
triggers
views
style
escaping to the procedural world: PL/SQL and Java executing inside the Oracle server
trees
handling dates in Oracle
limits in Oracle; how they will bite you and how to work around them
tuning, what to do when your query runs too slowly
data warehousing, what to do when your query doesn't answer your questions
foreign and legacy data, making foreign Web sites look like local SQL tables
normalization
Afterword
Appendix A: Setting up your own RDBMS
Appendix B: Getting real work done with Oracle

the complete Oracle doc set is available online, as a link from www.oracle.com; some particularly interesting books are the Application Developer's Guide and Concepts
Oracle 10g: The Complete Reference