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