PostgreSQL for Everybody (PG4E)

Hello and welcome to my site where you can work through these modules and learn develop to use the PostgreSQL database.

Single Table SQL

Multi-Table SQL and Relationships.

Intermediate PostgreSQL techniques.

Handling text in PostgreSQL (but not Natural Language).

Handling Natural Language fields and indexes in PostgreSQL.

Using PostgreSQL with Python. Using PostgreSQL to retrieve and store API data.

Handling JSON in PostgreSQL.

Database architectures, production deplopyment, scalability, and NoSQL.

Using Deno Key-Value to explore NoSQL.