Effective SQL: 61 Specific Ways to Write Better SQL

Effective SQL: 61 Specific Ways to Write Better SQL (Effective Software Development Series)
Authors: John L. Viescas – Douglas J. Steele – Ben G. Clothier
ISBN-10: 0134578899
ISBN-13: 9780134578897
Edition 版次: 1
Publication Date 出版日期: 2016-12-30
Print Length 页数: 352 pages
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. It’s the only modern book that brings together advanced best practices and realistic example code for all of these versions of SQL: IBM DB2,Microsoft Access,Microsoft SQL Server,MySQL,Oracle Database,and PostgreSQL.
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 SQL’s 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 don’t 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 can’t address with conventional JOINs
Model hierarchical data: managing SQL’s tradeoffs and shortcomings
Contents
Foreword
Acknowledgments
About the Authors
About the Technical Editors
Introduction
Chapter 1: Data Model Design
Chapter 2: Programmability and Index Design
Chapter 3: When You Can’t Change the Design
Chapter 4: Filtering and Finding Data
Chapter 5: Aggregation
Chapter 6: Subqueries
Chapter 7: Getting and Analyzing Metadata
Chapter 8: Cartesian Products
Chapter 9: Tally Tables
Chapter 10: Modeling Hierarchical Data
Appendix: Date and Time Types,Operations,and Functions

相关文件下载地址