Amazon cover image
Image from Amazon.com

SQL for Data Analysis : advanced techniques for transforming data into insights / Cathy Tanimura

By: Material type: TextTextPublication details: Sebastopol, California : O'Reilly Media, Incorporated, c2021Edition: First EditionDescription: 342 pages : illustrations ; 24 cmISBN:
  • 9781492088783
Subject(s): LOC classification:
  • QA 76.73.S67 .T36 2021
Contents:
1. Analysis with SQL -- 2. Preparing data for analysis -- 3. Time series analysis -- 4. Cohort analysis -- 5. Text analysis -- 6. Anomaly detection -- 7. Experiment analysis -- 8. Creating complex data sets for analysis -- 9. Conclusion
Summary: 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. 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.
Item type: Books
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Home library Collection Call number Copy number Status Date due Barcode
Books Books National University - Manila LRC - Main General Circulation Digital Forensic GC QA 76.73.S67 .T36 2021 (Browse shelf(Opens below)) c.1 Available NULIB000019368

Includes index.

1. Analysis with SQL -- 2. Preparing data for analysis -- 3. Time series analysis -- 4. Cohort analysis -- 5. Text analysis -- 6. Anomaly detection -- 7. Experiment analysis -- 8. Creating complex data sets for analysis -- 9. Conclusion

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. 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.

There are no comments on this title.

to post a comment.