jwworth/sql-workshop

Material for our SQL workshop at Code Platoon

SQL Workshop

This is material for Jack and Jake's SQL workshop at Code Platoon.

To see how the day will progress, check out the Agenda.

Setup

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.

Additional Resources

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.

License

This project is released under the MIT License.

Sponsors

We are grateful to the following sponsors, who continue to support this partnership:

• CCSalesPro
• Dr. Treat
• Framebridge
• Hashrocket