You 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.

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.

The second edition includes:

Fully revised recipes that recognize the greater adoption of window functions in SQL implementations
Additional recipes that reflect the widespread adoption of common table expressions (CTEs) for more readable, easier-to-implement solutions
New recipes to make SQL more useful for people who aren't database experts, including data scientists
Expanded solutions for working with numbers and strings
Up-to-date SQL recipes throughout the book to guide you through the basics

About the Authors

Anthony Molinaro is a data scientist at Johnson & Johnson. In his current role he is a manager in the Observational Health Data Analytics group within Janssen R&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 & Statistics from CUNY Hunter College. He resides in NY with his wife, Georgia, and his two daughters, Kiki and Connie.

Robert 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.

"About this title" may belong to another edition of this title.

Store Description

Archives Books, Inc. is a family owned and operated company, established in 1989 in Edmond, OK, which has been selling books locally and online for more than 30 years. Our first online sale was in 1995, being one of the first book dealers to sell used books online. Being on the ground floor of the online used book business, we have acquired a rare knowledge of the industry that helps us provide an unmatched customer service experience. In addition to our online listings, we have a brick and mortar store located in Edmond, Oklahoma at 1914 E. 2nd Street. We buy and sell at this location Monday thru Saturday, 10am-6pm. We currently add thousands of titles to our online inventory each month and sell hundreds of books each day, so inventory is always changing and the selection is always different. What began in 1989 has turned out to be one of Oklahoma's finest used bookstores and continues to be an excellent provider of used books worldwide.

Visit Seller's Storefront

Seller's business information

Archives Books, Inc.
1914 E 2nd Street, Edmond, OK, 73034, U.S.A.

Sale & Shipping Terms

Terms of Sale

Customer Satisfaction guaranteed! All orders ship within 24-48 hours. Your total satisfaction is our goal. If you are unhappy with your purchase for any reason, simply email us with a brief explanation of your problem and we will get back with you within 24 hours, Monday thru Friday with a resolution. We are closed on the weekends, therefore, if contacting on Sat. or Sun., please allow 48 hours for response. We can be contacted at archivesbooks@sbcglobal.net.

Archives Books inc.
1914 E. 2nd Stre...

More Information

Shipping Terms

Orders usually ship within 24-48 hours of order date. Priority shipping normally takes 3 to 5 business days to arrive. Standard Mail averages 4 to 10 business days but in some rare cases may take longer to arrive. International shipping may require additonal costs for oversized items. International shipping normally takes 4 to 20 business days but in some rare cases can take longer to arrive. If your book order is heavy or oversized, we may contact you to let you know extra shipping is required.