Data Exploration

Introduction In this article, we will walk through how to create three (3) MySQL tables.  For more information about setting up MySQL through the goormIDE, please check out Part 1 of this series. MySQL Part 1: goormIDE Create Tables and Insert Data In Part 2 of this series, we created a database.  For more information about this article, click the link below. MySQL Part 2: Create Database In Part 3, we will create three (3) bike shop tables.  Each of these tables will have its own primary key and its own individual setup. If you started a new MySQL session, please type the following into the Terminal and press <Enter>. mysql - ctl cli Please ensure that the bike_shop.sql file is selected and available.  If not, double-click it on the left-hand side.  This is where we are going to type most of our code.  If there is information saved in there, go ahead and clear out that information.   Bikes Table Before we create the table, we hav...

Introduction In this article, we will walk through how to create a MySQL database.  For more information about setting up MySQL through the goormIDE, please check out Part 1 of this series. MySQL Part 1: goormIDE Create Database A database is a place where we can store multiple tables that will ultimately house our data.  If you started a new MySQL session, please type the following into the Terminal and press <Enter>. mysql - ctl cli Please ensure that the bike_shop.sql file is selected and available.  If not, double-click it on the left-hand side.  This is where we are going to create our database. Type the following code into the console.  Press Ctrl+S to save the code. DROP DATABASE IF EXISTS bike_shop_app; CREATE DATABASE bike_shop_app; USE bike_shop_app; To run the code, go down to the Terminal and type the following code that will run the bike_shop.sql file and press <Enter>. SOURCE bike_shop. sql ; You will get t...

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...