Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Complex SQL design book [closed]

I know SQL but wanted to master it for use in complex SQL and try to create complex SQL statement in one query. Any book to recommend. I found this book: SQL Design Patterns by Vadim Tropashko. What do you folks suggest?

like image 524
cometta Avatar asked Jan 15 '10 09:01

cometta


2 Answers

SQL for Smarties by Joe Celko. I like the way it covers methods for representing datasets that you'd not immediately think would fit into a relational model.

alt text
(source: amazon.com)

like image 96
teabot Avatar answered Sep 18 '22 17:09

teabot


for T-SQL, take a look at look at books by Itzik Ben-Gan:

http://www.solidq.com/insidetsql/

like image 25
davek Avatar answered Sep 18 '22 17:09

davek