《Pro Oracle SQL》 翻译序 -- 读书心得

      天行健,君子以自强不息! 作为一名和Oracle数据库打交道很多的Java Web开发人员,接触数据库久了,深感数据库知识的匮乏。我由此萌发了精研Oracle的动力。另一方面,Oracle的开发人员的待遇通常都要比Java的好得多。从最开始遇到问题就抱佛脚--去查《SQL Cookbook》,到《Oracle 9i&10g编程艺术》,切身体会最核心的东西还是数据库的语言SQL。SQL语言入门容易,但是要把它的功能发挥的淋漓尽致不结合特定的数据库环境是不可能的。掌握最先进的SQL语法,写出有杀伤力的SQL语句,几乎成了我的“心病”。

      An ideal book is the key to ones wit(一本好书是开启智慧的钥匙)。 直到我无意间在网上找到这本《Pro Oracle SQL》,才有一种醍醐灌顶的感觉。经常在网上找资料学习,先进的技术资料都是英文的,没办法JAVA,ORACLE都是“进口的”。由此我萌发了边翻译,边学习的想法。

     路漫漫其修远兮!对于一名热爱研究技术的草根,现在培训,进修的成本真的很高,稍微培训一下。动则几千,少则几万。钱还是小事,时间和青春更宝贵!培训的效果也不是就一定很好,很多时候感觉被骗了。我时常觉得我的大学教育很失败。我几乎每日都在反思我以前所耽误的青春。最可靠,最便宜的方式也就是自学了。但是自学需要有超越自我的勇气和意志加一本好书。现在有了!

     另外,幸好有了ITEYE这个平台, 把自己的学习过程都贴在博客上,一是便于日后自己复习,二是若能”予人玫瑰,手有余香“就实在是做了一件令人欣慰的事。 国内的出版业,知识界也远没有国外那么开放,技术书籍的电子版可以如此方便的获取到。能够免费得到这样的书籍,有如神助!这也算对我辈这些相信“知识就是力量”的书生的一种鼓励吧。我个人非常敬佩国外的这些作者 ,他们都是我们的前辈。我把这本书翻译出来,作为回报,也算是为他们把这本好书介绍给像我这样的 中国 人吧。

    本人水平有限,翻译出来的文章肯定有很多问题,但是搞软件工程的人都知道“重构”的重要性。我的博文也在不断的修订。众人拾柴火焰高,欢迎批评指正文中的错误。如果你喜欢的话就帮我顶一下,发现错误的话就留言指正。这对我很重要,我也希望结交更多的志同道合的朋友。

    文中蓝色 文字表示我所记重点。红色 文字表示我翻译的有些吃力的地方,或者是生词。文中的一些输出格式比较难调。您可以参考原书PDF。

 


推荐到如下网站下载最新的技术书籍: www.wowebook.com

我的书就是从这里下的:http://www.wowebook.pro/book/pro-oracle-sql/

实际下载链接:http://www.wupload.cn/file/298046281/Apress.Pro.Oracle.SQL.Dec.2010.rar  选择SLOW DOWLOAD下载即可。

代码下载:http://www.apress.com/downloadable/download/sample/sample_id/170/


另一方面,学习环境最好是自己安装一个ORACLE 11g,机器不行的话装一个10g的Express版本的也好。关键的一点要有相关的schema,我也贴上,方便使用。


祝各位学习愉快。



  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Pro Oracle SQL unlocks the power of SQL in the Oracle Database—one of the most potent SQL implementations on the market today. To master it requires a three-pronged approach: learn the language features, learn the supporting features that Oracle provides to help use the language effectively, and learn to think and work in sets., , Karen Morton and her team help you master powerful aspects of Oracle SQL not found in competing databases. You’ll learn analytic functions, the MODEL clause, and advanced grouping syntax—techniques that will help in creating good queries for reporting and business intelligence applications. Pro Oracle SQL also helps you minimize parsing overhead, read execution plans, test for correct results, and exert control over SQL execution in your database. You’ll learn when to create indexes, how to verify that they make a difference, how to use SQL Profiles to optimize SQL in packaged applications, and much more. You’ll also understand how SQL is optimized for working in sets, and that the key to getting accurate results lies in making sure that queries ask clear and precise questions., , What’s the bottom-line? Pro Oracle SQL helps you work at a truly professional level in Oracle dialect of SQL. You’ll master the language, the tools to work effectively with the language, and the right way to think about a problem in SQL. Pro Oracle SQL helps you rise above the crowd to provide stellar service in your chosen profession. Endorsed by the OakTable Network, a group of Oracle technologists well-known for their rigorous and scientific approach to Oracle Database performance Comprehensive – goes beyond the language with a focus on what you need to know to write successful queries and data manipulation statements. What you'll learn Master powerful SQL features implemented only in Oracle Database Read and interpret SQL execution plans Quickly diagnose and fix badly performing SQL Control execution plans through hints, profiles, and plan baselines Optimize queries within packaged applications without touching the code Recognize when not to waste time on SQL that is performing optimally Who this book is for Pro Oracle SQL is aimed at developers and database administrators who submit SQL for execution by an Oracle database. Readers should already know the basic four SQL statements, and be ready to learn deeply about Oracle’s specific implementation of the language, including Oracle-specific features and syntax. Readers should also want to learn about Oracle Database features such as analytic queries, the MODEL clause, and subquery refactoring that are designed to help developers and DBAs exert control over their SQL environment and its execution.
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值