SQLZoo
SQLZoo is an online platform offering interactive SQL exercises to help learners practice and improve their database query skills. It features assessments with varying difficulty levels (easy, medium, hard) to challenge users.
Overzicht
Toegevoegd op
17 maart 2026
Vak & domein
computer-science-fundamentals · database-systems
Schooljaar
Klas 1 (brugklas)–Klas 4
Paginatype
Tutorial
Inleiding
SQLZoo Tutorial Overview
- Core SQL Tutorials: A step-by-step curriculum covering fundamental to advanced SQL concepts, including:
- Basic SELECT statements and pattern matching.
- Aggregate functions (SUM, COUNT).
- JOIN operations (inner, outer, and self-joins).
- Subqueries, Window functions, and handling NULL values.
- Data Definition Language (DDL) and database creation.
- Reference Material: Comprehensive guides on database management, including:
- CRUD operations (CREATE, DROP, INSERT, DELETE).
- Date/Time manipulation and built-in SQL functions.
- User access control (GRANT/DENY) and metadata management.
- SQL Hacks and integration with PHP, C#, and Perl.
- Practical Assessments: Real-world scenarios for advanced practice, including:
- Help Desk management, Hotel booking systems, University timetables, and Wholesaler databases (Adventure Works).
- Each assessment contains 15 questions categorized by difficulty (easy, medium, hard).
- Implementation Resources:
- Links to official user manuals for major SQL engines (MySQL, Oracle, SQL Server, PostgreSQL, SQLite, DB2, etc.).
- Guides on connecting to various database servers and interpreting error messages.
- Introduction to NoSQL (MongoDB) and transaction management.
Community-recensies
Nog geen gepubliceerde recensies. Deel als eerste uw ervaring.