For SQL programmers, analysts, and database administrators, the new second edition of SQL in a Nutshell is the essential date language reference for the world's top SQL database products. SQL in a Nutshell is a lean, focused, and thoroughly comprehensive reference for those who live in a deadline-driven world.This invaluable desktop quick reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL). It describes every command and reference and includes the command syntax (by vendor, if the syntax differs across implementations), a clear description, and practical examples that illustrate important concepts and uses. And it also explains how the leading commercial and open sources database product implement SQL. This wealth of information is packed into a succinct, comprehensive, and extraordinarily easy-to-use format that covers the SQL syntax of no less than 4 different databases.When you need fast, accurate, detailed, and up-to-date SQL information, SQL in a Nutshell, Second Edition will be the quick reference you'll reach for every time. SQL in a Nutshell is small enough to keep by your keyboard, and concise (as well as clearly organized) enough that you can look up the syntax you need quickly without having to wade through a lot of useless fluff. You won't want to work on a project involving SQL without it.

    

    When the 1969 season began, fans weren’t expecting much from “the Lovable Losers.” But as the season progressed, the Mets inched closer to first place and then eventually clinched the National League pennant. They were underdogs against the formidable Baltimore Orioles, but beat them in five games to become world champions. No one had predicted it. In fact, fans could hardly believe it happened. Suddenly they were “the Miracle Mets.” Playing right field for the ’69 Mets was Art Shamsky, who had stayed in touch with his former teammates over the years. He hoped to get together with star pitcher Tom Seaver (who would win the Cy Young award as the best pitcher in the league in 1969 and go on to become the first Met elected to the Hall of Fame) but Seaver was ailing and could not travel. So, Shamsky organized a visit to Tom Terrific in California, accompanied by the #2 pitcher, Jerry Koosman, outfielder Ron Swoboda, and shortstop Bud Harrelson. Together they recalled the highlights of that amazing season as they reminisced about what changed the Mets’ fortunes in 1969. With the help of sportswriter Erik Sherman, Shamsky has written After the Miracle for the 1969 Mets. This is a book that every Mets fan—and every baseball fan—must own.

    Yet, ethical principles for working with data have been available for decades. The real issue today is how to put those principles into action. With this report, authors Mike Loukides, Hilary Mason, and DJ Patil examine practical ways for making ethical data standards part of your work every day. To help you consider all of possible ramifications of your work on data projects, this report includes: A sample checklist that you can adapt for your own procedures Five framing guidelines (the Five C’s) for building data products: consent, clarity, consistency, control, and consequences Suggestions for building ethics into your data-driven culture Now is the time to invest in a deliberate practice of data ethics, for better products, better teams, and better outcomes. Get a copy of this report and learn what it takes to do good data science today.