Cargando…

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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Churcher, Clare (Autor)
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.