开发者

Complex SQL design book [closed]

开发者 https://www.devze.com 2022-12-16 23:54 出处:网络
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
开发者_如何学Python

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 3 years ago.

Improve this question

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?


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.

Complex SQL design book [closed]


(source: amazon.com)


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

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


+1 for Joe Celko

also, for sql server The Gurus guide to transact sql


If you're talking SQL Server, the series of SQL books by Solid Quality Mentors are well worth a read.

I personally can recommend:

  • Inside Microsoft SQL Server 2005: T-SQL Programming
  • Inside Microsoft SQL Server 2005: T-SQL Querying
  • Inside Microsoft SQL Server 2005: Query Tuning and Optimization

I think they're a great set to have on your bookcase.

0

精彩评论

暂无评论...
验证码 换一张
取 消