{"product_id":"sql-cookbook-query-solutions-and-techniques-for-all-sql-users-paperback","title":"SQL Cookbook: Query Solutions and Techniques for All SQL Users - Paperback","description":"\u003cdiv\u003e\u003cp style=\"text-align: right;\"\u003e\u003ca href=\"https:\/\/reportcopyrightinfringement.com\/\" target=\"_blank\" rel=\"nofollow\"\u003e\u003cb\u003eReport copyright infringement\u003c\/b\u003e\u003c\/a\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cp\u003eby \u003cb\u003eAnthony Molinaro\u003c\/b\u003e (Author), \u003cb\u003eRobert de Graaf\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\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 several flavors of SQL, including Oracle, DB2, SQL Server, MySQL, and PostgreSQL. \u003c\/p\u003e\u003cp\u003e SQL 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\u003e The second edition includes: \u003c\/p\u003e\u003cul\u003e \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\u003ch3\u003eAuthor Biography\u003c\/h3\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eAnthony Molinaro is a data scientist at Johnson \u0026amp; Johnson. In his current role he is a manager in the Observational Health Data Analytics group within Janssen R\u0026amp;D. His primary areas of research are nonparametric methods, time series analysis, and large scale database characterization and transformation. He is a member of the open science OHDSI community. Anthony holds a BA in Mathematics and an MA in Applied Mathematics \u0026amp; Statistics from CUNY Hunter College. He resides in NY with his wife, Georgia, and his two daughters, Kiki and Connie.\u003c\/p\u003e\u003cp\u003eRobert de Graaf graduated as an Engineer, and worked in the Manufacturing industry after completing studies. While working as an Engineer, Robert discovered the power of statistics for solving real world problems, and completed a Master's in Statistics in time to benefit from the Data Science boom. He has worked for RightShip as their Senior Data Scientist since 2013, and is the author of Managing Your Data Science Projects.\u003c\/p\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 567\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 1.3 x 9.2 x 7 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e December 08, 2020\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":44840609153126,"sku":"9781492077442","price":75.63,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0599\/7255\/0758\/files\/TWlHOEN0QjV2bmdINlJDL0pjbTlsUT09.webp?v=1772545652","url":"https:\/\/infinitylightwa.com\/products\/sql-cookbook-query-solutions-and-techniques-for-all-sql-users-paperback","provider":"Infinity Light","version":"1.0","type":"link"}