SQL

Relational query language for structured data storage, retrieval, and transformation. Used with PostgreSQL in production projects.

Proficiency: Proficient · 3+ years

Competencies

  • Complex JOINs, window functions, CTEs, subqueries
  • Schema design and normalisation
  • Query optimisation (EXPLAIN, index strategies)
  • Used in Data Science pipelines alongside Pandas

Databases: PostgreSQL (preferred), SQLite for lightweight projects.