《SQL袖珍参考手册(第3版)(SQLPocketGuide)》JonathanGennick文字版电子书

IT技能 adminlele 3年前 (2021-06-25) 893次浏览 已收录 0个评论

《SQL袖珍参考手册(第3版)(SQLPocketGuide)》JonathanGennick文字版电子书

内容简介



If you’re a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You’ll find many examples that address the language’s complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2. SQL Pocket Guide describes how these database systems implement SQL syntax for querying, managing transactions, and making changes to data. It also shows how the systems use SQL functions, regular expression syntax, and type conversion functions and formats. All example SQL statements in this book execute against a set of tables, with data that you can quickly download. The third edition covers important database changes, including: Oracle’s support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operators Functions new to Oracle, such as LISTAGG, NTH_VALUE, and more PostgreSQL’s support of recursive WITH and some window functions DB2 syntax and datatypes, some compatible with Oracle MySQL features such as the TIMESTAMP type and the TO_SECONDS function

SQL袖珍参考手册(第3版,涵盖DB2,MySQL,Oracle,PostgreSQL,SQL Server)》(SQL Pocket Guide: A Guide to SQL Usage)英文文字版/更新源代码[PDF]
If you’re a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You’ll find many examples that address the language’s complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2.

All example SQL statements in this book execute against a set of tables, with data that you can quickly download. The third edition covers important database changes, including:

Oracle’s support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operators
Functions new to Oracle, such as LISTAGG, NTH_VALUE, and more
PostgreSQL’s support of recursive WITH and some window functions
DB2 syntax and datatypes, some compatible with Oracle
MySQL features such as the TIMESTAMP type and the TO_SECONDS function

作者简介



Jonathan.Gennick

下载地址

 

http://xz.tbookk.com/f/560517-500519473-f4b261

《SQL袖珍参考手册(第3版)(SQLPocketGuide)》JonathanGennick文字版电子书此处内容已经被作者隐藏,请输入验证码查看内容
验证码:
请关注本站微信公众号,回复“验证码”,获取验证码。在微信里搜索“杰哥读书”或者“tbookk”或者微信扫描右侧二维码都可以关注本站微信公众号。


中信图书出版社全部书籍617本 百度网盘福利
西部数码域名服务器优惠券 老薛主机优惠券
请通过以下商城购买正版书籍
图书库 , 版权所有丨如未注明 , 均为原创丨本网站采用BY-NC-SA协议进行授权
转载请注明原文链接:《SQL袖珍参考手册(第3版)(SQLPocketGuide)》JonathanGennick文字版电子书本站电子书版权归原作者及开发商所有,仅限个人测试交流学习之用,请在下载后24小时内删除。若有违反您个人权益,请留言反馈删除相关信息。

喜欢 (0)
发表我的评论
取消评论
表情 贴图 加粗 删除线 居中 斜体 签到

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址