SQL for data analysis: advanced techniques for transforming data into insights
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 workflo...
Saved in:
| Main Author: | |
|---|---|
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Sebastopol, CA
O'Reilly Media
2021
|
| Edition: | First edition. |
| Subjects: | |
| Links: | https://learning.oreilly.com/library/view/-/9781492088776/?ar |
| 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. 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. |
| Item Description: | Includes index. - Print version record |
| Physical Description: | 1 online resource illustrations |
| ISBN: | 9781492088752 1492088757 9781492088738 1492088730 |
Staff View
MARC
| LEADER | 00000cam a22000002c 4500 | ||
|---|---|---|---|
| 001 | ZDB-30-ORH-06076192X | ||
| 003 | DE-627-1 | ||
| 005 | 20240228121518.0 | ||
| 007 | cr uuu---uuuuu | ||
| 008 | 201219s2021 xx |||||o 00| ||eng c | ||
| 020 | |a 9781492088752 |c electronic bk. |9 978-1-4920-8875-2 | ||
| 020 | |a 1492088757 |c electronic bk. |9 1-4920-8875-7 | ||
| 020 | |a 9781492088738 |c electronic book |9 978-1-4920-8873-8 | ||
| 020 | |a 1492088730 |c electronic book |9 1-4920-8873-0 | ||
| 035 | |a (DE-627-1)06076192X | ||
| 035 | |a (DE-599)KEP06076192X | ||
| 035 | |a (ORHE)9781492088776 | ||
| 035 | |a (DE-627-1)06076192X | ||
| 040 | |a DE-627 |b ger |c DE-627 |e rda | ||
| 041 | |a eng | ||
| 082 | 0 | |a 005.75/65 |2 23 | |
| 100 | 1 | |a Tanimura, Cathy |e VerfasserIn |4 aut | |
| 245 | 1 | 0 | |a SQL for data analysis |b advanced techniques for transforming data into insights |c Cathy Tanimura |
| 250 | |a First edition. | ||
| 264 | 1 | |a Sebastopol, CA |b O'Reilly Media |c 2021 | |
| 264 | 4 | |c ©2021 | |
| 300 | |a 1 online resource |b illustrations | ||
| 336 | |a Text |b txt |2 rdacontent | ||
| 337 | |a Computermedien |b c |2 rdamedia | ||
| 338 | |a Online-Ressource |b cr |2 rdacarrier | ||
| 500 | |a Includes index. - Print version record | ||
| 520 | |a 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. 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. | ||
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 0 | |a Mathematical statistics | |
| 650 | 4 | |a SQL (Langage de programmation) | |
| 650 | 4 | |a Mathematical statistics | |
| 650 | 4 | |a SQL (Computer program language) | |
| 776 | 1 | |z 1492088781 | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 1492088781 |
| 966 | 4 | 0 | |l DE-91 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/9781492088776/?ar |m X:ORHE |x Aggregator |z lizenzpflichtig |3 Volltext |
| 912 | |a ZDB-30-ORH | ||
| 912 | |a ZDB-30-ORH | ||
| 951 | |a BO | ||
| 912 | |a ZDB-30-ORH | ||
| 049 | |a DE-91 | ||
Record in the Search Index
| DE-BY-TUM_katkey | ZDB-30-ORH-06076192X |
|---|---|
| _version_ | 1833357042404818945 |
| adam_text | |
| any_adam_object | |
| author | Tanimura, Cathy |
| author_facet | Tanimura, Cathy |
| author_role | aut |
| author_sort | Tanimura, Cathy |
| author_variant | c t ct |
| building | Verbundindex |
| bvnumber | localTUM |
| collection | ZDB-30-ORH |
| ctrlnum | (DE-627-1)06076192X (DE-599)KEP06076192X (ORHE)9781492088776 |
| dewey-full | 005.75/65 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/65 |
| dewey-search | 005.75/65 |
| dewey-sort | 15.75 265 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | First edition. |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02705cam a22004812c 4500</leader><controlfield tag="001">ZDB-30-ORH-06076192X</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240228121518.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">201219s2021 xx |||||o 00| ||eng c</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781492088752</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-1-4920-8875-2</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1492088757</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">1-4920-8875-7</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781492088738</subfield><subfield code="c">electronic book</subfield><subfield code="9">978-1-4920-8873-8</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1492088730</subfield><subfield code="c">electronic book</subfield><subfield code="9">1-4920-8873-0</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)06076192X</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP06076192X</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)9781492088776</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)06076192X</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-627</subfield><subfield code="b">ger</subfield><subfield code="c">DE-627</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1=" " ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/65</subfield><subfield code="2">23</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Tanimura, Cathy</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">SQL for data analysis</subfield><subfield code="b">advanced techniques for transforming data into insights</subfield><subfield code="c">Cathy Tanimura</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">First edition.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Sebastopol, CA</subfield><subfield code="b">O'Reilly Media</subfield><subfield code="c">2021</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2021</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource</subfield><subfield code="b">illustrations</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">Text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">Computermedien</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">Online-Ressource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index. - Print version record</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">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. 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.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Mathematical statistics</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Langage de programmation)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Mathematical statistics</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="776" ind1="1" ind2=" "><subfield code="z">1492088781</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">1492088781</subfield></datafield><datafield tag="966" ind1="4" ind2="0"><subfield code="l">DE-91</subfield><subfield code="p">ZDB-30-ORH</subfield><subfield code="q">TUM_PDA_ORH</subfield><subfield code="u">https://learning.oreilly.com/library/view/-/9781492088776/?ar</subfield><subfield code="m">X:ORHE</subfield><subfield code="x">Aggregator</subfield><subfield code="z">lizenzpflichtig</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="951" ind1=" " ind2=" "><subfield code="a">BO</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91</subfield></datafield></record></collection> |
| id | ZDB-30-ORH-06076192X |
| illustrated | Illustrated |
| indexdate | 2025-05-28T09:45:24Z |
| institution | BVB |
| isbn | 9781492088752 1492088757 9781492088738 1492088730 |
| language | English |
| open_access_boolean | |
| owner | DE-91 DE-BY-TUM |
| owner_facet | DE-91 DE-BY-TUM |
| physical | 1 online resource illustrations |
| psigel | ZDB-30-ORH TUM_PDA_ORH ZDB-30-ORH |
| publishDate | 2021 |
| publishDateSearch | 2021 |
| publishDateSort | 2021 |
| publisher | O'Reilly Media |
| record_format | marc |
| spelling | Tanimura, Cathy VerfasserIn aut SQL for data analysis advanced techniques for transforming data into insights Cathy Tanimura First edition. Sebastopol, CA O'Reilly Media 2021 ©2021 1 online resource illustrations Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Includes index. - Print version record 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. 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 (Computer program language) Mathematical statistics SQL (Langage de programmation) 1492088781 Erscheint auch als Druck-Ausgabe 1492088781 |
| spellingShingle | Tanimura, Cathy SQL for data analysis advanced techniques for transforming data into insights SQL (Computer program language) Mathematical statistics SQL (Langage de programmation) |
| title | SQL for data analysis advanced techniques for transforming data into insights |
| title_auth | SQL for data analysis advanced techniques for transforming data into insights |
| title_exact_search | SQL for data analysis advanced techniques for transforming data into insights |
| title_full | SQL for data analysis advanced techniques for transforming data into insights Cathy Tanimura |
| title_fullStr | SQL for data analysis advanced techniques for transforming data into insights Cathy Tanimura |
| title_full_unstemmed | SQL for data analysis advanced techniques for transforming data into insights Cathy Tanimura |
| title_short | SQL for data analysis |
| title_sort | sql for data analysis advanced techniques for transforming data into insights |
| title_sub | advanced techniques for transforming data into insights |
| topic | SQL (Computer program language) Mathematical statistics SQL (Langage de programmation) |
| topic_facet | SQL (Computer program language) Mathematical statistics SQL (Langage de programmation) |
| work_keys_str_mv | AT tanimuracathy sqlfordataanalysisadvancedtechniquesfortransformingdataintoinsights |