SQLZoo
SQLZoo offers an interactive platform for learning SQL through a series of graded assessments. It provides practice problems with easy, medium, and hard difficulty levels to help users build their database query skills.
Overzicht
Toegevoegd op
18 maart 2026
Vak & domein
coding · data-databases
Schooljaar
Groep 8–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.