blocks|key|3005383|text|查找具有挑战性的问题来测试您的TRANSACT-SQL知识...就我个人而言，我喜欢Joe+Celko's+SQL+Puzzles+and+Answers。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3005384|Joe+Celko's+SQL+Puzzles+and+Answers+http://ecx.images-amazon.com/images/I/51DTJ099P7L._SL500_BO2,204,203,200_PIsitb-dp-500-arrow,TopRight,45,-64_OU01_AA240_SH20_.jpg|3005385|entityMap|0|LINK|mutability|MUTABLE|url|https://rads.stackoverflow.com/amzn/click/com/0123735963|1|http://ecx.images-amazon.com/images/I/51DTJ099P7L._SL500_BO2,204,203,200_PIsitb-dp-500-arrow,TopRight,45,-64_OU01_AA240_SH20_.jpg^0|16|Z|0|0|0|4L|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]]]]

Find challenging questions that test your TRANSACT-SQL knowledge ... personally I enjoy <a href="https://rads.stackoverflow.com/amzn/click/com/0123735963" rel="noreferrer" rel="nofollow noreferrer">Joe Celko's SQL Puzzles and Answers</a>.

<a href="http://ecx.images-amazon.com/images/I/51DTJ099P7L._SL500_BO2,204,203,200_PIsitb-dp-500-arrow,TopRight,45,-64_OU01_AA240_SH20_.jpg" rel="noreferrer">Joe Celko&#39;s SQL Puzzles and Answers http://ecx.images-amazon.com/images/I/51DTJ099P7L._SL500_BO2,204,203,200_PIsitb-dp-500-arrow,TopRight,45,-64_OU01_AA240_SH20_.jpg</a>

blocks|key|3005356|text|关于SQL语言的事情是，它几乎是一个静态目标。很快，你就会看到增加你对集合论和问题域本身的理解，而不是语言的细节。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3005357|真正的肉在语言的任何一方，要么在数据库本身(如何存储、检索和组织大型数据集)，要么在应用程序(使用ORM等)中。|3005358|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

The thing about the SQL language is that it is pretty much a static target. Pretty soon you are looking at increasing your understanding of set theory and the problem domain itself rather than the details of the language.

The real meat is on either side of the language, in either the databases themselves (how to store, retrieve, and organize large data sets) or in the applications (with ORMs and such)

blocks|key|3006390|text|我浏览了一下答案，显然没有人提到斯蒂芬·法鲁特的工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3006391|我强烈建议你考虑一下“SQL的艺术”(http://www.amazon.com/Art-SQL-Stephane-Faroult/dp/0596008945)，我发现它真的很有趣--令人惊讶的是，甚至读起来也很有趣。|offset|length|3006392|entityMap|0|LINK|mutability|MUTABLE|url|https://rads.stackoverflow.com/amzn/click/com/0596008945^0|0|J|1O|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

I skimmed the answers and apparently nobody has mentioned Stephane Faroult's work.

I strongly suggest you should consider "The Art of SQL" (<a href="https://rads.stackoverflow.com/amzn/click/com/0596008945" rel="nofollow noreferrer" rel="nofollow noreferrer">http://www.amazon.com/Art-SQL-Stephane-Faroult/dp/0596008945</a>), I found it really interesting and - amazingly enough, even fun to read.

blocks|key|3849321|text|http://sqlblog.com/怎么样？|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3849322|entityMap|0|LINK|mutability|MUTABLE|url|http://sqlblog.com/^0|0|J|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]]]]

How about <a href="http://sqlblog.com/" rel="nofollow noreferrer">http://sqlblog.com/</a>

blocks|key|5260857|text|我通过分析缓慢和复杂的查询并寻找改进它们的方法来改进它们。这可以在SQL+Server中通过分析查询计划工具并查找瓶颈来完成。另外，我发现Visual+Quickstart+Guide指南对快速参考很有帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|5260858|entityMap|0|LINK|mutability|MUTABLE|url|https://rads.stackoverflow.com/amzn/click/com/0321118030^0|1X|N|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 improve by analyzing slow and complex queries and looking for ways to improve them. This can be done in SQL Server by analyzing the Query Plan tools and looking for bottlenecks. Also I find the <a href="https://rads.stackoverflow.com/amzn/click/com/0321118030" rel="nofollow noreferrer" rel="nofollow noreferrer">Visual Quickstart Guide</a> guide to be good for quick reference.

blocks|key|3849876|text|Joe+Celko的SQL+Puzzles+and+Answers和SQL+for+Smarties是目前最好的两本通用SQL书。这两个都是很好的资源，可以帮助您解决您过去认为需要一个游标或某个客户端库才能完成的棘手问题。对于任何真正感兴趣的SQL极客来说，这些书也是很好的休闲阅读，而不仅仅是桌面参考。竖起两个拇指。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3849877|entityMap|0|LINK|mutability|MUTABLE|url|https://rads.stackoverflow.com/amzn/click/com/1558604537|1|https://rads.stackoverflow.com/amzn/click/com/0123693799^0|A|N|0|Y|G|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

Joe Celko's <a href="https://rads.stackoverflow.com/amzn/click/com/1558604537" rel="nofollow noreferrer" rel="nofollow noreferrer">SQL Puzzles and Answers</a> and <a href="https://rads.stackoverflow.com/amzn/click/com/0123693799" rel="nofollow noreferrer" rel="nofollow noreferrer">SQL for Smarties</a> are the two best generic SQL books out there. Both are great sources to give you ideas for that tricky problem you used to think you needed a cursor or some client library to accomplish. For any truly interested SQL geek, these book are also pretty good for casual reading rather than as a mere desk reference. Two thumbs up.

blocks|key|3849302|text|虽然不是SQL+Server专家，但总的来说，我发现基于社区的事件是跟上当前模式的好方法。在这里参与开发人员/DBA/营销专家/插入专业人员社区的潜在结果是，您正在学习新的思维模式并锻炼批判性思维。无论你是什么职业，这都是一个很好的成长方式。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3849303|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|$]]

While not a SQL Server expert, in general I find that community based events are great ways to keep up on current patterns. The underlying result of participating in a community of developers/DBAs/Marketing Pros/insert profession here is that you are learning new thought patterns and excercising critical thought. This is a great way to grow as whatever professional you are.

blocks|key|5261072|text|SQL中没有当前的技术和趋势。只有那些你应该已经知道但却不知道的东西，正确的学习方法就是痛苦……太痛苦了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5261073|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|$]]

There aren't current techniques and trends in SQL. There's only that stuff you should already know but don't. The proper way to learn that stuff, is pain... so much pain.

blocks|key|3005748|text|加入你在stackoverflow上use...or潜伏的DB风格的邮件列表;)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3005749|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|$]]

Join a mailing list for the DB flavour you use...or lurk on stackoverflow ;)

blocks|key|3850335|text|大多数“当前”的东西不是SQL本身，而是数据库如何存储信息，以及如何更快地检索信息。查看另一个线程：What+are+some+references,+lessons+and+or+best+practices+for+SQL+optimization+training|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3850336|唯一真正的前沿是在查询计划、索引结构、排序算法等方面，而不是SQL本身。|3850337|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/23927/what-are-some-references-lessons-and-or-best-practices-for-sql-optimization-tra^0|1E|2D|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

Most "current" stuff is not SQL itself, but how the database stores the information, and how to retrieve it more quickly. Check out this other thread: <a href="https://stackoverflow.com/questions/23927/what-are-some-references-lessons-and-or-best-practices-for-sql-optimization-tra">What are some references, lessons and or best practices for SQL optimization training</a>

The only real bleeding edge is in query planning, index structures, sort algorithms, things like that, not the SQL itself.

blocks|key|5261665|text|你问这个问题已经是一个好兆头了。避免自满是“第一条建议”。没有什么可以替代编写和优化SQL。实际使用是保持敏锐的最佳方式，但存在“以林换树”的风险，在这种情况下，我们倾向于使用舒适和熟悉的东西。尝试新的策略，检查新的方法，寻找新的方法来训练我们的大脑思考集合，SQL，关系理论，并掌握我们所使用的特定方言的新开发，这些都是优秀的SQL开发人员的特征。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5261666|这些天有很多好的博客。我主要在微软领域工作，所以我喜欢SQLTeam.com。|offset|length|5261667|Usenet是一个很好的闲逛和做出贡献的地方。有许多与SQL相关的新闻组。通常，你会发现，解决别人的问题可以帮助你学习一种新的策略，或者迫使你研究一种你不是每天都会遇到的语言的一个尘封的角落。然而，由于恶意的使用，ISP似乎注定要关闭所有的Usenet，所以这一次可能会像渡渡鸟一样。|5261668|此外，一些IRC服务器有一个充满活力的sql通道，您可以在其中做出同样的改变(只需随身携带)。|5261669|最后，这个网站可能是另一个值得挂起的地方，在那里你可以阅读困难问题的答案，看看它如何应用于你自己的世界，练习技术，并将其内化。也要做出贡献，因为看到别人如何投票赞成或反对你的解决方案是100%25纯粹的诚实反馈。|5261670|当然，书中也有很多精彩的书。Celko写的任何东西都是赢家，在SQL+Server方面，Kalen+Delaney和Ron+Soukup写了一些赢家。|5261671|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqlteam.com/^0|0|R|B|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|F|3|G|5|6|7|10|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|11|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|12|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|13|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U]]]]

The fact that you asked this question is already a good sign. Avoiding complacency is "piece of advice #1". There is no substitute for writing and optimizing SQL. Practical use is the best way to stay sharp, but there is a risk of a "forest for the trees" scenario, where we tend to use what is comfortable and familiar. Trying new tactics, examining new approaches, and looking for new ways to train our brains to think about sets, SQL, relational theory, and staying on top of new developments in the particular dialects we employ are all hallmarks of good SQL developers.

There are many good blogs out there these days. I work mostly in the Microsoft arena, so I like <a href="http://www.sqlteam.com/" rel="nofollow noreferrer">SQLTeam.com</a>.

Usenet is a good place to hang out and make a contribution. There are many SQL-related newsgroups. Often, you will find that working on someone else's problem helps you learn a new tactic or forces you to research a dusty corner of the language that you do not encounter every day. ISPs seem destined to shut all of the Usenet down, though, because of nefarious use, so this one may be going the way of the Dodo bird.

Also, some IRC servers have a vibrant sql channels where you can make the same sort of a difference (just take a thick skin with you).

Lastly, this very website might be another place to hang, where you can read over the answers to difficult questions, see how that might apply in your own world, practice the techniques, and internalize them. Contribute too, because seeing how others vote your solutions up or down is 100% pure honest feedback.

Of course, there are many wonderful books out there, too. Anything by Celko is a winner, and on the SQL Server side, Kalen Delaney and Ron Soukup have written some winners.

blocks|key|3849582|text|我遇到的最好的事情就是处理别人的SQL代码。尤其是遗留业务代码。你想测试你的技能，开始改变一些其他人都不懂的“伏都教代码”。:)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3849583|除此之外，我只是试图关注SQL的新版本的变化，看看是否有什么我可以利用的。|3849584|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Best thing I've run into is working on other people's SQL code. Especially legacy business code. You want to test your skills against something, start changing some "voodoo code" that no one else understands. :)

Beyond that, I just try to keep an eye on changes with new releases of SQL and see if there's anything I can take advantage of.

blocks|key|5260977|text|使用phpmyadmin时的提示很好，也很冗长|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5260978|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|$]]

gleam tips when using phpmyadmin
it's nice and verbose

blocks|key|758756|text|这里有一些有趣的SSIS信息。http://blogs.conchango.com/jamiethomson/default.aspx|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|758757|这里也有一些很好的信息：http://wiki.lessthandot.com/index.php/Main_Page|758758|对于那些说SQL永远不变的人来说，SQL+Server+2005和2008在T-SQl方面有一些巨大的变化，这些变化将有助于解决一些难题，这些问题在SQL+Server+2000中做起来很可怕，一旦你学习了新的语法，就会变得容易得多，所以确实有一些东西需要跟上。|758759|此外，性能调优和SSIS都是非常复杂的科目，需要学习的内容很多。|758760|我确实发现，选择不学习高级SQL技能的开发人员倾向于编写性能低下的SQL代码，并且一旦数据库中的记录数量增加，他们编写的应用程序往往会变得非常缓慢，并且很难修复。现在，我正在与开发人员合作，修复他们编写的一些糟糕的代码，这些代码几乎在每个查询上都会导致网站超时。显然，这现在是紧急情况，如果开发人员有更好的SQL技能，那么在一开始就以更有效的方式编写代码会很容易。|758761|entityMap|0|LINK|mutability|MUTABLE|url|http://blogs.conchango.com/jamiethomson/default.aspx|1|http://wiki.lessthandot.com/index.php/Main_Page^0|F|1G|0|0|C|1B|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@$A|W|B|X|1|Y]]|C|$]]|$1|D|3|E|5|6|7|Z|8|@]|9|@$A|10|B|11|1|12]]|C|$]]|$1|F|3|G|5|6|7|13|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|14|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|15|8|@]|9|@]|C|$]]|$1|L|3|-4|5|6|7|16|8|@]|9|@]|C|$]]]|M|$N|$5|O|P|Q|C|$R|S]]|T|$5|O|P|Q|C|$R|U]]]]

Here is one with some interesting SSIS information.
<a href="http://blogs.conchango.com/jamiethomson/default.aspx" rel="nofollow noreferrer">http://blogs.conchango.com/jamiethomson/default.aspx</a>

There is also some good information in the Wiki here:
<a href="http://wiki.lessthandot.com/index.php/Main_Page" rel="nofollow noreferrer">http://wiki.lessthandot.com/index.php/Main_Page</a>

For those who say SQL never changes, SQL Server 2005 and 2008 have some huge changes in the T-SQl that will help solve some difficult problems that were horrible to do in SQL Server 2000 and are much easier once you learn the new syntax, so yes there is stuff to keep up with. 

Also performance tuning and SSIS are extremely complex subjects with much to learn. 

I do find that developers who choose not to learn advanced SQL skills tend to write poorly performing SQL code and once the number of records grows in their databases, the applications they wrote tend to become glacially slow and very difficult to fix at that point. Right now I'm working with developers to fix some bad code they wrote that is causing timeouts on the site on virtually every query. Obviously, this is now an emergency and it would have been easy to write the code in a more efficeint manner at the start if the developer had better SQL skills.

blocks|key|758777|text|我从来没有听说过"SQL开发人员“这个术语。SQL应该是你工具箱中的一项技能，就像排序、任何你喜欢的框架、JavaScript等等。继续提高SQL技能的最好方法是继续使用它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|758778|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|$]]

I've never heard of the term "SQL developer." SQL should be a skill in your toolbox, like sorting, whatever framework you like, JavaScript, and so on. The best way to continue to improve your SQL skills to continue using it.

blocks|key|5261347|text|作为一名开发人员，而不是DBA，我关注着各种开发人员资源，这些资源通常与数据库相关，但我并不特别“努力跟上”。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5261348|我知道的很多，但我也知道还有更多的东西要知道。在每个项目中，我都要学习一些新的东西。而且每个项目都涉及到我对过去遇到的类似任务采取不同的方法。|5261349|如果有一天我认为我一直在做同样的事情，也许我会有意识地努力采取具体的步骤。但目前，在可预见的未来，我正在有机地学习，在工作中，并根据我的项目要求。|5261350|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

As a developer, and not a DBA, I keep an eye on various developer resources, and that often is DB related, but I don't specifically 'try to keep up'. 

I know plenty, but I also know that there is so much more that there is to know. And in every project I have to learn something new. And every project also involves me taking a different approach to a similar task I'd encountered in the past.

Should I ever get to the stage where I think I'm doing the same things all the time, perhaps I'll make a concious effort to take specific steps. But currently, and for the foreseeable future, I'm learning organically, on-the-job, and as my projects dictate.

blocks|key|758808|text|阅读：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|758809|书籍-+Celko+(也可以阅读一些带有Oracle偏见的书籍)博客-上面提到的，加上SSWUG|758810|网络研讨会和会议-跟上SSIS/SSRS/SSAS等供应商特定内容的最佳途径|758811|练习：|758812|改进代码(我的和其他的)|758813|重构|758814|指导/培训其他开发人员|758815|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|S|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|T|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|V|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|O|$]]

Reading:

Books - Celko (also read across to some Oracle-biased books)
Blogs - the above mentioned, plus SSWUG

Webinars and Conference - Best way to keep up with vendor-specific stuff like 
SSIS/SSRS/SSAS

Practice:

Improving code (mine and others)

Refactoring

Mentoring/training other developers

blocks|key|5261421|text|老实说，这是随着时间的推移你会变得更好的事情之一。尽可能多地阅读，以了解什么是可能的。有些事情需要一段时间才能真正理解。我被子查询吓跑了很长一段时间，直到我几乎别无选择，只能使用它们。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5261422|当你获得了更多的经验，需要做更复杂的事情时，你就会学会自己的方式。|5261423|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Honestly, it's one of those things that you just get better at with time. Read as much as you can to know what's possible. Some things will take a while to really understand. I was scared off by sub queries for a long time until I pretty much had no choice but to use them.

When you get more experiance and need to do more complex things, you will just learn your way.

blocks|key|3850199|text|SqlServerCentral+-大量文章、脚本和建议的来源|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3850200|不幸的是，要访问你需要注册的文章(这是免费的)|3850201|我想他们可以从StackOverflow学到的一件事就是移除login+barrier|3850202|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqlservercentral.com/|1|http://www.codinghorror.com/blog/archives/000881.html^0|0|G|0|0|0|U|D|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]|P|$5|K|L|M|C|$N|Q]]]]

<a href="http://www.sqlservercentral.com/" rel="nofollow noreferrer">SqlServerCentral</a> - great source of articles, scripts, advice

Unfortunately to access the articles you need to register (it is free though) 
I guess one thing they could learn from StackOverflow is to remove <a href="http://www.codinghorror.com/blog/archives/000881.html" rel="nofollow noreferrer">login barrier</a>

blocks|key|3006451|text|我们已经编写了一个full+tutorial，您可以在separate+site+(也是由我创建的，为了完整声明)测试您的SQL技能。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3006452|entityMap|0|LINK|mutability|MUTABLE|url|http://www.wiseowl.co.uk/blog/s217/sql_server_tutorial.htm|1|http://www.skills-assessment.net/sql-test-skills.htm^0|9|D|0|R|D|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

We've written a <a href="http://www.wiseowl.co.uk/blog/s217/sql_server_tutorial.htm" rel="nofollow">full tutorial</a>, and you can test your SQL skills at a <a href="http://www.skills-assessment.net/sql-test-skills.htm" rel="nofollow">separate site</a> (also created by our me, in the interests of full declaration).

blocks|key|5260834|text|SQL开发人员还是DBA？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5260835|除了在日常工作中学习不同的SQL方言(Oracle、SQL+Server等)之外，SQL实际上并没有改变太多。当然，随着你技能的提高，你可以引入更高级的概念，找出在哪里实现存储过程，等等，但最终它只是SQL。最重要的事情是让你的模式正确和可维护。|5260836|现在管理数据库是完全不同的事情，有一系列的工具，数据库软件本身每隔几年就会更新一次。Oracle至少有时事通讯、网站和杂志，其中可能包含大量信息、示例和最佳实践场景。|5260837|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

SQL developers, or DBAs?

Aside from learning different dialects of SQL (Oracle, SQL Server, etc) in your day to day work, SQL doesn't actually change all that much. Sure you can bring in more advanced concepts as you develop your skills, work out where to implement stored procedures, etc, but in the end it's just SQL. The most important thing is to get your schema correct and maintainable.

Now administering the databases is a whole different thing, with a range of tools, and the database software itself getting updated every few years. Oracle at least have newsletters and websites and magazines that presumably include lots of information and examples and best practice scenarios.

blocks|key|5260792|text|老实说，我不认为有太多需要极端的SQL技能。一旦我可以创建事务(用于数据库一致性)和基本触发器(用于交叉表一致性)，我通常可以很好地保留程序逻辑……在程序中，而不是把它放到我使用的数据库中。与不断深入扩展的常规编程不同，我没有发现多少值得研究一生的SQL深度。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5260793|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|$]]

To be honest, I don't see much a need for extreme SQL skills. Once I can create transactions (for DB consistency) and basic triggers (for cross-table consistency), I'm usually fine keeping program logic... in the program, and not putting it into whatever database I'm using. I've not found much depth to SQL worth investigating for a lifetime, unlike general programming, which keeps expanding in depth.

How do SQL developers go about keeping up on current techniques and trends in the SQL world? Are there any blogs, books, articles, techniques, etc that are being used to keep up to date and in the know?

There are a lot of opportunities out their for OO, procedural, and functional programmers to take part in a variety of open source projects, but it seems to me that the FOSS avenue is a bit more closed for SQL developers.

Thoughts?

How do you continue to improve your SQL skills?

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

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

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

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

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

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

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

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

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

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

社区新版编辑器体验调研

SQL开发人员如何跟上SQL世界的最新技术和趋势？是否有任何博客、书籍、文章、技术等正在被用来保持最新和了解情况？OO、过程化和函数式程序员有很多机会参与各种开源项目，但在我看来，FOSS大道对SQL开发人员来说有点封闭。有什么想法？

问您如何继续提高您的SQL技能？
EN

回答 22

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问您如何继续提高您的SQL技能？EN

回答 22

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问您如何继续提高您的SQL技能？
EN