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. The book focuses on using SQL to find the story your data tells, with the popular open-source databa...

Descripción completa

Detalles Bibliográficos
Otros Autores: DeBarros, Anthony, author (author)
Formato: Libro electrónico
Idioma:Inglés
Publicado: San Francisco : No Starch Press 2018.
Edición:1st edition
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630658606719
Tabla de Contenidos:
  • Machine generated contents note: Introduction
  • Chapter 1: Creating your first database & table
  • Chapter 2: Beginning Data Exploration with SELECT
  • Chapter 3: Understanding Data Types
  • Chapter 4: Importing and Exporting Data
  • Chapter 5: Basic Math and Stats
  • Chapter 6: Joining Tables in a Relational Database
  • Chapter 7: Table Design that Works for You
  • Chapter 8: Grouping and Summarizing Data
  • Chapter 9: Cleaning , Modifying, Deleting Data
  • Chapter 10: Ranks, Rates, asnd Stats
  • Chapter 11: Dealing with Dates
  • Chapter 12: Advanced Queries
  • Chapter 13: Full-Text Search
  • Chapter 14: GIS
  • Chapter 15: Views
  • Chapter 16: Working from the command line
  • Chapter 17: Maintenance
  • Appendix A: Alternative software and text editors
  • Appendix B: Solutions.