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)
Autor Corporativo: SpringerLink (Online service)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Berkeley, CA : Apress : Imprint: Apress, 2016.
Edición:2nd ed. 2016.
Temas:
Acceso en línea:Texto Completo
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.