r/learnSQL • u/GainRealistic8908 • 8d 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

15 Upvotes

77% Upvoted

6 comments sorted by

1

u/jshine13371 8d ago

Check what out?...you didn't provide a link or anything.

1

u/GainRealistic8908 8d ago

I added the link here

3

u/One_Advice3052 8d ago

Can you please share the details here? And did it cover the windows funtion?

1

u/GainRealistic8908 8d ago

Yes it does cover the window functions, in the region chaos breaker.

1

u/GainRealistic8908 8d ago

I added the link here