- 出版社: O'Reilly Media, Inc, USA (2006年1月3日)
- 丛书名: Cookbooks (O'Reilly)
- 平装: 636页
- 语种： 英语
- ISBN: 0596009763
- 条形码: 9780596009762, 0636920009764
- 商品尺寸: 17.8 x 3.6 x 23.3 cm
- 商品重量: 1 Kg
- 品牌: O'Reilly Media, Inc, USA
- ASIN: 0596009763
- 用户评分: 分享我的评价
- 亚马逊热销商品排名: 图书商品里排第635,463名 (查看图书商品销售排行榜)
SQL Cookbook (英语) 平装 – 2006年1月3日
Anthony Molinaro is a database developer at Wireless Generation. His interests include databases, databases, and, oh yeah... databases. He currently resides in Baltimore, Maryland with Georgia, his fiancee and favorite periodontist.
此商品在美国亚马逊上最有用的商品评论 (beta) (可能包括"Early Reviewer Rewards Program"的评论)
I love all of the great code examples for very real and common problems. This book will not hold your hand and walk you through the language but it will provide you all the resources to become better acquainted with the language and further upgrade your skill set.
My experience: Former BI analyst and current Sr. Developer.
I find myself visiting the solutions in the book over and over, especially when it comes to hierarchical queries or the queries that generate consecutive numeric values (I use these to generate sample data).
I recommended the book to all my colleagues that do sql programming, and I am waiting for the second edition ;-)
Sure, I could write a 'SELECT' statement or perform and 'UPDATE'.
But, I did not know how to approach SQL as being a 'complete' solution for record selection.
The Crystal Reports portion was not too much trouble.
I was using the PL/SQL environment for creating the SQL. Oracle 10g.
Mr. Molinaro's book was instrumental in having me develop what turned out to be some rather complex SQL.
It took awhile to get to use SQL's window functions. But, the author's presentation/explanation made them more than approachable---and quite useful.
I liked the explanations that covered the multiple vendors' database engines.
I will make no pretense of having reached SQL knowledge 'nirvana'--However, there was more than one time where I was out of ideas on how to get/count certain data----The SQL Cookbook did its job by showinge 'yet another way' to approach a pressing problem with a solution.
And one can gain a deep understanding of how SQL works. Always a plus for anyone that is new to an environment.
If there was something like a SQL University, this book seems to be text that would work very well for giving students more than enough 'footing' to face the 'real' world. It did for me.
I am more than pleased to have this book as part of my SQL 'library.'
The book content is excellent, with lots of examples and good descriptions of the underlying logic. iIt rates 5 stars.
While Kindle is a very good format for reading a novel, it is an awful format for technical books like this. Since Amazon doesn't offer it in PDF format it gets 0 stars.
If you want an electronic version don't waste your money of the Kindle version. Go to the publisher's website and order the PDF version, it's a little more expensive bur far more useful.
- 图书 > 进口原版 > Computers & Technology（计算机与科技） > Databases（数据库） > Data Mining
- 图书 > 进口原版 > Computers & Technology（计算机与科技） > Databases（数据库） > Data Warehousing
- 图书 > 进口原版 > Computers & Technology（计算机与科技） > Databases（数据库） > Database Management Systems
- 图书 > 进口原版 > Computers & Technology（计算机与科技） > Databases（数据库） > SQL
- 图书 > 进口原版 > Computers & Technology（计算机与科技） > Programming（编程） > Languages & Tools
- 图书 > 进口原版 > Reference（参考书）