MySQL Workbench

Hello Noobs!

Don't feel bad about it, I'm a noob, too! Even with knowledge of MySQL, basic knowledge doesn't give me experience. You, my friend, will leave this blog with the knowledge needed to start your database management system and create an entity relationship diagram using the MySQL workbench. 

When I first learned about MySQL, the hard part was reading about it. I read for almost 3 to 4 weeks, not being hands-on like Java, Python, or other programming languages for my 5-week college course. When I first began the hands-on process, YouTube was my friend, assisting me in getting the correct downloads. Watch the video below to see how to set yourself up for success. He helped me and will be of great help to you, too! 

Is it true that MySQL is easy?

I read many articles about MySQL's ease, especially if you have Microsoft Access and Excel knowledge. This is totally TRUE! 

As a Pisces-Aries Cusp, the hardest part was slowing my creative mind and focusing on the parts. If you have knowledge of Java's object-oriented functionality (and if you don't), MySQL will help you understand it more clearly and boost your programming skills. MySQL is about forming relationships between the created tables and their columns and querying the data for viewing. The setback is the same for all technology software, human error. It's a good thing keyboards have backspace and delete keys! MySQL has delete, update, and alter functionalities that work similarly. 

MySQL Query Language

To help start you on your way to creating a database, I have made a user guide to build an online food ordering database using the MySQL Workbench. You can view this document or download it for free using the button at the end!

SQL Query: Create Tables 

This document provides the standard query language used to create tables for the data.

SQL Query: Data 

This document provides the standard query language used to add data to the tables you create.

Entity Relationship Diagram (ERD)

Once your database is complete with tables and data, creating an ERD is simple! I forewarn you, when MySQL Workbench creates your ERD, you will need to move the tables around to view the relationships clearly. Below is a picture of the ERD for the database I created.

Download the complete database project to start your MySQL journey! 

This zip file contains the user guide, troubleshooting tips, and individual SQL files for MySQL Workbench.