QuestTree

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.

概览

收录于

2026年3月17日

学科与领域

computer-science-fundamentals · database-systems

年级范围

九年级（高一）–十二年级（高四）

页面类型

Tutorial

简介

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.
访问资源

用户评价

暂无已发布的评价，欢迎率先分享您的使用体验。