blocks|key|1995318|text|试试SQL+Exercises|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1995319|从learning+stage开始|1995320|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sql-ex.com/|1|http://www.sql-ex.com/learn_exercises.php^0|2|D|0|0|1|E|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

Try <a href="http://www.sql-ex.com/" rel="nofollow noreferrer">SQL Exercises</a>

Start with <a href="http://www.sql-ex.com/learn_exercises.php" rel="nofollow noreferrer">learning stage</a>

blocks|key|1995305|text|如果选择SQL+Server，那么Northwind/Adventureworks就是标准的“培训”数据库。做个搜索。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1995306|对于mySql来说，这个项目看起来很有前途：|1995307|http://sourceforge.net/projects/awmysql/|offset|length|1995308|另外，这可能是一个骗局：|1995309|Is+there+a+"Northwind"+type+database+available+for+MySQL?|1995310|Where+can+I+download+Northwind+database+for+Postgresql?|1995311|entityMap|0|LINK|mutability|MUTABLE|url|1|https://stackoverflow.com/questions/2036395/is-there-a-northwind-type-database-available-for-mysql|2|https://stackoverflow.com/questions/2585643/where-can-i-download-northwind-database-for-postgresql^0|0|0|0|14|0|0|0|0|1L|1|0|0|1J|2|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|10|8|@]|9|@$F|11|G|12|1|13]]|A|$]]|$1|H|3|I|5|6|7|14|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|15|8|@]|9|@$F|16|G|17|1|18]]|A|$]]|$1|L|3|M|5|6|7|19|8|@]|9|@$F|1A|G|1B|1|1C]]|A|$]]|$1|N|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|E]]|U|$5|Q|R|S|A|$T|V]]|W|$5|Q|R|S|A|$T|X]]]]

If SQL Server is an option then Northwind/Adventureworks are the standard "training" DBs. Do a search.

For mySql this project looks promising:

<a href="http://sourceforge.net/projects/awmysql/" rel="nofollow noreferrer">http://sourceforge.net/projects/awmysql/</a>

Also, this might be a dupe:

<a href="https://stackoverflow.com/questions/2036395/is-there-a-northwind-type-database-available-for-mysql">Is there a &quot;Northwind&quot; type database available for MySQL?</a>

<a href="https://stackoverflow.com/questions/2585643/where-can-i-download-northwind-database-for-postgresql">Where can I download Northwind database for Postgresql?</a>

blocks|key|516528|text|我建议安装Microsoft+SQL+Server2008Express(或R2)，并添加Northwind+or+Adventureworks数据库。它很大，所以我相信你可以玩它。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|516529|entityMap|0|LINK|mutability|MUTABLE|url|http://msftdbprodsamples.codeplex.com/^0|19|R|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I would suggest setting up Microsoft SQL Server 2008 Express (or the R2), and adding the <a href="http://msftdbprodsamples.codeplex.com/" rel="nofollow noreferrer">Northwind or Adventureworks</a> database. It's pretty big so I'm sure you can play with it.

blocks|key|1995372|text|我找到了SQLZoo，它也是类似的东西。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1995373|entityMap|0|LINK|mutability|MUTABLE|url|http://sqlzoo.net/^0|4|6|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I found <a href="http://sqlzoo.net" rel="nofollow">SQLZoo</a> which is something similar too.

blocks|key|516596|text|如果你感兴趣，Eve+Online，一个相当大的MMO，让他们的静态数据(游戏中的物品，NPCs，任何没有真正改变的东西)可以通过下载获得。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|516597|*编辑：*+http://www.eveonline.com/community/toolkit.asp|offset|length|516598|这是一个高度规范化的数据集，有超过12个表和数千条记录。如果您想深入研究企业数据仓库，我建议您这样做。|516599|下载为MS+SQL+Server+2008备份文件，可直接导入MS+SQL+Server+2008+Express+(免费版)|516600|但是，如果你是一个全新的数据库新手，我不建议你这样做。|516601|entityMap|0|LINK|mutability|MUTABLE|url|http://www.eveonline.com/community/toolkit.asp^0|0|6|1A|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@$D|V|E|W|1|X]]|A|$]]|$1|F|3|G|5|6|7|Y|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|Z|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|10|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S]]]]

If you're intersted, Eve Online, a rather large MMO, make their static data (in-game items, NPCs, anything that doesn't really change) available via download.

***edit:* <a href="http://www.eveonline.com/community/toolkit.asp" rel="nofollow noreferrer">http://www.eveonline.com/community/toolkit.asp</a>

It's a very heavily normalized data set, with over a dozen table, and thousands of records.
If you want to dive into the deep end of enterprise data warehousing, I'd recommend this.

Downloads as a MS SQL Server 2008 Backup file, which can be imported directly into MS SQL Server 2008 Express (The free edition)

I do not recommend this if you are brand new to databasing, however.

blocks|key|515337|text|我建议向贵国政府索要一些统计数据(只需浏览他们的网站，应该会有很多)。然后导入H2+database中的数据并导入。将生成的DB文件保存在某个地方，并将它们提供给您的学生用于他们的工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|515338|entityMap|0|LINK|mutability|MUTABLE|url|http://www.h2database.com/^0|13|B|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I suggest to ask your government for some statistical data (just browse their website; there should be plenty). Then import the data in a <a href="http://www.h2database.com/" rel="nofollow noreferrer">H2 database</a> and import it. Save the resulting DB files somewhere and give them to your students for their work.

blocks|key|1995388|text|您可以使用https://db4free.net/，它允许您从您的代码或JMeter等工具远程访问它。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1995389|它很慢，但很有效。|1995390|它需要注册。|1995391|entityMap|0|LINK|mutability|MUTABLE|url|https://db4free.net/^0|5|K|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]]]

You can use 
<a href="https://db4free.net/" rel="nofollow noreferrer">https://db4free.net/</a>
which allows you to access it remotely from your code or tools like JMeter.

It's slow but works.

it requires registration.

blocks|key|3403479|text|我喜欢这里实现的纯SQL游戏的概念：https://mystery.knightlab.com|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3403480|它提供了学习SQL的游戏化，并包括一个类似于教程的可选介绍。|3403481|如果您已经了解SQL，但感觉有点生疏，那么复习一下这篇文章是很有趣的。|3403482|对于初学者来说，这是一个简单的手帮助第一次接触。|3403483|这些数据是人为的，在离开直接游戏赛道时会有稍微陡峭的下降，但我认为它仍然符合你的“有意义”的要求。(如果你故意偏离轨道，那么有迹象表明可以找到一些以笑话的形式出现的复活节彩蛋。我还没有设法让查询正确地真正读取它们……因此，我认为，即使在显而易见的游戏之外，也有更有经验的人需要寻找的东西。)|3403484|entityMap|0|LINK|mutability|MUTABLE|url|https://mystery.knightlab.com/^0|I|T|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|D|3|E|5|6|7|X|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|Y|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|Z|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|10|8|@]|9|@]|C|$]]|$1|L|3|-4|5|6|7|11|8|@]|9|@]|C|$]]]|M|$N|$5|O|P|Q|C|$R|S]]]]

I like the concept of a game on pure SQL as implemented here: <a href="https://mystery.knightlab.com" rel="nofollow noreferrer">https://mystery.knightlab.com</a> 
It offers gamification of learning SQL and includes an optional tutorial-like introduction. 
If you already know SQL but feel a little rusty, then this is fun to brush up. 
For beginners it is an easy hand-help first contact.

The data are artificial and have a slightly steep drop-off when leaving the immediate game track, but I think it still matchs your requirement to be "meaningful". (And if you go intentionally off-track, then there are hints that some easter-eggs can be found, in the shape of jokes. I did not yet manage to get the query right to actually read them... So I think that even beyond the obvious game there is something for the more experienced to hunt for.)

blocks|key|1260364|text|最好的方法是使用AWS+RDS服务。在那里创建一个基于云的数据库，获取您的凭据并将其共享给公众。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1260365|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

The best way is to use the AWS RDS service. Create a Cloud-based database there, obtain your credentials and share them to public.

I am looking for a publicly available SQL database with free access, where one can run some <code>SELECT</code> queries for free on some meaningful data (not item1, item2, item3). Have you seen any? Even better if it came together with some tutorial.

Vendor is not that relevant, as long as one can connect using a generic JDBC client.

Public SQL database for educational purposes

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我正在寻找一个免费访问的公开可用的SQL数据库，其中一个可以运行一些有意义的数据(不是item1，item2，item3)免费的SELECT查询。你见过吗？如果它和一些教程结合在一起就更好了。供应商并不重要，只要可以使用通用JDBC客户端进行连接即可。

问用于教育目的的公共SQL数据库
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用于教育目的的公共SQL数据库EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用于教育目的的公共SQL数据库
EN