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
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.
(14197 views)
Sams Teach Yourself SQL in 24 Hoursby Ryan Stephens, Ron Plew - Sams
This book presents the key features of SQL in an easy to understand format with updated code examples. The material covers transactions, constructs, embedded databases, object-oriented programming, and MySQL, a very popular open source database.
(20853 views)
A Primer on SQLby Rahul Batra
This is a short e-book teaching the basics of SQL assuming no prior knowledge of it. While the examples and text use Ingres as the database management system, the code should work correctly on any SQL compliant database.
(13873 views)
SQL Cookbook: Query Solutions and Techniques for All SQL Usersby Anthony Molinaro, Robert de Graaf - O'Reilly Media
This book offers solutions to common SQL challenges. With clear examples for various SQL dialects, it covers topics like filtering, aggregation, and advanced queries, making it a guide for users looking to optimize and master their SQL skills.
(603 views)