Skip to content

Instantly share code, notes, and snippets.

@vanderhoop

vanderhoop/creating_and_reading_in_psql.md

Created February 2, 2015 15:02
Show Gist options
  • Save vanderhoop/d6160ae39091523abd23 to your computer and use it in GitHub Desktop.
Save vanderhoop/d6160ae39091523abd23 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
creating_and_reading_in_psql.md

CREATING and READING in PSQL

You just learned how to insert (create) records into a table, and how to select (read) records using structured query language. Because these skills are so fundamental, you have been tasked with adding

Exercise Objective

  • build muscle memory for creating and reading records in SQL

Directions

  1. Insert a student into the students table.
  • Type the command from scratch (no copy and pasting).
  1. Validate that the student appeared by selecting (reading) the records in the students table.
  • As before, type the command from scratch.
  1. Repeat steps 1 & 2 until you have 6 students in the students table.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment