This is material for Hashrocket's SQL workshop at Code Platoon.
At Hashrocket, we 💙 SQL! This engagement has given us many opportunities to share that passion, in a practical and hands-on way, with the veterans and spouses of Code Platoon.
Check out the Agenda to see how the day will progress.
Clone the repo:
$ 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 (13.4)
Type "help" for help.
deleteme=# exit
$ dropdb deleteme
We'll start with the Phone Book domain.
$ cd sql-workshop/phone_book
Open up the 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.
From us, 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.
This workshop is supported by the team at Hashrocket, a multidisciplinary design and development consultancy. If you'd like to work with us or join our team, don't hesitate to get in touch.
This workshop is also supported by CCSalesPro, a provider of training and technology for the merchant services industry.