{"product_id":"sql-cookbook-query-solutions-and-techniques-for-all-sql-users-9781492077442","title":"SQL Cookbook: Query Solutions and Techniques for All SQL Users","description":"\u003cp\u003eYou may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data. Based on real-world examples, this updated cookbook provides a framework to help you construct solutions and executable examples in severalflavors of SQL, including Oracle, DB2, SQL Server, MySQL, andPostgreSQL.\u003c\/p\u003e\u003cp\u003eSQL programmers, analysts, data scientists, database administrators, and even relatively casual SQL users will find SQL Cookbook to be a valuable problem-solving guide for everyday issues. No other resource offers recipes in this unique format to help you tackle nagging day-to-day conundrums with SQL.\u003c\/p\u003e\u003cp\u003eThe second edition includes: \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eFully revised recipes that recognize the greater adoption of window functions in SQL implementations\u003c\/li\u003e\n\u003cli\u003eAdditional recipes that reflect the widespread adoption of common table expressions (CTEs) for more readable, easier-to-implement solutions\u003c\/li\u003e\n\u003cli\u003eNew recipes to make SQL more useful for people who aren't database experts, including data scientists\u003c\/li\u003e\n\u003cli\u003eExpanded solutions for working with numbers and strings\u003c\/li\u003e\n\u003cli\u003eUp-to-date SQL recipes throughout the book to guide you through the basics\u003c\/li\u003e\n\u003c\/ul\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eBinding Type:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e O'Reilly Media\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 11\/24\/2020\u003cbr\u003e\u003cb\u003eISBN:\u003c\/b\u003e 9781492077442\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 572\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 2.05lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.20h x 7.00w x 1.30d","brand":"Anthony Molinaro, Robert de Graaf","offers":[{"title":"Default Title","offer_id":38026775986357,"sku":"9781492077442","price":56.09,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0473\/0804\/6492\/products\/img_fd38ebe6-993e-43c9-b0ac-57dc82b80589.jpg?v=1609191249","url":"https:\/\/pastforward.org\/products\/sql-cookbook-query-solutions-and-techniques-for-all-sql-users-9781492077442","provider":"Past Forward","version":"1.0","type":"link"}