Jul 10, 2014
Install sqlite3 on Ubuntu 14.04
The second assignment for Coursera's Introduction to Data Science focuses on databases and relational algebra. The programming assignments are done with sqlite3, so I need to install it on my Ubuntu 14.04 machine.
Apr 21, 2015
Installing MySQL on Ubuntu 14.04
In this post I will cover installing MySQL on Ubuntu 14.04, using the repository available at the mysql apt repo. The idea is to setup a repository that allows our MySQL to be current-- in this case MySQL 5.6. The instructions I'm documenting here are derived from the above link, as well as the nice book Jump Start MySQL (April 2015). If this is of interest to you, follow along and be sure checkout the resources mentioned above.
Apr 22, 2015
Employees database for MySQL, setup and simple queries
In a recent post I covered MySQL setup on Ubuntu 14.04. In this post I will cover downloading and setting up the employees sample database that will be used for the example queries in this, and other posts, on my blog. As mentioned in the previous post, I'm using Jump Start MySQL as a guide book for these posts-- you should check it out for more examples.
Apr 30, 2015
JOINs, and some VIEWs, in MySQL
This is the third in a series of posts on MySQL. The first post covered setting up MySQL and basic queries and the second post covered simple queries using SELECT, LIMIT, ORDER BY, etc. If you are starting out, you should start with these posts. In this post I will go over multi-table queries, using JOINs (with some help from VIEWs).