Cargando…
Effective SQL : 61 specific ways to write better SQL /
Presents practical solutions and insights for solving complex problems with SQL and designing databases that simplify data management in the future. Brings together advanced best practices and realistic example code for all of these versions of SQL: IBM DB2, Microsoft Access, Microsoft SQL Server, M...
| Clasificación: | Libro Electrónico |
|---|---|
| Autores principales: | , , |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Boston :
Addison-Wesley,
[2017]
|
| Colección: | Effective software development series.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Data model design
- Programmability and index design
- When you can't change the design
- Filtering and finding data
- Aggregation
- Subqueries
- Getting and analyzing metadata
- Cartesian products
- Tally tables
- Modeling hierarchical data
- Appendix: Date and time types, operations, and functions.