What do you think?
Rate this book
SQL Primer: An Accelerated Introduction to SQL Basics
1. An Introduction to SQL2. Getting Your Database Ready3. The Benefit of Constraints4. Operations on Tables5. Writing Basic Queries6. Manipulating Data7. Organizing Your Data8. Doing More with Queries9. Calculated Fields10. Aggregation and Grouping11. Understanding Joins12. Subqueries13. Working in Sets14. Views15. Indexing16. Access Control Appendix A. Further Reading18. Appendix B. Database Management Systems and Tools19. Appendix C. A History of SQL and Relational Databases
214 pages, Paperback
Published June 20, 2018
1 person is currently reading
10 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 2 of 2 reviews
July 3, 2019
The data scientists I've talked to who work in industry offer same advice: Learn SQL! So once I decided to learn SQL, I remembered that Ben LeRoy recommended this book to me a couple months back, so I decided to read through it.
I was very happy with this book: It's similar in spirit to "A Whirlwind Tour of Python" by Jake Vanderplas. Not only was I able to read it in a short period of time (2/3 hours a day, 3 days in a row), but I also got SQLite running on my laptop, so I was able to run many of the queries myself as I worked through the book.
My only complaint is that I wanted a little more on database design, since I've been trying to learn more about Data Modeling in general. And given the author's strengths at explaining concepts, it would have been great to have more on data modeling here. But overall, I would definitely recommend this book.
I was very happy with this book: It's similar in spirit to "A Whirlwind Tour of Python" by Jake Vanderplas. Not only was I able to read it in a short period of time (2/3 hours a day, 3 days in a row), but I also got SQLite running on my laptop, so I was able to run many of the queries myself as I worked through the book.
My only complaint is that I wanted a little more on database design, since I've been trying to learn more about Data Modeling in general. And given the author's strengths at explaining concepts, it would have been great to have more on data modeling here. But overall, I would definitely recommend this book.
April 14, 2020
Does a pretty simple wrap up of the basics and what's what. A good source for when you don't know where to start. And it gives pretty good recommendations to other sources as well.
I read it because I was introduced to SQL rather unorthodoxly and even though I was comfortable with it to a certain level, I wanted to know what I didn't know.
This book however is targeted towards a beginner level as it gives a detailed guiding from installing a management system to step by step examples and explanations.
I read it because I was introduced to SQL rather unorthodoxly and even though I was comfortable with it to a certain level, I wanted to know what I didn't know.
This book however is targeted towards a beginner level as it gives a detailed guiding from installing a management system to step by step examples and explanations.
Displaying 1 - 2 of 2 reviews