SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights

SQL has become an essential tool for analysts and data scientists, and this book provides new and hidden ways to improve skills, solve problems, and make the most of it. It covers common and exotic functions, joins, window functions, subqueries, and regular expressions, as well as how to combine techniques to accomplish goals faster with understandable code.

\n Format: Paperback / softback
\n Length: 350 pages
\n Publication date: 21 September 2021
\n Publisher: O'Reilly Media, Inc, USA
\n

With the exponential growth of data, computing power, and cloud data warehouses, SQL has emerged as an indispensable tool for the astute analyst or data scientist. This practical guide uncovers novel and previously undiscovered techniques to enhance your SQL skills, troubleshoot issues, and optimize SQL's integration into your workflow. You will delve into the utilization of both common and exotic SQL functions, including joins, window functions, subqueries, and regular expressions, in innovative and groundbreaking manners. Moreover, you will learn how to combine SQL techniques to achieve your objectives more efficiently, with comprehensible code. Whether you are a professional working with SQL databases, this reference is an essential resource.

Master the essential steps for preparing your data for analysis.

Employ SQL's powerful date and time manipulation capabilities for time series analysis.

Explore cohort analysis to investigate how groups evolve over time.

Harness SQL's robust functions and operators for text analysis.

Identify outliers in your data and replace them with suitable alternatives.

Establish causality through experiment analysis, commonly referred to as A/B testing.

\n Weight: 620g\n
Dimension: 176 x 234 x 22 (mm)\n
ISBN-13: 9781492088783\n \n