“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 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. 
<ul>
<li>Craft better logical data models, and fix flawed models</li> <li>Implement indexes that improve query performance</li> <li>Handle external data from sources you don’t control</li> <li>Extract and aggregate the information you need, as efficiently as possible</li> <li>Write more flexible subqueries</li> <li>Analyze and retrieve metadata using your database platform of choice</li> <li>Use Cartesian Products and Tally Tables to solve problems you can’t address with conventional JOINs</li> <li>Model hierarchical data: managing SQL’s tradeoffs and shortcomings</li> </ul>

Effective SQL: 61 Specific Ways to Write Better SQL (Effective Software Development Series)

Computers & Technology

Viescas, John

Clothier, Ben

Steele, Douglas

Programming Languages

Addison-Wesley Professional

Authoritative and comprehensive coverage for building Access 2013 Solutions Access, the most popular database system in the world, just opened a new frontier in the Cloud. Access 2013 provides significant new features for building robust line-of-business solutions for web, client and integrated environments. This book was written by a team of Microsoft Access MVPs, with consulting and editing by Access experts, MVPs and members of the Microsoft Access team. It gives you the information and examples to expand your areas of expertise and immediately start to develop and upgrade projects. <ul>
<li>Explores the new development environment for Access web apps</li> <li>Focuses on the tools and techniques for developing robust web applications</li> <li>Demonstrates how to monetize your apps with Office Store and create e-commerce solutions</li> <li>Explains how to use SQL Server effectively to support both web and client solutions</li> <li>Provides techniques to add professional polish and deploy desktop application</li> <li>Shows you how to automate other programs using Macros, VBA, API calls and more.</li> </ul>
Professional Access 2013 Programming is a complete guide on the latest tools and techniques for building Access 2013 applications for both the web and the desktop so that developers and businesses can move forward with confidence. Whether you want to add expand your expertise with Client/Server deployments or start developing web apps, you will want this book as a companion and reference.

Professional Access 2013 Programming

Hennig, Teresa

Hepworth, George

Yudovich, Dagi (Doug)

Networking & Cloud Computing

Wrox

See the best price to sell, buy, or rent books by Clothier, Ben. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Clothier, Ben