MySQL SQL 练习/查询与示例数据库
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/24775895/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
SQL exercises/queries with sample database
提问by Sambhav Pandey
I am looking for some sample SQL exercises/query (preferred MySQL, or SQLServer)to practice. It would be great if it is with some sample database.
我正在寻找一些示例 SQL 练习/查询（首选 MySQL 或 SQLServer）来练习。如果有一些示例数据库，那就太好了。
Could someone please point to sql exercises for Sakila Database( MySQL Sample Database) or exercises with some other sample database.
有人可以指出 Sakila 数据库（MySQL 示例数据库）的 sql 练习或其他一些示例数据库的练习。
I have already came across http://courses.cs.tau.ac.il/0368-3458/databases201213a/assignments/hw1.pdf
我已经遇到过 http://courses.cs.tau.ac.il/0368-3458/databases201213a/assignments/hw1.pdf
and looking for more.
并寻找更多。
Thanks in advance, Sambhav
提前致谢，桑巴夫
回答by Josien
There is a lot out there! Here are a few nice ones that offer (online) practice:
那里有很多！以下是一些提供（在线）练习的不错的方法：
SQLZOO- lets you practice interactively with SQL queries for different database management systems;
SQLCourse.com- also an interactive tutorial that lets you practice SQL queries;
Introduction to Databases- a Stanford online course with a lot of explanatory video lectures. It is much more theoretical, but also provides the possibility to practice with the stuff that's taught;
GalaXQL- another interactive SQL tutorial using SQLite;
SQL-EX- seems to provide SQL exercises, but requires an account.
SQLZOO- 让您以交互方式练习针对不同数据库管理系统的 SQL 查询；
SQLCourse.com- 也是一个交互式教程，可让您练习 SQL 查询；
数据库简介- 斯坦福大学的在线课程，包含大量解释性视频讲座。它更具理论性，但也提供了使用所教内容进行练习的可能性；
GalaXQL- 另一个使用 SQLite 的交互式 SQL 教程；
SQL-EX- 似乎提供 SQL 练习，但需要一个帐户。
Some sample databases can be downloaded here:
一些示例数据库可以在这里下载：
- SQL Server 2008/2012/2014 -> AdventureWorkssample databases;
- SQL Server 2008/2012/2014 -> AdventureWorks示例数据库；
