47,35 €*
Versandkostenfrei per Post / DHL
Lieferzeit 1-2 Wochen
Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language) written by longtime professional journalist Anthony DeBarros. SQL is the primary tool that programmers, web developers, researchers, journalists, and others use to explore data in a database. DeBarros focuses on using SQL to find the story in data, with the aid of the popular open-source database PostgreSQL and the pgAdmin interface.
This thoroughly revised second edition includes a new chapter describing how to set up PostgreSQL and more extensive discussion of pgAdmin's best features. The author has also added a chapter on the JSON data format that shows readers how to store and query JSON data. DeBarros has also updated the data in the book throughout, added coverage of additional topics, and perfected the book's examples.
Readers love DeBarros's use of exercises and real-world examples that demonstrate how to:
• Create databases and related tables using your own data
• Correctly define data typesAggregate, sort, and filter data to find patterns
• Clean their data and transfer data as text files
• Create advanced queries and automate tasks
This book uses PostgreSQL, but the SQL syntax is applicable to many database applications, including Microsoft SQL Server and MySQL.
Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language) written by longtime professional journalist Anthony DeBarros. SQL is the primary tool that programmers, web developers, researchers, journalists, and others use to explore data in a database. DeBarros focuses on using SQL to find the story in data, with the aid of the popular open-source database PostgreSQL and the pgAdmin interface.
This thoroughly revised second edition includes a new chapter describing how to set up PostgreSQL and more extensive discussion of pgAdmin's best features. The author has also added a chapter on the JSON data format that shows readers how to store and query JSON data. DeBarros has also updated the data in the book throughout, added coverage of additional topics, and perfected the book's examples.
Readers love DeBarros's use of exercises and real-world examples that demonstrate how to:
• Create databases and related tables using your own data
• Correctly define data typesAggregate, sort, and filter data to find patterns
• Clean their data and transfer data as text files
• Create advanced queries and automate tasks
This book uses PostgreSQL, but the SQL syntax is applicable to many database applications, including Microsoft SQL Server and MySQL.
1. Setting up pgAdmin
2. Creating Your First Database and Table
3. Beginning Data Exploration with SELECT
4. Understanding Data Types
5. Importing and Exporting Data
6. Basic Math and Stats
7. Joining Tables in a Relational Database
8. Table Design that Works for You
9. Extracting Information by Grouping and Summarizing
10. Inspecting and Modifying Data
11. Statistical Functions in SQL
12. Working with Dates and Times
13. Advanced Query Techniques
14. Mining Text to Find Meaningful Data
15. Analyzing Spatial Data with PostGIS
16. Working with JSON Data
17. Saving Time with Views, Functions, and Triggers
18. Using PostgreSQL from the Command Line
19. Maintaining Your Database
20. Identifying and Telling the Story Behind Your Data
Appendix A. Additional Resources
| Erscheinungsjahr: | 2022 |
|---|---|
| Fachbereich: | Programmiersprachen |
| Genre: | Importe, Informatik |
| Rubrik: | Naturwissenschaften & Technik |
| Medium: | Taschenbuch |
| Inhalt: | Einband - flex.(Paperback) |
| ISBN-13: | 9781718501065 |
| ISBN-10: | 1718501064 |
| Sprache: | Englisch |
| Einband: | Kartoniert / Broschiert |
| Autor: | Debarros, Anthony |
| Auflage: | 2nd Edition |
| Hersteller: |
Random House LLC US
No Starch Press |
| Maße: | 176 x 233 x 25 mm |
| Von/Mit: | Anthony Debarros |
| Erscheinungsdatum: | 24.01.2022 |
| Gewicht: | 0,786 kg |
1. Setting up pgAdmin
2. Creating Your First Database and Table
3. Beginning Data Exploration with SELECT
4. Understanding Data Types
5. Importing and Exporting Data
6. Basic Math and Stats
7. Joining Tables in a Relational Database
8. Table Design that Works for You
9. Extracting Information by Grouping and Summarizing
10. Inspecting and Modifying Data
11. Statistical Functions in SQL
12. Working with Dates and Times
13. Advanced Query Techniques
14. Mining Text to Find Meaningful Data
15. Analyzing Spatial Data with PostGIS
16. Working with JSON Data
17. Saving Time with Views, Functions, and Triggers
18. Using PostgreSQL from the Command Line
19. Maintaining Your Database
20. Identifying and Telling the Story Behind Your Data
Appendix A. Additional Resources
| Erscheinungsjahr: | 2022 |
|---|---|
| Fachbereich: | Programmiersprachen |
| Genre: | Importe, Informatik |
| Rubrik: | Naturwissenschaften & Technik |
| Medium: | Taschenbuch |
| Inhalt: | Einband - flex.(Paperback) |
| ISBN-13: | 9781718501065 |
| ISBN-10: | 1718501064 |
| Sprache: | Englisch |
| Einband: | Kartoniert / Broschiert |
| Autor: | Debarros, Anthony |
| Auflage: | 2nd Edition |
| Hersteller: |
Random House LLC US
No Starch Press |
| Maße: | 176 x 233 x 25 mm |
| Von/Mit: | Anthony Debarros |
| Erscheinungsdatum: | 24.01.2022 |
| Gewicht: | 0,786 kg |
Ähnliche Produkte
Lieferzeit 1-2 Werktage
Lieferzeit 4-7 Werktage
Lieferzeit 1-2 Werktage
Aktuell nicht verfügbar
Lieferzeit 2-3 Wochen
Lieferzeit 1-2 Werktage
