- Author: Philip Greenspun
- Format: online HTML
- Price: free
A nicely structured manuscript on SQL by Philip Greenspun, based on the Oracle database. Queries, transactions, triggers, and RDBMS concepts are covered.
Chapters include:
- 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