“Learn SQL the Hard Way” by Zed A. Shaw is a great ebook for those who want to learn SQL essentials. At $19.99 USD, it may seem a bit expensive for an ebook, but you’re getting a DRM-free PDF, plus a whole bunch of explanatory videos and additional files.
Who should read “Learn SQL the Hard Way”? Anyone interested in SQL basics – modifying databases or selecting information. Make no mistake about it: this book focuses heavily on the practical side of database language. People who love delving into theory and reading masses of details will be disappointed.
About the Author
Zed Shaw is a software developer and the author of several books on programming. He is best known for the book “Learn Python the Hard Way”, which is part of a series called “Learn Code the Hard Way”. The SQL book is part of this series.
It is worthwhile to mention that the ebook’s text was available to read for free directly from the website. As he was writing the content, Shaw took feedback from readers and, after many corrections and adjustments, he made it into this ebook.
Why Learn the Hard Way?
To learn the hard way means to learn through experience or by making mistakes. That is exactly what this course is about. The book takes things slowly. It eschews huge amounts of incomprehensible text about query language techniques and long-winded introductions on how things work. Instead, Shaw gives us a few lines of code and a simple explanation for every word in every line. When combined with the video tutorials, this makes understanding the presented SQL fundamentals very easy.
What’s Inside “Learn SQL the Hard Way”?
The first pages define who and what this course is for. The author describes every aspect of the book very carefully, showing the best way to use it and explaining who will get the most benefit from it. Also, he explains why SQL has such an important role nowadays and why everyone should know its fundamentals. In my opinion, this is very important – it will make beginners confident that they have chosen the right book.
Help with Getting Started
This book uses SQLite3 as a training tool. SQLite3 is a very simple database system that doesn’t require complicated setup. Should the user run into any problems, though, the book’s first exercise (called Exercise 0) is installation instructions. There’s also a description of which programs are needed and where to find them. Other important information is contained in videos that show users how to install what they need. Every operating system gets its own video – this alone deserves rounds of applause – so everyone, no matter what platform they use, can use this course.
In addition, there is also a huge help for people who don’t know how to use a command line – the Command Line Crash Course. It is very helpful for beginners and those looking to expand, update, or refresh their knowledge.
Book Structure and Content
The author has divided all database operations into four main areas – Create, Read, Update and Delete. This gives us the familiar CRUD acronym for fundamental database operations.
Every exercise is split into three parts, all of which go towards explaining one of these operations. The first demonstrates and demystifies every line of code. The second helps us to understand what the activity should accomplish, and the third part tells us what other aspects of this SQL statement are worth practicing (and other useful tips).
Every exercise has its own accompanying video tutorial. In fact, all this book’s materials are made with an eye for accuracy and easy comprehension. The explanation of even tiny aspects of good SQL was obviously very important to the author. The quality of these tutorials is the main reason why this book makes learning SQL enjoyable. And it encourages the reader to make up more learning exercises.
The lessons in this book were described quite accurately and I really learned a lot from them. Unfortunately, there is much less information about reading and selecting data functions than I expected. After finishing this book, the reader will able to make simple data selections, but some notable features are missing. One of them is the HAVING function, which is essential when learning about GROUP BY. Another is an explanation of JOINS. Overall, I would have liked to see more about these and other functions.
Also, I didn’t find anything about set operations (like UNION) and there is nothing at all about NULLs – what they are and how they’re is used in different functions. I found this omission very unexpected.
Zed Shaw’s “Learn SQL the Hard Way” will teach absolute beginners how to create and manage basic database structure, but at the expense of learning how to retrieve data using queries. (You can use Vertabelo Academy’s SQL Queries course to make up the lack, if you’d like.)
Overall, I’d say that this is a very good book if you know nothing about databases and are a bit afraid of the subject. As far as training books go, it is quite an affordable package and it shows a very easy way to get some simple database administrator skills – in other words, today’s essential computer abilities. If you’re hesitating, give it a try. It may be the best $20 you spend in a long time.
“Learn SQL the Hard Way” is available online. PayPal is accepted.