The
Art of SQL is one of the most fabulous book of SQL. This Book is mainly for the
Professionals those who have a good command in SQL and at least familiar with one
computer language with the principles of computer.
Contents:-
Chapter 1, Laying Plans
Examines how to design databases for performance
Chapter 2, Waging War
Explains how programs must be designed to access databases efficiently
Chapter 3, Tactical Dispositions
Tells why and how to index
Chapter 4, Maneuvering
Explains how to envision SQL statements
Chapter 5, Terrain
Shows how physical implementation impacts performance
Chapter 6, The Nine Situations
Covers classic SQL patterns and how to approach them
Chapter 7, Variations in Tactics
Explains how to deal with hierarchical data
Chapter 8, Weaknesses and Strengths
Provides indications about how to recognize and handle some difficult cases
Chapter 9, Multiple Fronts
Describes how to face concurrency
Chapter 10, Assembly of Forces
Addresses how to cope with large volumes of data
Chapter 11, Stratagems
Offers a few tricks that will help you survive rotten database designs
Chapter 12, Employment of Spies
Concludes the book by explaining how to define and monitor performance
0 comments:
Post a Comment