{"product_id":"sql-pocket-guide-a-guide-to-sql-usage-paperback","title":"SQL Pocket Guide: A Guide to SQL Usage - Paperback","description":"\u003cp\u003eby \u003cb\u003eAlice Zhao\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\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\u003ch3\u003eAuthor Biography\u003c\/h3\u003e\u003cp\u003e\u003c\/p\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\u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 354\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.74 x 7 x 4.25 IN\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e October 05, 2021\u003c\/div\u003e","brand":"Books by splitShops","offers":[{"title":"Default Title","offer_id":42122061316231,"sku":"9781492090403","price":35.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0601\/2623\/2711\/files\/d5e33cfeec52306269db9873500a2442.webp?v=1732557788","url":"https:\/\/booksby.splitshops.com\/products\/sql-pocket-guide-a-guide-to-sql-usage-paperback","provider":"Books by splitShops","version":"1.0","type":"link"}