I understand basic SQL and have completed some simple courses on Codecademy, but the implementation of SQL databases has so far confused me. To address this, I intend to become much more familiar with one of the main flavours of SQL - PostgreSQL. I'll also cover SQL commands in more detail.
| Topic(s) | Addressed |
|---|---|
| Basic SQL commands | Yes |
SQL vs pandas |
Yes |
| Installing PostgreSQL | Yes |
Basic configuration with psql and postgres |
Yes |
Managing databases with psql (creation, deletion, manipulation, data extraction etc.) |
Yes |
| Querying data | Yes |
| Filtering data | Yes |
| Joining multiple tables | Yes |
| Grouping data | Yes |
| Subqueries | Yes |
| Modifying data | Yes |
| PostgreSQL import and export | Yes |
| PostgreSQL data types | |
| Constraints in PostgreSQL | |
Interacting with PostgreSQL through psycopg2 |
Yes |
| Interacting with a local PostgreSQL server | Yes |
| Setting up and maintaining a PostgreSQL instance in the cloud | |
| Querying a cloud-based PostgreSQL server |
Resources: