Skip to main content

SQL

Introduction

General

Syntax

  • Understanding SQL SELECT and WHEREWHERE filters out rows and SELECT filters out columns • Edward Loveall 📖
  • Understanding SQL JOINJOIN combines the columns from two tables into one larger table (to allow returning extra cross-referenced data) • Edward Loveall 📖

PostgreSQL

ORMs

Other Tools

  • sq | wrangle data • Like jq, but for structured data like sql query results • Neil O’Toole 🛠️

Inbox