SQL Cookbook :Query Solutions and Techniques for All SQL Users

4.02 ( 389 Ratings by Goodreads)
SQL Cookbook

SQL Cookbook :Query Solutions and Techniques for All SQL Users

(Author) (Author)
4.02 (389 Ratings by Goodreads)
paperback
Published: 17 November, 2020
Standard worldwide delivery by Tue, June 16 - Fri, June 19
Order within 0
Condition: NEW
$54.48
RRP $71.16
You save $16.68 (23%)
Price includes shipping
Available 4 in stock
- +
Add to basket Wishlist This
FREE Returns within 30 days
More Details

Description

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
See more

More Details

Type Book
ISBN13 9781492077442
ISBN10 1492077445
Number Of Pages 500
Item Weight 1000 g
Publisher / Reseller O'Reilly Media
Format paperback
Edition 2nd edition
See More +

GoodReads Reviews

Author's Bio

Anthony Molinaro is a SQL developer and database administrator with many years experience in helping developers improve their SQL queries. SQL is particular passion of Anthony's, and he's become known as the go-to guy among his clients when it comes to solving difficult SQL query problems. He's well-read, understands relational theory well, and has nine years of hands-on experience solving tough, SQL problems. Anthony is particularly well-acquainted with new and powerful SQL features such as the windowing function syntax that was added to the most recent SQL standard. 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.

Show more