开发者_如何学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 questionI 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.
(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.
精彩评论