BookFronter
SQL for Data Analysis by Cathy Tanimura

SQL for Data Analysis

Advanced Techniques for Transforming Data Into Insights

Cathy Tanimura

O'Reilly Media · Print & ebook · October 19, 2021

With the explosion of data, computing power, and cloud data warehouses, SQL has become an even more indispensable tool for the savvy analyst or data scientist.

Data MiningSQL & DatabasesData Warehousingscience
More
series
Buy on Amazon

We earn from qualifying purchases.

Who it’s for
Explore SQL techniques for preparing data, analyzing groups over time, and examining experiments.
Themes
Data preparation and analysis, Time series and cohort analysis, SQL-based experiment analysis
Genres
SQL & Databases, Data Mining, Data Warehousing

Nearest books

Matched by what the books are about, then ordered by what their readers also loved.

  1. MySQL Crash CourseRick Silva54% matchShares SQL & Databases
  2. Microsoft Visual C# Step by StepJohn Sharp52% match
  3. Fighting Churn With DataCarl S. Gold47% matchShares Data Mining
  4. Google Bigquery: the Definitive GuideValliappa Lakshmanan, Jordan Tigani59% matchShares SQL & Databases and Data Warehousing
  5. Python Tools for ScientistsLee Vaughan51% match
  6. Relevant SearchDoug Turnbull, John Berryman49% match
  7. SQL for DummiesAllen G. Taylor67% matchShares SQL & Databases
  8. Spark: the Definitive GuideBill Chambers, Matei Zaharia59% matchShares Data Mining

For younger readers: The CS Detective, Basher Science Mini: Artificial Intelligence

Start with three books, and this one can be the first.

Members get a new edition every morning: a route out from their books to essays, research and talks, with the reason for each.

Start with this book

About this book

With the explosion of data, computing power, and cloud data warehouses, SQL has become an even more indispensable tool for the savvy analyst or data scientist. This practical book reveals new and hidden ways to improve your SQL skills, solve problems, and make the most of SQL as part of your workflow.

Continue reading

You'll learn how to use both common and exotic SQL functions such as joins, window functions, subqueries, and regular expressions in new, innovative ways--as well as how to combine SQL techniques to accomplish your goals faster, with understandable code. If you work with SQL databases, this is a must-have reference. - Learn the key steps for preparing your data for analysis - Perform time series analysis using SQL's date and time manipulations - Use cohort analysis to investigate how groups change over time - Use SQL's powerful functions and operators for text analysis - Detect outliers in your data and replace them with alternate values - Establish causality using experiment analysis, also known as A/B testing

SQL Analysis Techniques

Explore SQL techniques for preparing data, analyzing groups over time, and examining experiments.

Come here for

  • Preparing data for analysis
  • Time series and cohort analysis

Expect

  • SQL date and time manipulations
  • Text analysis, outlier handling, and A/B testing

Where it sits

Data Mining92%
SQL & Databases82%
Data Warehousing38%

Percentages are BookFrontier’s reading of the book.

Publisher categories

  • Data Mining
  • Data Warehousing
  • SQL & Databases
  • Data Modeling
Show all 6 publisher categories
  • Math & Stats Software
  • Machine Learning
Authors
Cathy Tanimura
Publisher
O'Reilly Media
Published
October 19, 2021
Format
Print & ebook
Theme
Data preparation and analysis · Time series and cohort analysis · SQL-based experiment analysis
Reading lane
Data Mining