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...
Otros Autores: | , |
---|---|
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.