A Summer of Learning: mySQL

2017-06-22_14-35-21

As many have pointed out, data scientists need raw data to be stored so that it can be accessed. In my last two blogs, I talked about what I’ve been learning in my short Tableau summer courses to visualize data. Today I want to switch gears and talk about what I learned in the mySQL class, including the basics of structured query language used for searching databases.

In the above entity-relationship model, I needed to create a table for each entity (the item in each of the three peach-colored boxes) and a table for each of the relationships (the items in the gray triangles). Then I inserted values into each row of the table. And then based on the type of problem I was trying to answer, I needed to perform a search to find that data from the database.

Here’s a generic example of the mySQL syntax used for creating a table.

2017-06-22_14-36-25

So my syntax for the Library model above would be:

2017-06-22_14-37-39

Since this blog is mainly for a non-technical audience, I will skip the rest of the syntax for putting values in the tables and for querying the tables. If you’re interested and want to start playing around with the mySQL syntax, here’s a great cheat sheet.

Next week, I’ll talk about what I learned in my short R summer course.

Advertisements

One thought on “A Summer of Learning: mySQL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s