恕我直言，最好的“工具”是教科书。这是软件无法为您完成的领域之一。当然，它可以构建简单的选择和选择。连接，但不是聚合函数或分组，或子选择等。为此，您必须学习以老式方式进行操作 - 手动/湿软件。我推荐：Lynn Beighley 的“Head First SQL”，来自 O'Reilly Press。
买一本书。
安装您选择的数据库。
导入一些测试数据。
尝试使用尽可能多的函数来执行查询。
练习，练习，练习。
IMHO, the best "tool" for this is a textbook. This is one of those areas where the software can't do it for you. Sure, it can build simple selects & joins, but not aggregate functions or groupings, or sub-selects, etc. For that, you've got to learn to do it the old fashioned way -- by hand/wetware. I recommend: "Head First SQL" by Lynn Beighley, via O'Reilly Press.
Get a book.
Install the database of your choice.
Import some test data.
Try to execute queries using as many functions as possible.
TOAD is probably the best multi-database tool for this sort of thing, however I do not believe there is any substitute for thoroughly groking SQL yourself. If you have difficulty constructing a query then it's going to be well nigh impossible to debug it effectively.
When my queries get too ugly, I find it helpful to use one of the many SQL beautifiers that are out there. These will not print graphics for you, but just proper indentation, syntax highlighting and brackets will help you out a good deal.
发布评论
评论（6）
恕我直言，最好的“工具”是教科书。这是软件无法为您完成的领域之一。当然，它可以构建简单的选择和选择。连接，但不是聚合函数或分组，或子选择等。为此，您必须学习以老式方式进行操作 - 手动/湿软件。我推荐：Lynn Beighley 的“Head First SQL”，来自 O'Reilly Press。
练习，练习，练习。
IMHO, the best "tool" for this is a textbook. This is one of those areas where the software can't do it for you. Sure, it can build simple selects & joins, but not aggregate functions or groupings, or sub-selects, etc. For that, you've got to learn to do it the old fashioned way -- by hand/wetware. I recommend: "Head First SQL" by Lynn Beighley, via O'Reilly Press.
Practice, practice, practice.
每个数据库都带有内部命令来分析复杂的sql，解释哪些连接效率低下或需要更多时间来执行。
例如：如果您使用 mysql 那么命令是：explain
Every database comes with internal command to analyze complex sqls, explaining which join is not-efficient or taking more time to execute.
Ex: if you are using mysql then command is : explain
TOAD 可能是处理此类事情的最佳多数据库工具，但我不相信有任何代替自己彻底摸索 SQL。如果您在构造查询时遇到困难，那么有效地调试它几乎是不可能的。
TOAD is probably the best multi-database tool for this sort of thing, however I do not believe there is any substitute for thoroughly groking SQL yourself. If you have difficulty constructing a query then it's going to be well nigh impossible to debug it effectively.
当我的查询变得太难看时，我发现使用众多 SQL 美化器 就在那里。这些不会为您打印图形，但只要适当的缩进、语法突出显示和括号就会帮助您解决很多问题。
When my queries get too ugly, I find it helpful to use one of the many SQL beautifiers that are out there. These will not print graphics for you, but just proper indentation, syntax highlighting and brackets will help you out a good deal.
查看 MyEclipse 7.5 的新 Visual SQL Builder。
Check out the new Visual SQL Builder of MyEclipse 7.5.
我使用一个名为“Code Factory for MySQL”的可视化工具。
它仅适用于 MySQL，但也是一个很棒的学习工具。
I use a visual tool called "Code Factory for MySQL".
It's just for MySQL, but also a great learning tool.