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...
Main Author: | |
---|---|
Format: | eBook |
Language: | English |
Published: |
Berkeley, CA
Apress
2018, 2018
|
Edition: | 1st ed. 2018 |
Subjects: | |
Online Access: | |
Collection: | Springer eBooks 2005- - Collection details see MPG.ReNa |
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