Tanimura, Cathy
SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights
- ISBN 13:
- 9781492088783
- author:
- Tanimura, Cathy
- format:
- Paperback / softback
- publisher:
- O'Reilly Media
- language:
- English
- Publication Year:
- 2021
- Pages:
- 350
- Dimensions:
- 23.2 x 17.8 centimetres (0.57 kg
- Genre:
- Computers, Programming, SQL,
- Condition:
- New
- Availability:
- Item usually sent within 7 working days
Description
Unlock the full potential of SQL with advanced techniques for transforming data into insights. This practical guide reveals new and innovative ways to improve your SQL skills, solve problems, and make the most of SQL as part of your workflow.
Learn how to use SQL functions such as joins, window functions, subqueries, and regular expressions in creative ways, and combine techniques to accomplish your goals faster with understandable code. Whether you work with SQL databases or need a reference for your next project, this book is an essential resource.
Discover how to perform time series analysis, cohort analysis, text analysis, and more using SQL's powerful functions and operators. Learn how to detect outliers, establish causality, and make data-driven decisions with confidence.