Master the expressive power of SQL with a highly practical approach to creating and manipulating large data stores. Solve day-to-day database conundrums using real-world examples across multiple flavors including Oracle, MySQL, and PostgreSQL. This updated second edition provides a comprehensive framework of practical SQL recipes for programmers and data scientists. It features a Problem/Solution/Discussion format to tackle complex queries and modernize data management workflows.
Specifications
Key Features
Multi-Platform Solutions: Provides executable examples for several major SQL flavors, including Oracle, DB2, SQL Server, MySQL, and PostgreSQL.
Window Function Mastery: Includes fully revised recipes that leverage the powerful and now widely adopted window functions for advanced analysis.
Common Table Expressions (CTEs): Features new and additional recipes utilizing CTEs to create more readable and easier-to-implement query solutions.
Data Science Focused: Contains specific new recipes designed to make SQL more accessible and useful for non-database experts, such as data scientists.
Advanced Data Manipulation: Offers expanded techniques for working with complex numbers and strings, including "walking a string" to parse delimited elements.
Reporting and Reshaping: Teaches sophisticated methods for pivoting results, creating histograms, and performing aggregations over moving ranges.