Beginning SQL Queries : From Novice to Professional

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
Autor principal: Churcher, Clare. author (author)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Berkeley, CA : Apress 2016.
Edición:2nd ed. 2016.
Colección:Expert's voice in SQL
Materias:
Database management.
Programming languages (Electronic computers).
Data mining.
Computer programming.
Data structures (Computer science).
Database Management.
Programming Languages, Compilers, Interpreters.
Data Mining and Knowledge Discovery.
Programming Techniques.
Data Structures.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629885806719
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.

Ejemplares similares