Effective SQL: 61 Specific Ways to Write Better SQL

eBook Details:

• Paperback: 352 pages
• Publisher: WOW! eBook; 1st edition (December 30, 2016)
• Language: English
• ISBN-10: 0134578899
• ISBN-13: 978-0134578897

eBook Description:

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

Effective SQL: 61 Specific Ways to Write Better 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.