Beginning SQL queries : from novice to professional /
Get started on mastering the one language binding the entire database industry. That language is SQL, and how it works is must-have knowledge for anyone involved with relational databases, and surprisingly also for anyone involved with NoSQL databases. SQL is universally used in querying and reporti...
Clasificación: | Libro Electrónico |
---|---|
Autor principal: | |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
[United States] :
Apress,
2016.
|
Edición: | Second edition. |
Colección: | Expert's voice in SQL.
|
Temas: | |
Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- 1. Relational Database Overview
- 2. Simple Queries on One Table
- 3. A First Look at Joins
- 4. Nested Queries
- 5. Self Joins
- 6. Multiple Relationships Between Tables
- 7. Set Operations
- 8. Aggregate Operations
- 9. Window Function
- 10. Efficiency Considerations
- 11. Approaching A Query
- 12. Common Problems
- Chapter 13: Appendix 1: Sample Database
- Chapter 14: Appendix 2: Relational Notation.