Backend and databases
PHP, Laravel, SQL, API design, queues and caching — what decides whether a site survives its second thousand customers.
3
Easy
2
Medium
2
Hard
Tests in this topic
7 tests under “Backend and databases”. Filter by level, or work through them in order.
PHP Basics
- Questions in the test
- 5 questions
- Time limit
- 10 min
PHP 8 basics
Eight questions about what you meet in your first month of PHP: strict_types, == versus ===, array functions, the ?? operator, arrow functions, named arguments, constructor property promotion and enums. For juniors and for anyone coming back to PHP after a break.
- Questions in the test
- 8 questions
- Time limit
- 8 min
SQL: queries and joins
Eight questions on basic SQL: WHERE and ORDER BY, the difference between INNER and LEFT JOIN, GROUP BY with aggregates, HAVING, NULL and DISTINCT. For anyone already writing simple queries who wants to check the fundamentals.
- Questions in the test
- 8 questions
- Time limit
- 8 min
Designing a REST API
Ten questions on how an HTTP API is put together: which status code to return, how 401 differs from 403, what idempotency buys you, how to page through a long list, and why the browser complains about CORS. For anyone who has written backend code and wants to check themselves.
- Questions in the test
- 10 questions
- Time limit
- 10 min