Leveling up with SQL: advanced techniques for transforming data into insights
Learn to write SQL queries to select and analyze data, and improve your ability to manipulate data. This book will help you take your existing skills to the next level. Author Mark Simon kicks things off with a quick review of basic SQL knowledge, followed by a demonstration of how efficient SQL dat...
Gespeichert in:
| Beteilige Person: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | Englisch |
| Veröffentlicht: |
[New York]
Apress
[2023]
|
| Schlagwörter: | |
| Links: | https://learning.oreilly.com/library/view/-/9781484296851/?ar |
| Zusammenfassung: | Learn to write SQL queries to select and analyze data, and improve your ability to manipulate data. This book will help you take your existing skills to the next level. Author Mark Simon kicks things off with a quick review of basic SQL knowledge, followed by a demonstration of how efficient SQL databases are designed and how to extract just the right data from them. You'll then learn about each individual table's structure and how to work with the relationships between tables. As you progress through the book, you will learn more sophisticated techniques such as using common table expressions and subqueries, analyzing your data using aggregate and windowing functions, and how to save queries in the form of views and other methods. This book employs an accessible approach to work through a realistic sample, enabling you to learn concepts as they arise to improve parts of the database or to work with the data itself. After completing this book, you will have a more thorough understanding of database structure and how to use advanced techniques to extract, manage, and analyze data. What Will You Learn Gain a stronger understanding of database design principles, especially individual tables Understand the relationships between tables Utilize techniques such as views, subqueries, common table expressions, and windowing functions Who Is This Book For: SQL Databases users who want to improve their knowledge and techniques. |
| Beschreibung: | Place of publication from publisher's website. - More Details on Calculations. - Description based on online resource; title from digital title page (viewed on October 06, 2023) |
| Umfang: | 1 Online-Ressource |
| ISBN: | 1484296850 9781484296851 |
Internformat
MARC
| LEADER | 00000cam a22000002 4500 | ||
|---|---|---|---|
| 001 | ZDB-30-ORH-096664363 | ||
| 003 | DE-627-1 | ||
| 005 | 20240228122042.0 | ||
| 007 | cr uuu---uuuuu | ||
| 008 | 231006s2023 xx |||||o 00| ||eng c | ||
| 020 | |a 1484296850 |c electronic book |9 1-4842-9685-0 | ||
| 020 | |a 9781484296851 |c electronic bk. |9 978-1-4842-9685-1 | ||
| 035 | |a (DE-627-1)096664363 | ||
| 035 | |a (DE-599)KEP096664363 | ||
| 035 | |a (ORHE)9781484296851 | ||
| 035 | |a (DE-627-1)096664363 | ||
| 040 | |a DE-627 |b ger |c DE-627 |e rda | ||
| 041 | |a eng | ||
| 072 | 7 | |a UN |2 bicssc | |
| 072 | 7 | |a COM021000 |2 bisacsh | |
| 082 | 0 | |a 005.75/65 |2 23/eng/20230919 | |
| 100 | 1 | |a Simon, Mark |e VerfasserIn |4 aut | |
| 245 | 1 | 0 | |a Leveling up with SQL |b advanced techniques for transforming data into insights |c Mark Simon |
| 264 | 1 | |a [New York] |b Apress |c [2023] | |
| 300 | |a 1 Online-Ressource | ||
| 336 | |a Text |b txt |2 rdacontent | ||
| 337 | |a Computermedien |b c |2 rdamedia | ||
| 338 | |a Online-Ressource |b cr |2 rdacarrier | ||
| 500 | |a Place of publication from publisher's website. - More Details on Calculations. - Description based on online resource; title from digital title page (viewed on October 06, 2023) | ||
| 520 | |a Learn to write SQL queries to select and analyze data, and improve your ability to manipulate data. This book will help you take your existing skills to the next level. Author Mark Simon kicks things off with a quick review of basic SQL knowledge, followed by a demonstration of how efficient SQL databases are designed and how to extract just the right data from them. You'll then learn about each individual table's structure and how to work with the relationships between tables. As you progress through the book, you will learn more sophisticated techniques such as using common table expressions and subqueries, analyzing your data using aggregate and windowing functions, and how to save queries in the form of views and other methods. This book employs an accessible approach to work through a realistic sample, enabling you to learn concepts as they arise to improve parts of the database or to work with the data itself. After completing this book, you will have a more thorough understanding of database structure and how to use advanced techniques to extract, manage, and analyze data. What Will You Learn Gain a stronger understanding of database design principles, especially individual tables Understand the relationships between tables Utilize techniques such as views, subqueries, common table expressions, and windowing functions Who Is This Book For: SQL Databases users who want to improve their knowledge and techniques. | ||
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 0 | |a Relational databases | |
| 650 | 0 | |a Database management | |
| 650 | 4 | |a SQL (Langage de programmation) | |
| 650 | 4 | |a Bases de données relationnelles | |
| 650 | 4 | |a Bases de données ; Gestion | |
| 776 | 1 | |z 9781484296844 | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 9781484296844 |
| 966 | 4 | 0 | |l DE-91 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/9781484296851/?ar |m X:ORHE |x Aggregator |z lizenzpflichtig |3 Volltext |
| 912 | |a ZDB-30-ORH | ||
| 951 | |a BO | ||
| 912 | |a ZDB-30-ORH | ||
| 049 | |a DE-91 | ||
Datensatz im Suchindex
| DE-BY-TUM_katkey | ZDB-30-ORH-096664363 |
|---|---|
| _version_ | 1821494937774981121 |
| adam_text | |
| any_adam_object | |
| author | Simon, Mark |
| author_facet | Simon, Mark |
| author_role | aut |
| author_sort | Simon, Mark |
| author_variant | m s ms |
| building | Verbundindex |
| bvnumber | localTUM |
| collection | ZDB-30-ORH |
| ctrlnum | (DE-627-1)096664363 (DE-599)KEP096664363 (ORHE)9781484296851 |
| 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 |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03144cam a22004572 4500</leader><controlfield tag="001">ZDB-30-ORH-096664363</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240228122042.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">231006s2023 xx |||||o 00| ||eng c</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1484296850</subfield><subfield code="c">electronic book</subfield><subfield code="9">1-4842-9685-0</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781484296851</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-1-4842-9685-1</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)096664363</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP096664363</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)9781484296851</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)096664363</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="072" ind1=" " ind2="7"><subfield code="a">UN</subfield><subfield code="2">bicssc</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM021000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/65</subfield><subfield code="2">23/eng/20230919</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Simon, Mark</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Leveling up with SQL</subfield><subfield code="b">advanced techniques for transforming data into insights</subfield><subfield code="c">Mark Simon</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">[New York]</subfield><subfield code="b">Apress</subfield><subfield code="c">[2023]</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource</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">Place of publication from publisher's website. - More Details on Calculations. - Description based on online resource; title from digital title page (viewed on October 06, 2023)</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Learn to write SQL queries to select and analyze data, and improve your ability to manipulate data. This book will help you take your existing skills to the next level. Author Mark Simon kicks things off with a quick review of basic SQL knowledge, followed by a demonstration of how efficient SQL databases are designed and how to extract just the right data from them. You'll then learn about each individual table's structure and how to work with the relationships between tables. As you progress through the book, you will learn more sophisticated techniques such as using common table expressions and subqueries, analyzing your data using aggregate and windowing functions, and how to save queries in the form of views and other methods. This book employs an accessible approach to work through a realistic sample, enabling you to learn concepts as they arise to improve parts of the database or to work with the data itself. After completing this book, you will have a more thorough understanding of database structure and how to use advanced techniques to extract, manage, and analyze data. What Will You Learn Gain a stronger understanding of database design principles, especially individual tables Understand the relationships between tables Utilize techniques such as views, subqueries, common table expressions, and windowing functions Who Is This Book For: SQL Databases users who want to improve their knowledge and techniques.</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">Relational databases</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management</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">Bases de données relationnelles</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Bases de données ; Gestion</subfield></datafield><datafield tag="776" ind1="1" ind2=" "><subfield code="z">9781484296844</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">9781484296844</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/-/9781484296851/?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="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-096664363 |
| illustrated | Not Illustrated |
| indexdate | 2025-01-17T11:22:19Z |
| institution | BVB |
| isbn | 1484296850 9781484296851 |
| language | English |
| open_access_boolean | |
| owner | DE-91 DE-BY-TUM |
| owner_facet | DE-91 DE-BY-TUM |
| physical | 1 Online-Ressource |
| psigel | ZDB-30-ORH TUM_PDA_ORH ZDB-30-ORH |
| publishDate | 2023 |
| publishDateSearch | 2023 |
| publishDateSort | 2023 |
| publisher | Apress |
| record_format | marc |
| spelling | Simon, Mark VerfasserIn aut Leveling up with SQL advanced techniques for transforming data into insights Mark Simon [New York] Apress [2023] 1 Online-Ressource Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Place of publication from publisher's website. - More Details on Calculations. - Description based on online resource; title from digital title page (viewed on October 06, 2023) Learn to write SQL queries to select and analyze data, and improve your ability to manipulate data. This book will help you take your existing skills to the next level. Author Mark Simon kicks things off with a quick review of basic SQL knowledge, followed by a demonstration of how efficient SQL databases are designed and how to extract just the right data from them. You'll then learn about each individual table's structure and how to work with the relationships between tables. As you progress through the book, you will learn more sophisticated techniques such as using common table expressions and subqueries, analyzing your data using aggregate and windowing functions, and how to save queries in the form of views and other methods. This book employs an accessible approach to work through a realistic sample, enabling you to learn concepts as they arise to improve parts of the database or to work with the data itself. After completing this book, you will have a more thorough understanding of database structure and how to use advanced techniques to extract, manage, and analyze data. What Will You Learn Gain a stronger understanding of database design principles, especially individual tables Understand the relationships between tables Utilize techniques such as views, subqueries, common table expressions, and windowing functions Who Is This Book For: SQL Databases users who want to improve their knowledge and techniques. SQL (Computer program language) Relational databases Database management SQL (Langage de programmation) Bases de données relationnelles Bases de données ; Gestion 9781484296844 Erscheint auch als Druck-Ausgabe 9781484296844 |
| spellingShingle | Simon, Mark Leveling up with SQL advanced techniques for transforming data into insights SQL (Computer program language) Relational databases Database management SQL (Langage de programmation) Bases de données relationnelles Bases de données ; Gestion |
| title | Leveling up with SQL advanced techniques for transforming data into insights |
| title_auth | Leveling up with SQL advanced techniques for transforming data into insights |
| title_exact_search | Leveling up with SQL advanced techniques for transforming data into insights |
| title_full | Leveling up with SQL advanced techniques for transforming data into insights Mark Simon |
| title_fullStr | Leveling up with SQL advanced techniques for transforming data into insights Mark Simon |
| title_full_unstemmed | Leveling up with SQL advanced techniques for transforming data into insights Mark Simon |
| title_short | Leveling up with SQL |
| title_sort | leveling up with sql advanced techniques for transforming data into insights |
| title_sub | advanced techniques for transforming data into insights |
| topic | SQL (Computer program language) Relational databases Database management SQL (Langage de programmation) Bases de données relationnelles Bases de données ; Gestion |
| topic_facet | SQL (Computer program language) Relational databases Database management SQL (Langage de programmation) Bases de données relationnelles Bases de données ; Gestion |
| work_keys_str_mv | AT simonmark levelingupwithsqladvancedtechniquesfortransformingdataintoinsights |