Appendix A. Leftovers: The Top Ten Topics we didn’t cover
Even after all that, there’s still a bit more. There are just a few more SQL topics we think you should know. We wouldn’t feel right about ignoring them, although they only need a brief mention. So before you shelve this book next to your collection of Pyrex casserole dishes, enjoy these short, but important SQL morsels. We saved some really tasty bites for the appendix!
#1. Get a GUI for your RDBMS
While it’s important to spend some time coding directly into the SQL console, you know what you’re doing by now. You deserve an easier way to create your tables and see their contents.
You can access every RDBMS using a graphical user interface (GUI), either one that’s officially associated with it or though a general purpose SQL GUI. These tools allow you to interact with your data in a visual, point-and-click way.
MySQL Workbench
The official RDBMS GUI for MySQL is called MySQL Workbench. Developed by Oracle, MySQL Workbench is a free resource that’s compatible with Windows, Mac, or Linux. You can download your own copy directly from this page: https://dev.mysql.com/downloads/workbench.
You can write and edit your SQL queries within MySQL Workbench and then see the results of queries as you execute them. Take advantage ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
