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.
概览
收录于
2026年3月18日
学科与领域
coding · data-databases
年级范围
八年级–十二年级（高四）
页面类型
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.
用户评价
暂无已发布的评价，欢迎率先分享您的使用体验。