{"product_id":"sql-pocket-guide-a-guide-to-sql-usage-9781492090403","title":"SQL Pocket Guide: A Guide to SQL Usage","description":"\u003cp\u003eIf you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is your ideal on-the-job reference. You'll find many examples that address the language's complexities, along with key aspects of SQL used in Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, and SQLite.\u003c\/p\u003e\u003cp\u003eIn this updated edition, author Alice Zhao describes how these database management systems implement SQL syntax for both querying and making changes to a database. You'll find details on data types and conversions, regular expression syntax, window functions, pivoting and unpivoting, and more.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eQuickly look up how to perform specific tasks using SQL\u003c\/li\u003e\n\u003cli\u003eApply the book's syntax examples to your own queries\u003c\/li\u003e\n\u003cli\u003eUpdate SQL queries to work in five different database management systems \u003c\/li\u003e\n\u003cli\u003eNEW: Connect Python and R to a relational database\u003c\/li\u003e\n\u003cli\u003eNEW: Look up frequently asked SQL questions in the How Do I? chapter\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 09\/21\/2021\u003cbr\u003e\u003cb\u003eISBN:\u003c\/b\u003e 9781492090403\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 336","brand":"Alice Zhao","offers":[{"title":"Default Title","offer_id":40843750637749,"sku":"9781492090403","price":30.59,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0473\/0804\/6492\/products\/img_dfd72752-105f-44a5-921e-a2b71af837ee.jpg?v=1629809697","url":"https:\/\/pastforward.org\/products\/sql-pocket-guide-a-guide-to-sql-usage-9781492090403","provider":"Past Forward","version":"1.0","type":"link"}