Skip to content

Instantly share code, notes, and snippets.

View MillsProvosty's full-sized avatar
⚜️

M.P. MillsProvosty

⚜️
  • Lockheed Martin, Space
  • Denver, Co
View GitHub Profile

Intermediate SQL Workshop

  • Run psql
  • You may need to run CREATE DATABASE intermediate_sql;
  • To exit this shell, you can run CTRL d

Create tables

Let's create some tables in the database.

Iteration 1

Use TDD to create an Employee class that responds to the following interaction pattern:

pry(main)> require './lib/employee'
# => true

pry(main)> bobbi = Employee.new({name: "Bobbi Jaeger", age: "30", salary: "100000"})
# => #<Employee:0x00007fdfd48af848...>