Resources for further learning
For more in depth information about PostgresSql and SQL, the following resources could help.
- Datatypes in PostgreSQL
- Crow’s foot notation for ERD
- Table Creation
- Constraints & Integrity
- Selecting data in PostgreSQL
- Altering tables in PostgreSQL
- Deleting a database in PostgreSQL
- Triggers in PostgreSQL
- Dropping a table in PostgreSQL
- Database access in PostgreSQL
- Access Control in PostgreSQL
- Database roles
- Monitoring activity
- ERD with Mermaid