Effective SQL: 61 Specific Ways to Write Better SQL

相似文件 换一批

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

Effective SQL: 61 Specific Ways to Write Better SQL (Effective Software Development) by John L. Viescas
English | 20 Dec. 2016 | ISBN: 0134578899 | 352 Pages | AZW3/MOBI/EPUB/PDF (conv) | 90.53 MB
Effective SQL brings together practical solutions and insights so you can solve complex problems with SQL and design databases that simplify data management in the future.

Drawing on their immense experience as world-class database consultants and instructors, the authors identify 61 proven approaches to writing better SQL. Wherever SQL versions vary, the authors illuminate the key nuances, so you can get the most out of whatever version you prefer. This full-color guide provides clear, practical explanations; expert tips; and plenty of usable code. Going far beyond mere syntax, it addresses issues ranging from optimizing database designs to managing hierarchies and metadata. If you already know SQLs basics, this guide will help you become a world-class SQL problem-solver.

Craft better logical data models, and fix flawed models Implement indexes that improve query performance Handle external data from sources you dont control Extract and aggregate the information you need, as efficiently as possible Write more flexible subqueries Analyze and retrieve metadata using your database platform of choice Use Cartesian Products and Tally Tables to solve problems you cant address with conventional JOINs Model hierarchical data: managing SQLs tradeoffs and shortcomings
Given the authors reputations, I expected to be impressed. I was blown away! . . . Most SQL books sit on my shelf. This one will live on my desk.

“Roger Carlson, Microsoft Access MVP (2006-2015)

Rather than stumble around reinventing wheels or catching glimpses of the proper approaches, do yourself a favor: Buy this book.
”Dave Stokes, MySQL Community Manager, Oracle Corporation

本帖隐藏的内容

Effective SQL - 61 Specific Ways to Write Better SQL.rar (76.08 MB, 需要: 5 个论坛币) 本附件包括：

• Effective SQL - 61 Specific Ways to Write Better SQL.azw3
• Effective SQL - 61 Specific Ways to Write Better SQL.epub
• Effective SQL - 61 Specific Ways to Write Better SQL.mobi
• Effective SQL - 61 Specific Ways to Write Better SQL.pdf

2017-1-26 13:48:16 上传

需要: 5 个论坛币  [购买]

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏3 回帖

关键词：Effective Specific better Effect write experience management databases practical Software

thanks

thanks ...

kankan

好好学习，天天向上，新春快乐！

thanks