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.
En bref
Ajouté le
17 mars 2026
Matière et domaine
computer-science-fundamentals · database-systems
Niveaux scolaires
9e année (3e)–12e année (Terminale)
Type de page
Tutorial
Introduction
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.
Avis de la communauté
Pas encore d’avis publiés. Soyez le premier à partager votre expérience.