Buy New
-
To see product details, add this item to your cart.
Ships from: Amazon.com Sold by: Amazon.com
Used - Very Good
-
To see product details, add this item to your cart.
Ships from: ThriftBooks-Phoenix Sold by: ThriftBooks-Phoenix
Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.
Read instantly on your browser with Kindle for Web.
Using your mobile phone camera - scan the code below and download the Kindle app.
Follow the authors
OK
SQL Cookbook: Query Solutions and Techniques for All SQL Users
Purchase options and add-ons
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
- ISBN-101492077445
- ISBN-13978-1492077442
- Edition2nd
- PublisherO'Reilly Media
- Publication dateDecember 8, 2020
- LanguageEnglish
- Dimensions7 x 1.25 x 9 inches
- Print length567 pages
Frequently bought together

Customers who viewed this item also viewed
- Learning SQL: Generate, Manipulate, and Retrieve DataPaperbackFREE Shipping by AmazonGet it as soon as Sunday, Sep 20
- SQL for Data Analysis: Advanced Techniques for Transforming Data into InsightsPaperbackFREE Shipping by AmazonGet it as soon as Monday, Sep 21Only 19 left in stock (more on the way).
- Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with DataPaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Sunday, Sep 20
- SQL Pocket Guide: A Guide to SQL UsagePaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Sunday, Sep 20
- SQL Programming: a QuickStudy Laminated Reference GuidePamphletFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Sunday, Sep 20
- SQL in a Nutshell: A Desktop Quick ReferencePaperbackFREE Shipping by AmazonGet it as soon as Sunday, Sep 20Only 9 left in stock (more on the way).
Customers also bought or read
- SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights
Paperback$36.49$36.49FREE delivery Mon, Sep 21 - Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data#1 Best SellerComputer Programming Structured Design
Paperback$19.99$19.99Delivery Sun, Sep 20 - SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
Paperback$46.15$46.15FREE delivery Sep 25 - 30 - Python for Data Analysis: Data Wrangling with pandas, NumPy, and Jupyter
Paperback$43.99$43.99FREE delivery Oct 1 - 16 - Fluent Python: Clear, Concise, and Effective Programming
Paperback$43.99$43.99FREE delivery Sun, Sep 20 - Practical Statistics for Data Scientists: 50+ Essential Concepts Using R and Python
Paperback$69.08$69.08FREE delivery Mon, Sep 21 - Fundamentals of Data Engineering: Plan and Build Robust Data Systems
Paperback$40.00$40.00FREE delivery Sep 29 - Oct 14 - The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling
Paperback$38.44$38.44FREE delivery Sun, Sep 20 - SQL Performance Explained Everything Developers Need to Know about SQL Performance
Paperback$49.99$49.99FREE delivery Sun, Sep 20 - SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a “learn-by-doing” approach
Paperback$20.78$20.78Delivery Mon, Sep 21 - Python Data Science Handbook: Essential Tools for Working with Data
Paperback$44.18$44.18FREE delivery Sun, Sep 20 - The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition (Business Skills)
Paperback$49.03$49.03FREE delivery Sun, Sep 20 - Essential Math for Data Science: Take Control of Your Data with Fundamental Linear Algebra, Probability, and Statistics
Paperback$36.22$36.22FREE delivery Mon, Sep 21 - Data Visualization with Microsoft Power BI: How to Design Savvy Dashboards
Paperback$41.33$41.33FREE delivery Mon, Sep 21 - Python Crash Course, 3rd Edition: A Hands-On, Project-Based Introduction to Programming#1 Best SellerPython Programming
Paperback$27.53$27.53Delivery Sun, Sep 20 - Data Science from Scratch: First Principles with Python
Paperback$35.54$35.54FREE delivery Mon, Sep 21 - R for Data Science: Import, Tidy, Transform, Visualize, and Model Data
Paperback$43.99$43.99FREE delivery Sun, Sep 20 - Expert Data Modeling with Power BI: Enrich and optimize your data models to get the best out of Power BI for reporting and business needs
Paperback$29.52$29.52Delivery Sep 25 - 28
From the brand
-
Explore our collection
-
More From O'Reilly
-
Sharing the knowledge of experts
O'Reilly's mission is to change the world by sharing the knowledge of innovators. For over 40 years, we've inspired companies and individuals to do new things (and do them better) by providing the skills and understanding that are necessary for success.
Our customers are hungry to build the innovations that propel the world forward. And we help them do just that.
From the Publisher
From the Preface
SQL is the lingua franca of the data professional. At the same time, it doesn’t always get the attention it deserves compared to the hot tool du jour. As result, it’s common to find people who use SQL frequently but rarely or never go beyond the simplest queries, often enough because they believe that’s all there is.
This book shows how much SQL can do, expanding users’ tool boxes. By the end of the book you will have seen how SQL can be used for statistical analysis; to do reporting in a manner similar to Business Intelligence tools; to match text data; to perform sophisticated analysis on date data; and much more.
Who This Book Is For
This book is meant to be for any SQL user who wants to take their queries further. In terms of ability, it’s meant for someone who knows at least some SQL—you might have read Alan Beaulieu’s Learning SQL, for example—and ideally you’ve had to write queries on data in the wild to answer a real-life problem.
Other than those loose parameters, this is a book for all SQL users, including data engineers, data scientists, data visualization folk, BI people, etc. Some of these users may never or rarely access databases directly, but use their data visualization, BI, or statistical tool to query and fetch data. The emphasis is on practical queries that can solve real-world problems.
Where a small amount of theory appears, it’s there to directly support the practical elements.
What’s Missing from This Book
This is a practical book, chiefly about using SQL to understand data. It doesn’t cover theoretical aspects of databases, database design, or the theory behind SQL except where needed to explain specific recipes or techniques.
It also doesn’t cover extensions to databases to handle data types such as XML and JSON. There are other resources available for those specialist topics.
Editorial Reviews
About the Author
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.
Product details
- Publisher : O'Reilly Media
- Publication date : December 8, 2020
- Edition : 2nd
- Language : English
- Print length : 567 pages
- ISBN-10 : 1492077445
- ISBN-13 : 978-1492077442
- Item Weight : 2.05 pounds
- Dimensions : 7 x 1.25 x 9 inches
- Best Sellers Rank: #123,127 in Books (See Top 100 in Books)
- #7 in MySQL Guides
- #12 in Data Warehousing (Books)
- #15 in SQL
- Customer Reviews:
About the authors

Discover more of the author’s books, see similar authors, read book recommendations and more.

Discover more of the author’s books, see similar authors, read book recommendations and more.























