What do you think?
Rate this book
Effective SQL: 61 Specific Ways to Write Better SQL
“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 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 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.
–Roger Carlson, Microsoft Access MVP (2006-2015)
“Rather than stumble around reinventing wheels or catching glimpses of the proper approaches, do yourself a 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 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.
- GenresProgramming
352 pages, Paperback
Published December 20, 2016
13 people are currently reading
78 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 of 1 review
September 28, 2020
This book, like way to many on my shelves, sat unread after I picked it up a few years ago. Upon retiring from IT work I thought I would never get through it. SQL is far from my favorite programming language, and only the insane would play with it. But never say never, my retirement ended about the same time COVID-19 started. I secured a part time SQL heavy job so I picked up Effective SQL again for the same reason I bought it in the first place. This is an excellent no fluff, wonderfully typeset, brief SQL book. I’ve used SQL on and off for twenty years but I still found things to learn here. If you SQL do yourself a favor and read this book.
Displaying 1 of 1 review