SQL Joins

Part 1

Finish Regifter, if you haven't

Part 2

Choose Your Own Learning

Rate your comfort and choose the matching activity

Rating What it means What you should work on
5 I feel amazing! Give me more challenges! Football/Futball/Soccer Data Download and join the many tables to create info on historical data, like which players are on what teams? Who scored what goal in what game?
4 Feeling good Go back to the bonus challenges in the lecture markdowns and solve each one
3 Hanging in there Work your way through SQL Zoo
2 I'm feeling stressed Work your way through SQL Bolt
1 What just happened? Take a break and then schedule a time to talk to your instructor

In Canvas, answer the following questions:

  • Which resource did you choose to use? I made two tables to practice on football players and football teams. (American's call it soccer)

Commands to start

  1. npm run db:init
  2. npm run db:seed
  • What are three things you learned during this lab?

How to insert a CSV file into a SQL table