SQL for Web Nerds

My image
  • 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

http://philip.greenspun.com/sql/

Leave a Reply

Your email address will not be published. Required fields are marked *