Learning SQL generate, manipulate, and retrieve data

As data floods into your company, you need to put it to work right away—and SQL is the best tool for the job. With the latest edition of this introductory guide, author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications, performing administrative t...

Descripción completa

Detalles Bibliográficos
Otros Autores: Beaulieu, Alan, author (author)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Sebastapol, CA : O'Reilly Media, Inc 2022.
Edición:Third edition
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009631023406719
Tabla de Contenidos:
  • A little background
  • Creating and populating a database
  • Query primer
  • Filtering
  • Querying multiple tables
  • Working with sets
  • Data generation, manipulation, and conversion
  • Grouping and aggregates
  • Subqueries
  • Joins revisited
  • Conditional logic
  • Transactions
  • Indexes and constraints
  • Views
  • Metadata
  • Analytic functions
  • Working with large databases
  • SQL and Big Data.