Flylib.com
The Art of SQL
The Art of SQL
ISBN: 0596008945
EAN: 2147483647
Year: N/A
Pages: 143
Authors:
Stephane Faroult
,
Peter Robson
BUY ON AMAZON
The Art of SQL
Table of Contents
The Art of SQL
Dedication
Preface
Why Another SQL Book?
Audience
Assumptions This Book Makes
Contents of This Book
Conventions Used in This Book
Using Code Examples
Comments and Questions
Safari Enabled
Acknowledgments
Chapter 1. Laying Plans
Section 1.1. The Relational View of Data
Section 1.2. The Importance of Being Normal
Section 1.3. To Be or Not to Be, or to Be Null
Section 1.4. Qualifying Boolean Columns
Section 1.5. Understanding Subtypes
Section 1.6. Stating the Obvious
Section 1.7. The Dangers of Excess Flexibility
Section 1.8. The Difficulties of Historical Data
Section 1.9. Design and Performance
Section 1.10. Processing Flow
Section 1.11. Centralizing Your Data
Section 1.12. System Complexity
Section 1.13. The Completed Plans
Chapter 2. Waging War
Section 2.1. Query Identification
Section 2.2. Stable Database Connections
Section 2.3. Strategy Before Tactics
Section 2.4. Problem Definition Before Solution
Section 2.5. Stable Database Schema
Section 2.6. Operations Against Actual Data
Section 2.7. Set Processing in SQL
Section 2.8. Action-Packed SQL Statements
Section 2.9. Profitable Database Accesses
Section 2.10. Closeness to the DBMS Kernel
Section 2.11. Doing Only What Is Required
Section 2.12. SQL Statements Mirror Business Logic
Section 2.13. Program Logic into Queries
Section 2.14. Multiple Updates at Once
Section 2.15. Careful Use of User-Written Functions
Section 2.16. Succinct SQL
Section 2.17. Offensive Coding with SQL
Section 2.18. Discerning Use of Exceptions
Chapter 3. Tactical Dispositions
Section 3.1. The Identification of
Section 3.2. Indexes and Content Lists
Section 3.3. Making Indexes Work
Section 3.4. Indexes with Functions and Conversions
Section 3.5. Indexes and Foreign Keys
Section 3.6. Multiple Indexing of the Same Columns
Section 3.7. System-Generated Keys
Section 3.8. Variability of Index Accesses
Chapter 4. Maneuvering
Section 4.1. The Nature of SQL
Section 4.2. Five Factors Governing the Art of SQL
Section 4.3. Filtering
Chapter 5. Terrain
Section 5.1. Structural Types
Section 5.2. The Conflicting Goals
Section 5.3. Considering Indexes as Data Repositories
Section 5.4. Forcing Row Ordering
Section 5.5. Automatically Grouping Data
Section 5.6. The Double-Edged Sword of Partitioning
Section 5.7. Partitioning and Data Distribution
Section 5.8. The Best Way to Partition Data
Section 5.9. Pre-Joining Tables
Section 5.10. Holy Simplicity
Chapter 6. The Nine Situations
Section 6.1. Small Result Set, Direct Specific Criteria
Section 6.2. Small Result Set, Indirect Criteria
Section 6.3. Small Intersection of Broad Criteria
Section 6.4. Small Intersection, Indirect Broad Criteria
Section 6.5. Large Result Set
Section 6.6. Self-Joins on One Table
Section 6.7. Result Set Obtained by Aggregation
Section 6.8. Simple or Range Searching on Dates
Section 6.9. Result Set Predicated on Absence of Data
Chapter 7. Variations in Tactics
Section 7.1. Tree Structures
Section 7.2. Representing Trees in an SQL Database
Section 7.3. Practical Implementation of Trees
Section 7.4. Walking a Tree with SQL
Section 7.5. Aggregating Values from Trees
Chapter 8. Weaknesses and Strengths
Section 8.1. Deceiving Criteria
Section 8.2. Abstract Layers
Section 8.3. Distributed Systems
Section 8.4. Dynamically Defined Search Criteria
Chapter 9. Multiple Fronts
Section 9.1. The Database Engine as a Service Provider
Section 9.2. Concurrent Data Changes
Chapter 10. Assembly of Forces
Section 10.1. Increasing Volumes
Section 10.2. Data Warehousing
Chapter 11. Stratagems
Section 11.1. Turning Data Around
Section 11.2. Querying with a Variable in List
Section 11.3. Aggregating by Range (Bands)
Section 11.4. Superseding a General Case
Section 11.5. Selecting Rows That Match Several Items in a List
Section 11.6. Finding the Best Match
Section 11.7. Optimizer Directives
Chapter 12. Employment of Spies
Section 12.1. The Database Is Slow
Section 12.2. The Components of Server Load
Section 12.3. Defining Good Performance
Section 12.4. Thinking in Business Tasks
Section 12.5. Execution Plans
Section 12.6. Using Execution Plans Properly
Section 12.7. What Really Matters?
PHOTO CREDITS
About the Author
Index
SYMBOL
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
The Art of SQL
ISBN: 0596008945
EAN: 2147483647
Year: N/A
Pages: 143
Authors:
Stephane Faroult
,
Peter Robson
BUY ON AMAZON
Building Web Applications with UML (2nd Edition)
Discussion
Architecture Activities
Gathering and Prioritizing Requirements
Analysis Model Classes
Use Case View
Cisco IOS Cookbook (Cookbooks (OReilly))
Debugging OSPF
Implementing Standards-Based Per-Hop Behavior
Classical IP Over ATM
Filtering by Source or Destination IP Address
Translating in Both Directions Simultaneously
Information Dashboard Design: The Effective Visual Communication of Data
Supplying Inadequate Context for the Data
Introducing Meaningless Variety
Encoding Quantitative Data Inaccurately
Understanding the Limits of Short-Term Memory
Sample Marketing Analysis Dashboard
Microsoft VBScript Professional Projects
Conditional Logic and Iterative Structures
Scheduling Disk Maintenance
Using Configuration Files to Control Script Execution
Developing a Setup Script
Reporting Application Summary Data via the Web
Comparing, Designing, and Deploying VPNs
Summary
Summary
Implementing Full Network Access Using the Cisco SSL VPN Client
VBScript in a Nutshell, 2nd Edition
VBScript Data Types: The Many Faces of the Variant
Error Handling and Debugging
Windows Script Host 5.6
Understanding the IE Object Model
Section C.1. Arithmetic Operators
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies