Currently the first rank is 11 cases, and the second rank is 20 additional cases.
The second rank covers WHERE with numbers, strings, dates and timestamps, IN, BETWEEN, AND and OR.
Check out the guide tab in the game - it covers everything supported so far.
Once you finish that, you go into practice mode where you're randomly asked the same kind of cases like the previous ones.
I plan on adding support for GROUP BY, aggregate functions, HAVING, aliases, JOINING multiple tables, and some more stuff with more complex cases to match.
And the 6 months countdown doesn't begin until the game development ends so you're enjoying longer access.
I think it would be more compelling to see how much more material there is, or at least how much is planned, like a timeline or map. I'm a little hesitant to purchase it blind.
Worth considering capturing the keyboard input. I instinctively hit "delete" partway through to delete something I had clicked on and it took me back to HN and I lost my progress.
do you ever actually use backspace to go back a page? If not, turn it off in your browser settings, since you'll only ever use it accidentally anyway. (And what's more, you'll only ever use it accidentally while you're trying to edit text you've input.)
to me backspace going back a page = a sense of frustration. better to turn it off in the browser, so I did so.
Are the names and email addresses in the sample data real? They seem auto generated but the domains are real providers like Hotmail, Gmail, and Outlook.
Everything is randomised, nothing is based real data. It's auto generated from popular first names, last names, changing patterns and random years or numbers attached at the end. Domains are real, but randomised as well.
It's kinda risky in my opinion. I just checked a few of the addresses (mostly the one's without any numbers at the end), some of them do actually belong to real people.
I was aiming for a feeling of dealing with real data (even though it's not). Changing the email domain names to fictitious ones will solve this, but I think would undermine the feeling of real-ness.
I was wondering the same thing. As combos of common names and providers, it seems extremely likely that many of those email addresses are valid addresses belonging to real people.
>"A mailing list of an illegal online service was sent to the SQLPD hot-line. Please submit all records email addresses' details. Please make sure there are no duplicates."
records is possessive and should have the apostrophe, addresses is not possessive and should not. This class of typo is pretty common throughout the briefs I have looked at.
I had one before that, asking about all member data from a darknet list. It seemed logical that select * from members would be the answer based, but I couldn't get it to accept no matter how many times I tried. Kept saying failed to fetch after run. I closed and reopened the browser, tried again, and it worked on the first attempt.
Nice concept but I really hate clicking on the buttons to form my statements... Is it possible to allow typing? Also, not ending my statement with a semicolon feels incomplete.
I agree. I work in Microsoft's SQL Server (incl. variations, e.g. Azure SQL DW) quite a bit. Based on my experience, I am the only person using semicolons in T-SQL.
Yeah, the semicolon bothers me too. I'll see how I can incorporate that in.
The clicking around was meant to make life easier on mobile phone users. I'll see if I can add a keyboard support without undermining this.
This makes a lot of sense, actually. Definitely great for learning.
You could do it the way Duolingo does it - on desktop, it allows for "Hard Mode", where it lets you type the responses freely. On mobile however, it doesn't let you do that (unless you're using the app).
Currently the first rank is 11 cases, and the second rank is 20 additional cases. The second rank covers WHERE with numbers, strings, dates and timestamps, IN, BETWEEN, AND and OR. Check out the guide tab in the game - it covers everything supported so far. Once you finish that, you go into practice mode where you're randomly asked the same kind of cases like the previous ones.
I plan on adding support for GROUP BY, aggregate functions, HAVING, aliases, JOINING multiple tables, and some more stuff with more complex cases to match.
And the 6 months countdown doesn't begin until the game development ends so you're enjoying longer access.
Isn't local storage pretty good for compliance? It doesn't automatically send the data to your server like a cookie would, so as long as you don't send it, you haven't collected it.
As long as you do not transmit the data ever, using localStorage isn't a GDPR concern other than that you should mention it (and the in-browser-only use, with data never leaving the users' systems) on your privacy policy page for the sake of transparency and to avoid users asking about it.
This looks great! It was difficult to find out that you had to click the Play button for me "▷". Since this is a primary action you might want to consider adding a stronger Call to Action there?
This seems like a neat idea. Not sure about paid, though, in its current incarnation. There's a ton of similar things unpaid. Why would I pay for this over Khan Academy's excellent SQL course, for example?
It seems like a piece of a business, not a business in itself. To be successful as a product or solution, there needs to be more around it -- some way to integrate it into contexts, have it used in schools, or in afterschool, or something.
Another key component would be user studies -- develop PCK about what supports and help students need.
Cool concept but the license seems kind of weird to me. 20 bucks for six months? Will anything change in that time? You might want to add a bit of info on what the license gets you.
Thanks!
The game is still in development.
It covers SELECT, DISTINCT, FROM (with one table), ORDER BY, LIMIT in the free part.
After buying a license, WHERE, IN, BETWEEN, AND and OR are also covered.
Check out the guide tab in the game - it covers everything supported so far.
I plan on adding support for GROUP BY, aggregate functions, HAVING, aliases, JOINING multiple tables, and some more stuff with more complex cases to match.
The 6 months countdown doesn't begin until the game development ends so you're enjoying longer access.
Cool game, but I think pricing maybe a value issue. Might make more $$ if you just had a donation button, and some ads and maybe an option to upgrade to remove ads/donation nags. Plus you'd get a lot more word of mouth, and maybe add some social sharing of 'accomplishments' etc...
The cases are randomly generated; It asks for unique values of a random column in a random table. Sometimes it asks for unique password hashes... It's an edge case I didn't account for.
For replay-ability.
Each time you need to understand the problem and construct a query instead of remembering that the answer was X (when I prototyped this in some of the cases you needed to pick the right answer from a cell in the table, not submit the whole thing).
I've used sqlbolt.com! It's great. Very easy to follow and it's interactive. They have a resource for regex: https://regexone.com/, which I've gone through as well!
Pretty cool! One piece of feedback:
> An illegal site's servers were siezed in a recent operation. Please submit all users number of posts' details. Please make sure there are no duplicates.
There's no declaration of what attribute should be used for considering distinct users. After guessing it gave a hint to the effect of "there are duplicate Given Name values". This is rather counter intuitive since many people share a given name.
The first two are cases of selecting the whole table.
Since it's (completely) randomised, there is a chance of getting the same table twice. I didn't account for that :-P
If you solve it again, you'll get a new case following that.
90 comments
[ 3.0 ms ] story [ 150 ms ] threadI plan on adding support for GROUP BY, aggregate functions, HAVING, aliases, JOINING multiple tables, and some more stuff with more complex cases to match.
And the 6 months countdown doesn't begin until the game development ends so you're enjoying longer access.
to me backspace going back a page = a sense of frustration. better to turn it off in the browser, so I did so.
Also, in a rather grim coincidence, one of the emails I googled belonged to a person who had died in a car crash few years ago.
typo
click SELECT
click *
click FROM
click mailing_list
click run
"Although the semicolon isn't required for most statements in this version of SQL Server, it will be required in a future version."
You could do it the way Duolingo does it - on desktop, it allows for "Hard Mode", where it lets you type the responses freely. On mobile however, it doesn't let you do that (unless you're using the app).
And the 6 months countdown doesn't begin until the game development ends so you're enjoying longer access.
It seems like a piece of a business, not a business in itself. To be successful as a product or solution, there needs to be more around it -- some way to integrate it into contexts, have it used in schools, or in afterschool, or something.
Another key component would be user studies -- develop PCK about what supports and help students need.
The 6 months countdown doesn't begin until the game development ends so you're enjoying longer access.
Interactive SQL Tutorials :
▪ Chartio Interactive PostgreSQL SQL Tutorial - https://chartio.com/learn/sql/
▪ Select STAR SQL - https://selectstarsql.com/
▪ SQL Bolt - Learn SQL with simple, interactive exercises - https://sqlbolt.com/
▪ SQL Window functions - https://www.windowfunctions.com/
▪ PostgreSQL Exercises - https://pgexercises.com/
▪ SQL Zoo - http://sqlzoo.net/
▪ SQL Teaching - https://www.sqlteaching.com/
▪ ByteScout SQL Trainer - Use live data to train - https://app.bytescout.com/sql-trainer/index.html
▪ Schemaverse - A space-based strategy game implemented entirely within a PostgreSQL database - https://schemaverse.com/
▪ Oracle Live SQL - Lerarn and share SQL - https://livesql.oracle.com/
▪ GalaXQL 3.0 - an intractive tutorial with exploring the galaxy - http://sol.gfxile.net/g3/
▪ SQL Exercises - http://sql-ex.ru/index.php
There's no declaration of what attribute should be used for considering distinct users. After guessing it gave a hint to the effect of "there are duplicate Given Name values". This is rather counter intuitive since many people share a given name.