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 arent 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
Author: Anthony Molinaro, Robert de Graaf
Binding Type: Paperback
Publisher: OReilly Media
Published: 12/08/2020
Pages: 567
Weight: 2.05lbs
Size: 9.20h x 7.00w x 1.30d
ISBN: 9781492077442
Language: English
Reviews
There are no reviews yet.