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

Full description

Bibliographic Details
Main Author: Batra, Rahul (Author, http://id.loc.gov/vocabulary/relators/aut)
Corporate Author: SpringerLink (Online service)
Format: Electronic eBook
Language:English
Published: Berkeley, CA : Apress : Imprint: Apress, 2018.
Edition:1st ed. 2018.
Subjects:
Online Access:Full Text via HEAL-Link
Table of Contents:
  • 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.