TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Show HN: SQL Trainer – Learn SQL by doing live data exercises

303 点作者 _1psu超过 6 年前

20 条评论

knight17超过 6 年前
Some other similar tools I added to my notes from a similar thread: <a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=17905666" rel="nofollow">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=17905666</a><p>Interactive PostgreSQL SQL Tutorial - <a href="https:&#x2F;&#x2F;chartio.com&#x2F;learn&#x2F;sql&#x2F;" rel="nofollow">https:&#x2F;&#x2F;chartio.com&#x2F;learn&#x2F;sql&#x2F;</a><p>Select STAR SQL - <a href="https:&#x2F;&#x2F;selectstarsql.com&#x2F;" rel="nofollow">https:&#x2F;&#x2F;selectstarsql.com&#x2F;</a><p>SQL Bolt - <a href="https:&#x2F;&#x2F;sqlbolt.com&#x2F;" rel="nofollow">https:&#x2F;&#x2F;sqlbolt.com&#x2F;</a> - Learn SQL with simple, interactive exercises<p>SQL Window functions - <a href="https:&#x2F;&#x2F;www.windowfunctions.com&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.windowfunctions.com&#x2F;</a><p>PostgreSQL Exercises - <a href="https:&#x2F;&#x2F;pgexercises.com&#x2F;" rel="nofollow">https:&#x2F;&#x2F;pgexercises.com&#x2F;</a><p>SQL Zoo - <a href="http:&#x2F;&#x2F;sqlzoo.net&#x2F;" rel="nofollow">http:&#x2F;&#x2F;sqlzoo.net&#x2F;</a><p>SQL Teaching - <a href="https:&#x2F;&#x2F;www.sqlteaching.com&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.sqlteaching.com&#x2F;</a>
评论 #18340896 未加载
评论 #18340442 未加载
eumm超过 6 年前
Hi, My name is Eugene and we made this little online SQL language trainer to help non-programmers to learn basic SQL queries. And more important, it shows the result of query entered.<p>Any suggestions and comments are welcome!<p>and many thanks for all the suggestion already made! And seems like we should better remove MySQL specific command from the very first question.
评论 #18339457 未加载
评论 #18340585 未加载
评论 #18340254 未加载
评论 #18341132 未加载
try-perforate超过 6 年前
It would be nice if I could hit continue from the keyboard so that I could do the whole tutorial without using the mouse.
评论 #18338852 未加载
评论 #18338968 未加载
评论 #18343096 未加载
ris超过 6 年前
Something that all of these tools (?) are missing are tutorials around concurrency, allowing multiple sessions to be in progress, interfering with each others operation. TBH this is an under-taught area of databases in general.<p>I have vague ideas about building a browser-based tool that allowed the user to queue up operations to be performed in order in multiple concurrent database sessions, allowing exact locking &amp; blocking behaviour to be experimented with, but have never had time to work on this.
Double_a_92超过 6 年前
This is another one I found a couple of weeks ago: <a href="https:&#x2F;&#x2F;selectstarsql.com&#x2F;" rel="nofollow">https:&#x2F;&#x2F;selectstarsql.com&#x2F;</a>
michaelmior超过 6 年前
This is nice, but it&#x27;s unfortunate that it starts off with commands specific to MySQL.
评论 #18336533 未加载
评论 #18336169 未加载
moolcool超过 6 年前
Pretty nice! It would be cool if this also had some basic joins added as well.
评论 #18340565 未加载
评论 #18337221 未加载
评论 #18336290 未加载
评论 #18339218 未加载
evo_9超过 6 年前
Here is another: <a href="https:&#x2F;&#x2F;sqlbolt.com" rel="nofollow">https:&#x2F;&#x2F;sqlbolt.com</a>
bytematic超过 6 年前
This is great, lots of my classes are using textbooks similar to this. On (13) &quot;Please type SQL query to get 3 largest orders from orders table&quot;, it doesn&#x27;t really tell you what column to order the results by.
mettamage超过 6 年前
I learned everything from: sqlteaching.com<p>It was created in a hackathon and uses sql.js, you can also create your own exercises through sql.js if you know a thing or two about web development ;)
评论 #18339369 未加载
SMV279438超过 6 年前
Just to toot my own horn - I wrote a book called SQL Practice Problems (available on Amazon), plus I also have an expanded problem set on my website SQLPracticeProblem.com.<p>The framework for the problems is that you get the problem statement, the expected results, and then you figure out how to write the SQL to get the results. I have lots of hints if you get stuck, but there&#x27;s also a hint-free version, which some people prefer.<p>It really helps for people who like a &quot;learn-by-doing&quot; approach.
tomca32超过 6 年前
I like this, but as mentioned, it&#x27;s a shame that it starts of with a MySQL specific command, SHOW tables
评论 #18339223 未加载
pier25超过 6 年前
This is great. I&#x27;m mostly a front end dev and my SQL is rather poor...
评论 #18338691 未加载
评论 #18340717 未加载
konsumer超过 6 年前
Nice! I like the tutorial format. I made this along similar lines: <a href="http:&#x2F;&#x2F;konsumer.js.org&#x2F;learnsql&#x2F;" rel="nofollow">http:&#x2F;&#x2F;konsumer.js.org&#x2F;learnsql&#x2F;</a>
zachguo超过 6 年前
Looks cool. But in my experience, theoretical understanding and some simple proofs are quite important in mastering SQL. I would suggest the intro to DB online course offered by Stanford.
评论 #18344277 未加载
jhspetersson超过 6 年前
I like this one very much: <a href="http:&#x2F;&#x2F;sql-ex.ru&#x2F;" rel="nofollow">http:&#x2F;&#x2F;sql-ex.ru&#x2F;</a> Major part of questions is based on MS SQL Server though.
paulddraper超过 6 年前
&gt; In some popular databases like MySQL and others you may get the list of available tables just by typing: SHOW TABLES;<p>Is there <i>any</i> database other than MySQL that does that?
cneumuel超过 6 年前
For Oracle, there is <a href="https:&#x2F;&#x2F;livesql.oracle.com" rel="nofollow">https:&#x2F;&#x2F;livesql.oracle.com</a>
trevz超过 6 年前
Would be cool if you didn&#x27;t have to use your mouse so much. Kept having to click the next box to select it.
eumm超过 6 年前
discussion on Product Hunt: <a href="https:&#x2F;&#x2F;www.producthunt.com&#x2F;posts&#x2F;bytescout-sql-trainer" rel="nofollow">https:&#x2F;&#x2F;www.producthunt.com&#x2F;posts&#x2F;bytescout-sql-trainer</a>