SQL Many-to-Many Relationships

To view all the SQL tutorials in chronological order, visit the SQL page 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 … Read more

SQL One-to-Many Relationships and JOINS

To view all the SQL tutorials in chronological order, visit the SQL page 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 … Read more

SQL SELECT Tutorial

To view all the SQL tutorials in chronological order, visit the SQL page 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 … Read more

Basic SQL Queries: Insert, Delete, and Update

To view all the SQL tutorials in chronological order, visit the SQL page 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 … Read more

Setting up a MySQL environment

To view all the SQL tutorials in chronological order, visit the SQL page 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 … Read more

MySQL Data Types

To view all the SQL tutorials in chronological order, visit the SQL page 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 … Read more

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 … Read more

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 … Read more