SQLZoo

What SQLZoo is

SQLZoo is a web-based resource for learning and practicing SQL, with tutorials, reference pages, exercises and assessments. Learners can query sample databases using interactive access to several SQL engines and get immediate feedback on their attempts. The tutorial material ranges from SELECT and pattern matching to aggregates, joins, NULL, window functions, self joins, quizzes and database creation. Reference pages cover SELECT, table creation and deletion, data changes, dates, functions, users and metadata.

The sample databases include Buses, Covid, EURO2012, General Election, Movies, Nobel, Teachers and World, with data in MySQL format. SQLZoo identifies MySQL, Oracle and SQL Server among the engines available for interactive learning; its supported-language list also names DB2, Mimer, PostgreSQL, SQLite and Access. Each assessment has 15 questions across easy, medium and hard levels. The material was first developed for Edinburgh Napier University. The maintainer describes it as useful for large classes with face-to-face instructor support and invites educators to report class issues. SQLZoo’s privacy policy says cookies and local storage retain interactions and user history, which is reviewed to improve content; anonymized usage patterns may be used for research. The maintainer describes the sample engines as relatively safe and recommends installing an engine locally to experiment with the real thing.

Who it suits

SQLZoo suits learners who want to practice SQL in a browser through exercises, sample databases and immediate feedback. Its materials may also suit educators leading large classes with face-to-face support.

Limits

SQLZoo describes its sample engines as relatively safe and recommends installing an SQL engine locally to experiment with the real thing.

Getting started

1. Open https://sqlzoo.net/.
2. Use the web-based tutorials and reference pages.
3. Choose an interactive exercise and work with a sample database.
4. Try an assessment with easy, medium and hard questions.
5. For experimentation with a real engine, install an SQL engine locally.

Verdict

Choose SQLZoo for free, browser-based SQL practice supported by tutorials, reference pages and sample databases. Learners seeking to experiment with a real SQL engine should follow the maintainer’s recommendation to install one locally.