Practical SQL a beginner's guide to storytelling with data
"Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. Anthony DeBarros, a journalist and data analyst, focuses on using SQL to find the story within your...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
San Francisco :
No Starch Press
[2022]
|
| Edición: | 2nd edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009645687406719 |
Tabla de Contenidos:
- Introduction
- Setting up your coding environment
- Creating your first database and table
- Beginning data exploration with SELECT
- Understanding data types
- Importing and exporting data
- Basic math and stats with SQL
- Joining tables in a relational database
- Table design that works for you
- Extracting information by grouping and summarizing
- Inspecting and modifying data
- Statistical functions in SQL
- Working with dates and times
- Advanced query techniques
- Mining text to find meaningful data
- Analyzing spatial data with PostGIS
- Working with JSON data
- Saving time with views, functions, and triggers
- Using PostgreSQL from the command line
- Maintaining your database
- Telling your data's story
- Appendix A. Additional PostgreSQL resources.
