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 …

Multiple GitHub Accounts on One Computer

In this tutorial we’re going to setup multiple GitHub accounts on the same computer with SSH. This is useful if you have a work account and a personal account, or any other time you have multiple GitHub accounts that you’re using on the same machine. Assuming you don’t have ANY ssh keys setup for git, …