Home > Store

Effective SQL: 61 Specific Ways to Write Better SQL

Effective SQL: 61 Specific Ways to Write Better SQL

eBook (Watermarked)

  • Your Price: $28.79
  • List Price: $35.99
  • Estimated Release: Dec 23, 2016
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

Also available in other formats.

Register your product to gain access to bonus material or receive a coupon.


  • Copyright 2017
  • Dimensions: 7" x 9-1/8"
  • Pages: 320
  • Edition: 1st
  • eBook (Watermarked)
  • ISBN-10: 0-13-457913-5
  • ISBN-13: 978-0-13-457913-9

Effective SQL brings together the hands-on solutions and practical insights you need to solve a wide range of complex problems with SQL, and to design databases that make it far easier to manage data in the future. Leveraging the proven format of the best-selling Addison-Wesley Effective Software Development Series, it focuses on providing clear, practical explanations, expert tips, and plenty of realistic examples--all in full color.

Drawing on their immense experience as consultants and instructors, three world-class database experts identify specific challenges and distill each solution into five pages or fewer. Throughout, they provide practical SQL code designed for all leading platforms. Sample code includes specific examples for IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle Database, and PostgreSQL, wherever these vary or permit you to achieve your goal more efficiently.

Going beyond mere syntax, the authors also show how to avoid poor database design that makes it difficult to write effective SQL, how to improve suboptimal designs, and how to work around designs you can't change. You'll also find detailed sections on filtering and finding data, aggregation, subqueries, and metadata, as well as specific solutions for everything from listing products to scheduling events and defining data hierarchies. Simply put, if you already know the basics of SQL, Effective SQL will help you become a world-class SQL problem-solver.

Sample Content

Table of Contents



About the Authors

About the Technical Editors


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: Analyzing and Getting Metadata

Chapter 8: Cartesian Products

Chapter 9: Tally Tables

Chapter 10: Modeling Hierarchical Data

Appendix: Date and Time Types, Operations, and Functions



Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership