SQL for Web Nerds
by Philip Greenspun
2007
Description:
This is a free online SQL book by Philip Greenspun. It covers data modeling, simple queries, complex queries, transactions, triggers, views, style, PL/SQL and Java, trees, handling dates in Oracle, limits in Oracle, tuning, data warehousing, foreign and legacy data and normalization.
Download or read it online for free here:
Read online
(online html)
Similar books
SQL Performance Explainedby Markus Winand
SQL performance problems are everywhere, everyday. This book is a free SQL tuning e-book for developers. It avoids unnecessary details about database internals but highlights the one topic that is most often neglected: proper indexing.
(24452 views)
SQL with Guru99by Krishna Rungta - guru99
SQL stands for Structured Query Language. It is the communication languages to talk to any database. This book is designed for beginners with little or no Database experience. Apart from teaching the SQL, it also covers the Database design process.
(18451 views)
Developing Time-Oriented Database Applications in SQLby Richard T. Snodgrass - Morgan Kaufmann
Richard Snodgrass and his colleagues have explored temporal data concepts over the last two decades. They now have a fairly complete solution to the problems. This book summarizes their work and presents it in a very accessible and useful way.
(15469 views)
SQL Dialects Reference- Wikibooks
This book is a compact comparative reference for several SQL language dialects. It lists particular common tasks and problems resolved in terms of several SQL server implementations. When possible, it tries to emphasize an universal solution.
(9685 views)