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 - SQL Tutorial
From the course: Practical Database Design: Implementing Responsible Data Solutions with SQL Querying
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.