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 …
Category Archives: sql
MySQL Data Types
Data Types are important in SQL because the database needs to know what type of data is being stored, and how large that data is. Some data takes up more space than others, so part of the benefit is efficiency. Each column in a database has a data type, and the data in that column …
Why Learn SQL
To view all the SQL tutorials & Courses in chronological order, visit the SQL page SQL is one of those things that every programmer should learn at least a little bit. In this article we’re going to talk about why you should learn SQL. What is SQL S.Q.L stands for Structured Query Language, and is …
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 …
Continue reading “How to setup Transactions and Rollbacks in SQL”