SQL Performance Explained
by Markus Winand
Number of pages: 207
SQL performance problems are everywhere, everyday. SQL Performance Explained 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.
Download or read it online for free here:
by Rahul Batra - dreamincode.net
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.
by Mark McIlroy - Blue Sky Technology
An introduction to the use of SQL to retrieve data and generate query result tables. The book covers SQL queries and is suitable for beginners and intermediate users. This includes an on-line environment where you can try out the examples.
by Philip Greenspun
Introduction to SQL: 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.
In this SQL tutorial, you will learn how to use the SQL language to: Store, retrieve and manipulate data in SQL server; Select, insert, update and delete rows in SQL tables; Create database and tables in SQL server and all other SQL concepts.