Learning SQL

Since a few weeks ago I faced writing some batch ingest process written in Python. This information came from Big Data, so, in order to bring back the result set, I had to have to improve my SQL skills. Work with larger datasets could be dangerous and frustrating if you have not enough care for how much information you are querying, aggregating, and storing (as a temporary store). After that, if you are making some visualizations in a web-based plot tool, the response time is critical.

Learning SQL is the best technical book that I have recently read because Alan handles all topics with mastery and carries on with sense, and of course, with interdependence, so you can choose to read chapter-by-chapter or read by your necessities. In my experience, as I have collected some SQL skills, I did not need sequential reading, jumping throughout the book.

With this book, I have improved data definitions like engine type, indexes, views, etc, in order to keep the data flowing into the database.

Each chapter has enough information to leverage your basic-sql knowledge, even, making you more proficient with accurate terms (for duckduckgo-driven engineers this is so important).