Sorry, this item is currently unavailable.

Effective SQL 61 Specific Ways to Write Better SQL

ISBN: 9780134578897 | 0134578899
Edition: 1st
Format: Paperback
Publisher: Addison-Wesley Professional
Pub. Date: 12/23/2016

Why Rent from Knetbooks?

Because Knetbooks knows college students. Our rental program is designed to save you time and money. Whether you need a textbook for a semester, quarter or even a summer session, we have an option for you. Simply select a rental period, enter your information and your book will be on its way!

Top 5 reasons to order all your textbooks from Knetbooks:

  • We have the lowest prices on thousands of popular textbooks
  • Free shipping both ways on ALL orders
  • Most orders ship within 48 hours
  • Need your book longer than expected? Extending your rental is simple
  • Our customer support team is always here to help

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.

Please wait while this item is added to your cart...