SQL and Database Practice
Work with three kinds of database. In PostgreSQL you write SQL from the ground up: data types and table design, constraints and keys, queries, then joins and set operations. In MongoDB you store and read documents through a driver, and in Redis you build on strings and keys, both from your own code in Java, Node.js or Python. On every challenge you choose whether to work with AI agents, AI chat only, or no AI.
Database
3 pathsFrom the blog
2Frequently asked questions
7Which paths are in this category?
3 paths: MongoDB (4 challenges), PostgreSQL (12 challenges) and Redis (4 challenges).
How many challenges are there?
20 challenges across 6 modules.
Do I need to install anything?
No. Every challenge runs in a browser-based IDE with everything already set up, and your code is graded automatically against a test suite.
What should I know before starting?
For PostgreSQL, it helps to know what tables and rows are. For MongoDB and Redis, you should be able to write a small program in Java, Node.js or Python, since you work through a driver. No earlier experience with any of the three databases is needed.
Do the MongoDB and Redis paths use SQL?
No. You talk to them from code in Java, Node.js or Python, whichever you pick. Only the PostgreSQL path is SQL.
What do I build?
Real pieces of an app’s data layer. In PostgreSQL you design tables and join them to answer questions a single table can’t. The first MongoDB module ends with a product catalogue loader that keeps prices, dates and ids precise, and the first Redis module with a session token store.
Can I use AI while I solve a challenge?
Yes, if you want to. Each challenge lets you choose how to work: with AI agents, with AI chat only, or with no AI at all.
