SQL Primer An Accelerated Introduction to SQL Basics

Build a core level of competency in SQL so you can recognize the parts of queries and write simple SQL statements. SQL knowledge is essential for anyone involved in programming, data science, and data management. This book covers features of SQL that are standardized and common across most database...

Descripción completa

Detalles Bibliográficos
Autor principal: Batra, Rahul. author (author)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Berkeley, CA : Apress 2018.
Edición:1st ed. 2018.
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630630406719
Tabla de Contenidos:
  • 1. An Introduction to SQL
  • 2. Getting Your Database Ready
  • 3. The Benefit of Constraints
  • 4. Operations on Tables
  • 5. Writing Basic Queries
  • 6. Manipulating Data
  • 7. Organizing Your Data
  • 8. Doing More with Queries
  • 9. Calculated Fields
  • 10. Aggregation and Grouping
  • 11. Understanding Joins
  • 12. Subqueries
  • 13. Working in Sets
  • 14. Views
  • 15. Indexing
  • 16. Access Control Statements
  • 17: Appendix A. Further Reading
  • 18. Appendix B. Database Management Systems and Tools
  • 19. Appendix C. A History of SQL and Relational Databases.