This is material for Jack and Jake's SQL workshop at Code Platoon.
To see how the day will progress, check out the Agenda.
Clone the repo (no need to fork):
$ git clone https://github.com/jwworth/sql-workshop
Install PostgreSQL. This is really important; please try to have a working PostgreSQL REPL ready before we begin!
One way to verify a working Postgres installation would be to create and connect to a Postgres database.
$ createdb deleteme
$ psql deleteme
psql (15.3)
Type "help" for help.
deleteme=# exit
$ dropdb deleteme
We'll start with the Phone Book domain.
$ cd sql-workshop/phone_book
Open up lesson.sql in your text editor.
You can't beat the official PostgreSQL docs; they are about as good as documentation gets. This conventions page will help you read them.
We're proud to have contributed PG Casts. This series of videos covers in greater detail many of the commands we'll teach today.
This project is released under the MIT License.
We are grateful to the following sponsors, who continue to support this partnership: