From the course: Practical Database Design: Implementing Responsible Data Solutions with SQL Querying

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

Overview of MySQL Workbench

Overview of MySQL Workbench

- [Instructor] We're ready to digitize your pen and paper logical database model for the Brainery. You can choose from a range of database management systems. We're using MySQL Workbench. MySQL Workbench provides data analysts, engineers, and other database professionals with a single platform to store their data model, datasets, develop their SQL queries, and conduct some database maintenance. It's completely free so you don't have to worry about pesky licensing fees. Our first goal is to ensure that every entity, relationship, and carnality from the logical database model is accurately reflected within MySQL Workbench. I'll be using version 8.0.32 because it's the most stable version at the time of this recording. After you install and configure your SQL Workbench, go ahead and open it back up. It's pretty bare, but behind this minimalist layout is a robust interface. You should have one MySQL connections local instance. We'll use it after we are finished adding our data model…

Contents