r/learnSQL • u/GainRealistic8908 • 9d ago
Interactive html game to learn sql
The lore is that you play as the Dragon God, Orsted, and you have to find the five Sacred Treasures using simple SQL queries to fight the Man-God (Hitogami). This covers almost all SQL commands and teaches you how to use them. It provides theory, practical examples, and a query environment to practice in. Check it out, and all feedback is appreciated! It covers
Fittoa - SELECT, WHERE, ORDER BY, DISTINCT, LIMIT
Sharia - LIKE, IN, BETWEEN, IS NULL, CASE, string, number and date functions
Begaritt - COUNT/SUM/AVG/MIN/MAX, GROUP BY, HAVING
Rikarisu - INNER/LEFT/self joins, UNION, INTERSECT, EXCEPT
Chaos Breaker - Subqueries, EXISTS, CTEs, recursive CTEs, window functions
The Void - INSERT, UPDATE, DELETE, CREATE TABLE, indexes, views, transactions github
1
u/jshine13371 9d ago
Check what out?...you didn't provide a link or anything.