Joining Tables in SQL: Inner, Right, Left, & Outer

Preparation Code Part 1 (for examining): The below code will create an INCORRECT setup. Go ahead and run the code below, and take a look at how there are multiple “John” and “Judy” records. Are they the same people? Hard to say. Preparation Part 2 (for the rest of the tutorial): Right & Left Join […]

Duplicating a Table in SQL

Preparing for Tutorial Create the myapp database and Users Table Insert the Users into the Table Duplicating a table & Inserting data:

SQL Insert Into Table

In this post we’re going to learn how to insert records or rows into an sql table. Preparing for Tutorial: