Wix Review

I use to worry about Elementor & Wix type page builders destroying the web design industry. I’m not so concerned anymore, for now… I got a client who wanted some simple help with his website. I checked out his SEO competition and it’s a pretty niche, low competition industry, so I figured we could stay …

SQL Many-to-Many Relationships

In this tutorial we’re going to cover Many-to-Many relationships. At this point you should already understand One-to-Many relationships, and how you can use “Foreign Keys” and “Primary Keys” to connect tables together. If not, go check out the previous tutorial. What if you wanted to create a relationship between Students and Teachers? This could be …

SQL One-to-Many Relationships and JOINS

In this post we’ll cover One-to-Many Relationships along with joining tables together. Table relationships are where things start to come together. In our previous tutorial we had a table with the rows pet_id, pet_name, class, age, family, owner, owner_gender. There’s quite a few problems with having a setup like this. What if a person owns …

SQL SELECT Tutorial

Now that we understand Inserting, updating, and deleting records, and modifying the table structure, we’re ready to start retrieving information, or querying the database. Documentation: Pattern Matching Regular Expressions SELECT Statement In order to learn how to grab information out of the database, we need lots of data to play with, so lets get some …

Basic SQL Queries: Insert, Delete, and Update

In this tutorial we’re going to cover inserting, updating, and deleting rows in our relational databases. At this point, I’m just going to gloss over creating tables and adding/moving/dropping columns because I’ve already covered that in the previous tutorial. Go back and review the previous lessons if you need to. If you don’t already have …

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 …

The Best Local SEO Guide of 2022

Local SEO is optimizing your online presence to get more business in a specific region of the world. An E-Commerce website that sells a product worldwide can benefit from web traffic anywhere in the world. A dentist in Vermont, however, will only benefit from getting website visitors in maybe 30 miles or so of their …