MySQL Part 2: Create Database

-



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.


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 the message "Query OK" if you complete the steps correctly.  Congratulations, if you made it this far, you have successfully set up a database in MySQL.

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




Popular posts from this blog

MySQL Part 1: Getting MySQL Set Up in goormIDE

-
Image
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...
Read more

Do Popular Market Index Returns Follow a Normal Distribution?

-
Image
Introduction Many statistical tests assume normality within the data set.  In other words, before you perform any type of parametric test, one should first view the data sets and run experiments to test this assumption.  This article will show you how to pull several market indices’ historical returns and see if they follow a normal distribution using the Shapiro-Wilk test. The main reason this article is testing the normal distribution validity of portfolio returns is to set up Monte Carlo simulations to project future retirement balances and their respective probabilities in Tableau.   To view the interactive application and estimate your own retirement savings, click here .   Sources:  Normality Test in R Analyzing Performance with tidyquant Market Index Background We were able to pull the following historical index information using a convenient package in R called tidyquant .  We will test the normality of the various benchmarks listed below...
Read more