SQL de zéro à Pro :

• Les bases: SELECT, FROM, WHERE, LIMIT, ORDER BY

• Les agrégations :SUM, AVG, COUNT, GROUP BY, HAVING)

• JOINs et CTEs: LEFT, RIGHT, INNER, CROSS, FULL OUTER (et self joins)

• Subqueries et Common Table Expressions (WITH)

• CASE WHEN

• Window Functions (OVER, PARTITION BY, ORDER BY, ROWS BETWEEN)