Setting up a MySQL environment

In order to learn SQL, we need to choose a database. The most common choices are MySQL and Postgres. In this series we’ll use MySQL. In this post we’ll show you several different ways to setup a complete MySQL development environment. MySQL for Windows, Mac and Linux using XAMPP XAMPP is a great tool because …

How to setup Transactions and Rollbacks in SQL

In this post we’re going to cover an important and simple SQL operation called transactions and rollbacks. These SQL queries allow you to only perform an operation if the entire series of insertions/edits is successful. So if you’re inserting 50 new users and user #24 has an error, the entire operation will rollback so no …