MySQL Part 1: Getting MySQL Set Up in goormIDE

Introduction

In this article, we will walk through how to set up the goormIDE so that you can utilize it in the examples presented later on my blog.  You can always download a local version of MySQL on your desktop and follow along as well.

As a disclaimer, the data in these examples were provided by Business Science University's DSB4 101-R: Business Analysis with R course.  If you want additional MySQL training, please check out The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert on Udemy. Both links are provided below.

https://www.business-science.io/
https://www.udemy.com/course/the-ultimate-mysql-bootcamp-go-from-sql-beginner-to-expert/

A Few Notes Before We Start

The subsequent articles assume that you have a working version of MySQL already downloaded and installed.  However, this article provides links to help you get started in the goorm cloud IDE.  The benefit of using goorm is that it is cloud-based and does not require you to download MySQL onto your PC.  The Signup Instructions for Goorm.io are included in the link below.

https://gist.github.com/nax3t/2773378c4d1bada8d66d12f4d5210248

After you set up an account, log in to the goormIDE and press Run.

Getting Set Up in GOORM

To get MySQL up and running, type the following into the terminal and press <Enter>.

mysql-ctl cli

After doing so, you should get a message similar to the one listed below.

We will create a new file that we will utilize when developing our code.  Up at the top of the page, click File > New > New File and name the file bike_shop.sql.

You should see the new file on the left-hand side, and it should also prompt that file in the workspace area.  You will also have fewer folders than presented below.

Congratulations

If you made it this far, you are now all set to continue your journey to learning MySQL.  We will create a database and set up our three (3) tables in the following article.

MySQL Part 2: Create Database

For a complete list of the entire set of MySQL-related articles, please see the links below.

MySQL Part 1: goormIDE
MySQL Part 2: Create Database
MySQL Part 3: Create Tables
MySQL Part 4: String Functions
MySQL Part 5: Refining Select Statements
MySQL Part 6: Aggregations
MySQL Part 7: Dates
MySQL Part 8: Logical Operations
MySQL Part 9: Joins