Schema Design in SQL: interview exercises

Schema Design in SQL: 4 test-checked interview exercises (CREATE TABLE with constraints, A unique index), each beside a worked example, with tests as you go. Free.

1. CREATE TABLE with constraints
2. A unique index
3. Save a query as a view
4. Add a column, then fill it

Each exercise pairs a worked example with a twin problem to solve in a real editor; the tests run the moment you do. Progress is saved in your browser, and in your account if you sign in.

More SQL topics

• Select & Filter
• Aggregation
• Joins
• Subqueries & CTEs
• Window Functions
• Strings, Dates & CASE
• Modifying Data

All SQL exercises · Other languages and frameworks