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
Sams Teach Yourself SQL in 24 Hours
by 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.
(19888 views)
by 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.
(19888 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.
(8289 views)
- 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.
(8289 views)
SQL Performance Explained
by 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.
(19627 views)
by 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.
(19627 views)
SQL Essentials
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.
(21196 views)
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.
(21196 views)