SQL cookbook query solutions and techniques for all SQL users

You may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data. Based on real-world examples, this updated cookbook provides a framework to...

Descripción completa

Detalles Bibliográficos
Otros Autores: Molinaro, Anthony, author (author), De Graaf, Robert W., author
Formato: Libro electrónico
Idioma:Inglés
Publicado: Sebastopol, California : O'Reilly [2021]
Edición:Second edition
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630845406719
Tabla de Contenidos:
  • Retrieving records
  • Sorting query results
  • Working with multiple tables
  • Inserting, updating, and deleting
  • Metadata queries
  • Working with strings
  • Working with numbers
  • Date arithmetic
  • Date manipulation
  • Working with ranges
  • Advanced searching
  • Reporting and reshaping
  • Hierarchical queries
  • Odds 'n' ends.