{"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\u003eAuthor:\u003c\/b\u003e Alice Zhao\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e O'Reilly Media\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 09\/21\/2021\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 356\u003cbr\u003e\u003cb\u003eBinding Type:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.58lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 7.00h x 4.25w x 0.74d\u003cbr\u003e\u003cb\u003eISBN:\u003c\/b\u003e 9781492090403\u003cbr\u003e\u003cp\u003e\u003cb\u003eAbout the Author\u003c\/b\u003e\u003cbr\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\u003cbr\u003e","brand":"O'Reilly Media","offers":[{"title":"Paperback","offer_id":39826889638003,"sku":"9781492090403","price":31.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0555\/9255\/0515\/products\/img_a314f6cf-5ab2-4900-a710-ca1fd4654657.jpg?v=1644557328","url":"https:\/\/bookstorenmore.com\/products\/sql-pocket-guide-a-guide-to-sql-usage-9781492090403","provider":"Bookstore N More","version":"1.0","type":"link"}