SQL cookbook

You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL...

Descripción completa

Detalles Bibliográficos
Autor principal: Molinaro, Anthony (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Sebastopol, California : O'Reilly 2006.
Edición:1st edition
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627184306719
Tabla de Contenidos:
  • Retrieving records
  • Sorting query results
  • Working with multiple tables
  • Inserting, updating, deleting
  • Metadata queries
  • Working with strings
  • Working with numbers
  • Date arithmetic
  • Date manipulation
  • Working with ranges
  • Advanced searching
  • Reporting and warehousing
  • Hierarchical queries
  • Odds 'n' ends.