SQL for Web Nerds
by
Philip Greenspun
Preface
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
More:
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
philg@mit.edu