/sql-intro

Stuff you should know

  • How to create a database
    • createdb albums-browser (this is a bash command)
  • How to connect to a database:
    • from the command line:
      • psql albums-browser
    • from postico (if you've never connected):
      • Add a new favorite
      • Enter the name of your database
      • Leave the other fields blank
      • Click "Done"
      • Click "Connect"
  • How to create tables
    • create table
  • How to insert information into tables
    • INSERT
  • How to retrieve information from tables
    • SELECT
      • ...specific column names
      • WHERE
      • LIMIT
      • ORDERBY