Practical SQL : a beginner's guide to storytelling with data /

Mostrar otras versiones (1)

"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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: DeBarros, Anthony (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: San Francisco : No Starch Press, [2022]
Edición:2nd edition.
Temas:
SQL (Computer program language)
Database design.
SQL (Langage de programmation)
Bases de données > Conception.
Database design
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
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.

Ejemplares similares