Skip to content

Instantly share code, notes, and snippets.

@vanderhoop

vanderhoop/straight_cruddin.md

Last active January 11, 2016 04:35
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save vanderhoop/ef4c40d28ea93406fb64 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save vanderhoop/ef4c40d28ea93406fb64 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
straight_cruddin.md

Straight CRUDdin' with PSQL

You now know how to create tables and CRUD using PSQL. Now you just need reps writing and executing sql.

Exercise Objective(s)

  • get comfortable executing basic CRUD commands in psql

Part 1: employees

  1. Insert each of the instructors into the employees table.
  2. Insert your best friend into the employees table.
  3. Delete your best friend from the employees table. (They don't work here.)
  4. Target each of the instructors in the employees table, and update their name to a nickname you've given them.

Part 2: animals

  1. Insert an animal represting PJ's dog into the animals table.
  2. Insert at least 3 of your favorite Disney animals or pets into the animals table.
  3. Delete the animal you love the least.
  4. Turn a vegetarian animal into a carnivore, or vice versa.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment