PowerPoint Slide 1

 

PowerPoint Slide 2

 

PowerPoint Slide 3

 

PowerPoint Slide 4
Be aware that there is no "logging in" to an SQLite database since it's just a file, so it's better for single websites with a moderate amount of data as opposed to large networks.
PowerPoint Slide 5

 

PowerPoint Slide 6
Link databases (like cd and artist name) with foreign keys.
PowerPoint Slide 7

JOIN gives you all combinations, while NATURAL JOIN actually follows the relationship between tables which is probably what you want

PowerPoint Slide 8

 

PowerPoint Slide 9

 

PowerPoint Slide 10

 

PowerPoint Slide 11

Super useful for when you are working on your pages. You test what your commands are going to do since PHP gives you no feedback

PowerPoint Slide 12

 

PowerPoint Slide 13

 

PowerPoint Slide 14
Have a good break people
This slide in particular is possibly the most helpful slide we have seen in these last few lectures before Spring Break. I am able to know exactly what to look for thanks to this slide - Ty