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.
En bref
Ajouté le
18 mars 2026
Matière et domaine
coding · data-databases
Niveaux scolaires
8e année–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.