liyupi/sql-mother
Sql Mother
sql-mother هي منصة تعليمية قائمة على المتصفح لتعلم بناء جملة SQL من خلال تمارين تفاعلية، ودروس، وملعب استعلامات. توفر بيئة منظمة لإتقان منطق وبناء جملة MySQL و SQLite و PostgreSQL باستخدام سلسلة من التحديات العملية.
تستخدم المنصة محرك قاعدة بيانات قائماً على WebAssembly لتمكين تنفيذ SQL المحلي والتحقق من الاستعلام في الوقت الفعلي بالكامل داخل المتصفح. تسمح هذه البنية بمحاكاة الجداول الافتراضية وإدارة الحالة دون الحاجة إلى خادم واجهة خلفية أو حسابات مستخدمين.
تتضمن البيئة منهجاً تعليمياً ممتعاً من الدروس الموجهة، وصندوق رمل حر الممارسة الاستعلامات التعسفية، وأدوات للمعلمين لإنشاء تمارين مخصصة ومستويات صعوبة.
Features
- Interactive Learning Environments - Offers a gamified platform with interactive lessons for mastering SQL query syntax.
- SQL Tutorials - A structured curriculum for mastering MySQL, SQLite, and PostgreSQL queries through a sequence of hands-on challenges.
- In-Browser Database Engines - Uses a WebAssembly-based database engine to enable high-performance SQL execution in the browser.
- SQL Query Execution - Executing and testing SQL statements in a browser-based sandbox to understand how different queries affect data results.
- SQL Query Execution Engines - Provides a built-in SQL engine for executing queries against datasets to verify accuracy.
- Background SQL Executions - Implements a database engine that runs SQL queries entirely within the browser via WebAssembly.
- Client-Side Querying - Provides a browser-based environment for writing and executing SQL queries using an in-memory database.
- Progressive Lesson Series - Delivers guided interactive lessons and exercises focused on the logic of data retrieval.
- Interactive Learning Platforms - Acts as a gamified educational platform for learning SQL via interactive exercises and a sandbox.
- Self-Paced Learning Environments - Provides a step-by-step, interactive curriculum for database education without requiring local installation.
- Syntax Exercises - Provides hands-on coding exercises to teach the syntax and logic of MySQL, SQLite, and PostgreSQL.
- Gamified Learning - Features a sequence of gamified levels that teach SQL syntax through progressive problem-solving.
- Interactive Learning Sandboxes - Implements a virtual environment with sample datasets and a real-time editor for practicing database operations.
- Query Execution Accuracy Validators - Validates query correctness by comparing execution results against expected result sets.
- Exercise Authoring Tools - Includes tools for educators to design and implement custom SQL challenges and difficulty levels.
- Lesson Mapping Schemas - Uses structured data files to define learning paths and map queries to expected results.
- Dataset Mocking - Simulates relational database tables by loading static dataset snapshots into the in-memory engine.
- SQL Development Environments - Provides a free-form sandbox environment for executing arbitrary SQL queries without constraints.
- SQL和数据库相关 - Listed in the “SQL和数据库相关” section of the DotNetGuide awesome list.
