什么数据库程序可以用于此目的?
我正在上数据库课。我们正在学习连接、并集和投影。
有没有一个程序可以帮助练习?就像我的表达式一样,它选择表中的适当字段。
I'm in a database class. We're learning about joins, unions, and projections.
Is there a program that would be helpful in getting practice? Like I an expression and it selects the appropriate fields in a table.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
请不要为这一简单的任务下载并尝试安装服务器 DBMS(以及一个或多个客户端)。如果您正在学习成为数据库管理员的课程,您可能需要花几个小时来学习这些技术(并且,如果您继续认真地使用这些产品,您最终将需要掌握其中的一些技术),但是如果您只是想练习 SQL 查询,有些网站可以让您这样做。
您可以在这里找到一些不错的在线练习:http://sqlzoo.net/。
Please don't bother downloading and trying to install a server DBMS (plus one or more clients) for this simple task. If you're taking a course in being a database administrator you might want to spend hours learning these technologies (and, if you go on to work with these products seriously you will, eventually, need to master some of them), but if you just want to practice SQL queries, there are sites that let you do just this.
You can find some nice on-line exercises here: http://sqlzoo.net/.
MySql 易于使用且免费,因此这是我的选择。社区服务器是您要下载的服务器。
http://www.mysql.com/
我建议您也使用 Workbench 工具,以使其更容易创建表格并摆弄它们。
MySql is easy to use and free so that would be my choice. The community server is the one you want to download.
http://www.mysql.com/
I would recommend getting the Workbench tool as well to make this easier to create tables and mess around with them.
下载并安装 Microsoft SQL Server 2008 R2 Express 及其管理工具。拥有您入门所需的一切,并且 100% 免费。
您可以在这里获取它: http://www.microsoft.com/sqlserver /en/us/editions/express.aspx
或者,如果您愿意花 50 美元,您可以购买 SQL Server 2008 R2 开发人员版(完整的企业/数据中心版,许可仅限于开发、测试) ,并演示)到做一些非常酷的事情。
Download and install Microsoft SQL Server 2008 R2 Express, with Management Tools. Has everything you need to get started and it's 100% free.
You can get it here: http://www.microsoft.com/sqlserver/en/us/editions/express.aspx
Or if you are willing to part with $50, you can buy SQL Server 2008 R2 Developer Edition (full enterprise/data center edition, just with licensing restricting only to development, testing, and demoing) to do some really cool stuff.