SQL PRACTICE

Build stronger SQL instincts.

Work through focused SQL exercises from approachable foundations to more demanding problem-solving patterns.

All exercise languages

2SQL exercises

Includedtest feedback

Freelearning access

SQL EXERCISES

Choose your level

Each level includes test feedback and a solution.sql reference tab.

beginner

Beginner · build the foundation

Start with one core idea at a time and make the basic moves feel automatic.

1 exercise

SQLbeginner

Build a filtered workshop availability report

A learning platform needs an accurate report of published workshops that students can still book. Complete the final SELECT so the report returns each workshop ID, title, level, and calculated remaining_seats. Exclude drafts and full workshops, then sort the smallest availability first and use the title to make ties deterministic.

advanced

Advanced · handle real-world constraints

Work with edge cases, maintainability, and the tradeoffs found in production code.

1 exercise

SQLadvanced

Build a complete department enrollment summary

Create an operations report that keeps every department—even departments with no courses—while counting its published courses and active enrollments. The joins must not inflate the course count, unpublished courses and cancelled enrollments must not contribute, and the final rows must be ordered by active demand.

NEED THE CONCEPTS FIRST?

Review the SQL course.

Return to the free lessons, editable examples, and quick checks whenever an exercise exposes a gap.

Open SQL course