6 common SQL operations used by data analysts: 1. SELECT statements 2. JOINs 3. GROUP BY clause 4. Aggregate functions 5. CASE WHEN statements 6. Common Table Expressions (CTEs)