{"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\u003e In 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 \u003cli\u003eQuickly look up how to perform specific tasks using SQL\u003c\/li\u003e \u003cli\u003eApply the book's syntax examples to your own queries\u003c\/li\u003e \u003cli\u003eUpdate SQL queries to work in five different database management systems \u003c\/li\u003e \u003cli\u003eNEW: Connect Python and R to a relational database\u003c\/li\u003e \u003cli\u003eNEW: Look up frequently asked SQL questions in the \"How Do I?\" chapter\u003c\/li\u003e \u003c\/ul\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAbout the Author\u003c\/b\u003e\u003cbr\u003e\u003cp\u003eAlice Zhao is a data scientist who is passionate about teaching and making complex things easy to understand. She has taught numerous courses in SQL, Python and R as a senior data scientist at Metis and as a co-founder of Best Fit Analytics. She writes about analytics and pop culture on her blog, A Dash of Data. Her work has been featured in Huffington Post, Thrillist and Working Mother. Alice has also spoken at a variety of data science conferences, including Strata in New York City and ODSC in San Francisco, on topics ranging from natural language processing to data visualization.\u003c\/p\u003e\u003cbr\u003e","brand":"O'Reilly Media","offers":[{"title":"Default Title","offer_id":50651509686546,"sku":"9781492090403","price":25.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0831\/4771\/8930\/files\/img_f22f527e-b3d6-41a6-9cb1-fed988af0511.jpg?v=1733302177","url":"https:\/\/surprise-castle.myshopify.com\/products\/sql-pocket-guide-a-guide-to-sql-usage-9781492090403","provider":"Surprise Castle","version":"1.0","type":"link"}