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

  • Select an option

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

Select an option

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

Revisions

  1. vanderhoop revised this gist Feb 2, 2015. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion creating_and_reading_in_psql.md
    View file
    Original file line number Diff line number Diff line change
    @@ -10,5 +10,5 @@ You just learned how to insert (create) records into a table, and how to select
    1. Insert a student into the `students` table.
    - Type the command from scratch (no copy and pasting).
    2. Validate that the student appeared by selecting (reading) the records in the students table.
    - Again, type the command from scratch.
    - As before, type the command from scratch.
    3. Repeat steps 1 & 2 until you have 6 students in the students table.
  2. vanderhoop created this gist Feb 2, 2015.
    14 changes: 14 additions & 0 deletions creating_and_reading_in_psql.md
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,14 @@
    ## 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).
    2. Validate that the student appeared by selecting (reading) the records in the students table.
    - Again, type the command from scratch.
    3. Repeat steps 1 & 2 until you have 6 students in the students table.