SQL Primer

The recent surge of interest in data science has propelled the SQL language to the top of the list of languages for anyone working with data to learn and have in their proverbial toolbelt. This book provides a foundation in the SQL language that will benefit programmers, database administrators, data scientists, and others . The book is short and sweet, focusing on the most-used parts of SQL without getting bogged down in arcane details or vendor-specific features. The book teaches a database agnostic SQL that works on almost any database system, and provides a sound foundation on which to build one's expertise in the language.

Provides a foundation in the most important language when working with data Focuses on the most used parts of SQL, without getting bogged down in arcane details Teaches database-agnostic SQL that works on almost any database system

Autorentext
Rahul Batra was first introduced to programming in 1996 with GWBASIC, but he did not seriously foray into programming until 2001 when he started learning C++. Along the way, Rahul dabbled in many other languages such as C, Ruby, Perl, Python, and Lisp. He has worked with databases such as PostgreSQL, Sybase ASA, and SQLite. He is passionate about sharing knowledge, especially with those who are just starting out. Rahul currently lives and works in Gurgaon, India.

Inhalt

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.