InternshipKey terms and common mistakes
The words you will hear in PostgreSQL work and the mistakes that most often cost interns approvals.
Key terms
| Term | Meaning |
|---|---|
| PostgreSQL | Open-source relational database |
| PRIMARY KEY | Unique row identifier |
| SELECT | Reads data |
| Foreign key | Column referencing another table |
| COUNT | Counts rows |
| B-tree | Default index type |
| Transaction | All-or-nothing group of statements |
| JSONB | Binary JSON column type |
Common mistakes to avoid
- Queries without indexes on large tables.
- Building SQL strings from user input (SQL injection).
- No backups or never testing a restore.
- Using one superuser account for everything.
Want to go deeper? The free PostgreSQL learning path has short modules, games and a certificate for each module.