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. 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
Clasificación:Libro Electrónico
Autor principal: DeBarros, Anthony (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: San Francisco : No Starch Press, 2018.
Temas:
SQL (Computer program language)
Database design.
SQL (Langage de programmation)
Bases de données > Conception.
COMPUTERS > Programming Languages > SQL.
COMPUTERS > Databases > General.
COMPUTERS > Databases > Data Mining.
Database design
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Introduction
  • 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 queries techniques
  • Mining text to find meaningful data
  • Analyzing spatial data with PostGIS
  • Saving time with views, functions, and triggers
  • Using postgreSQL from the command line
  • Maintaining your database
  • Identifying and telling the story behind your data
  • Appendix: Additional postgreSQL resources.

Ejemplares similares