…who looked at this wanting to get going with using database systems (as opposed to creating them), I'd recommend: Learning SQL by Alan Beaulieu SQL Performance Explained by Markus Winand SQL Cookbook by Anthony Molinaro The three of these will take you up to a pretty useful level of SQL knowledge/understanding. The first two are fairly easy reading to boot.
我从 Anthony Molinaro 的《SQL Cookbook》里学到了很多东西，里面的理论内容多得惊人。不过听起来你并不像是在找 cookbook 这类的工具书，我觉得你想找的应该是 C.J. Date 和 Joe Celko 写的书。
I got a lot out of Anthony Molinaro's SQL Cookbook, it had a surprising amount of theory in it. It doesn't sound like you're looking for a cookbook type book though, what I think you're looking for is books by C.J. Date and Joe Celko.
……数据存储方案。我是 Apache Cassandra 的贡献者也是社区 MVP，但我的建议依然没变：最好还是先从 SQL 数据库搞起，然后再循序渐进。读几本书好好学一下：O'Reilly 的《SQL Cookbook》就很棒，《The Art of SQL》也很不错。过早优化依然是一切罪恶的根源。
…data store. I am an Apache Cassandra contributor and community MVP, but my advice stays the same: it's best just to start with a SQL database and go from there. Read some books and learn it well: the "SQL Cookbook" from O'Reilly is great, and so is "The Art of SQL." Premature optimization continues to be the root of all evil.
My introduction to window functions (and the best write-up I’ve seen) was through the SQL Cookbook (http://shop.oreilly.com/product/9780596009762.do). I highly recommend.
I swear by O'Reilly's SQL Cookbook (http://www.amazon.com/Cookbook-Cookbooks-OReilly-Anthony-Mol...). The examples start of easy and get more complicated as you go along, all with detailed explanations. The book is a bit out of date but…
Yeah but the functions and style used in these answers vary across implementations (date_trunc, etc.) I highly recommend the SQL Cookbook for newer SQL dev as a quick reference comparison to see how often this is the case for even trivial problems in any RDBMS. Also, for your language I wouldn't expect all mid tier SQL devs to be able…
……对于那些看到这里、想要开始上手使用数据库系统（而不是开发数据库系统）的人，我推荐：Alan Beaulieu 的《Learning SQL》、Markus Winand 的《SQL Performance Explained》、Anthony Molinaro 的《SQL Cookbook》。这三本书能把你的 SQL 知识/理解提升到一个相当实用的水平。而且前两本读起来相当轻松。
…who looked at this wanting to get going with using database systems (as opposed to creating them), I'd recommend: Learning SQL by Alan Beaulieu SQL Performance Explained by Markus Winand SQL Cookbook by Anthony Molinaro The three of these will take you up to a pretty useful level of SQL knowledge/understanding. The first two are fairly easy reading to boot.
我从 Anthony Molinaro 的《SQL Cookbook》里学到了很多东西，里面的理论内容多得惊人。不过听起来你并不像是在找 cookbook 这类的工具书，我觉得你想找的应该是 C.J. Date 和 Joe Celko 写的书。
I got a lot out of Anthony Molinaro's SQL Cookbook, it had a surprising amount of theory in it. It doesn't sound like you're looking for a cookbook type book though, what I think you're looking for is books by C.J. Date and Joe Celko.
……数据存储方案。我是 Apache Cassandra 的贡献者也是社区 MVP，但我的建议依然没变：最好还是先从 SQL 数据库搞起，然后再循序渐进。读几本书好好学一下：O'Reilly 的《SQL Cookbook》就很棒，《The Art of SQL》也很不错。过早优化依然是一切罪恶的根源。
…data store. I am an Apache Cassandra contributor and community MVP, but my advice stays the same: it's best just to start with a SQL database and go from there. Read some books and learn it well: the "SQL Cookbook" from O'Reilly is great, and so is "The Art of SQL." Premature optimization continues to be the root of all evil.
我接触窗口函数的启蒙（也是我见过写得最好的一篇）就是通过《SQL Cookbook》（http://shop.oreilly.com/product/9780596009762.do）。强烈推荐。
My introduction to window functions (and the best write-up I’ve seen) was through the SQL Cookbook (http://shop.oreilly.com/product/9780596009762.do). I highly recommend.
我力挺 O'Reilly 的《SQL Cookbook》（http://www.amazon.com/Cookbook-Cookbooks-OReilly-Anthony-Mol...）。里面的示例循序渐进，由浅入深，每个都有详细的讲解。书虽然稍微有点过时，但是……
I swear by O'Reilly's SQL Cookbook (http://www.amazon.com/Cookbook-Cookbooks-OReilly-Anthony-Mol...). The examples start of easy and get more complicated as you go along, all with detailed explanations. The book is a bit out of date but…
是啊，但是这些答案里用到的函数和风格因具体实现而异（比如 date_trunc 等）。我强烈推荐把《SQL Cookbook》作为新手 SQL 开发者的一本快速参考对比手册，看看即使是任何 RDBMS 中的微不足道的小问题，实现差异有多频繁。另外，对于你们那门语言，我不会指望所有中级 SQL 开发者都能……
Yeah but the functions and style used in these answers vary across implementations (date_trunc, etc.) I highly recommend the SQL Cookbook for newer SQL dev as a quick reference comparison to see how often this is the case for even trivial problems in any RDBMS. Also, for your language I wouldn't expect all mid tier SQL devs to be able…