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
Inside Network Security Assessment: Guarding Your IT Infrastructure
Process for Assessing Risk
Best Practices for Quantitative and Qualitative Risk Assessment
Level II Assessment Forms
Recommendations
Appendix D. Dealing with Consultants and Outside Vendors
The Complete Cisco VPN Configuration Guide
IPsec
WebVPN Remote Access
Summary
Router Product Overview
Easy VPN Server Support for 7.0
C++ How to Program (5th Edition)
Summary
Self-Review Exercises
Exercises
F.10. Wrap-Up
J.13. More Complex XHTML Forms
Google Maps Hacks: Tips & Tools for Geographic Searching and Remixing
Hack 31. Navigate Public Transportation
Hacks 4250: Introduction
Hack 44. You Got Your A9 Local in My Google Maps!
Hack 45. Share Pictures with Your Community
Hack 53. Add Flash Applets to Your Google Maps
Microsoft WSH and VBScript Programming for the Absolute Beginner
Overview of the Windows Script Host
VBScript Basics
Conditional Logic
Appendix B Built-In VBScript Functions
Appendix C Whats on the CD-ROM?
Microsoft Office Visio 2007 Step by Step (Step By Step (Microsoft))
Customizing the Visio Environment
Key Points
Key Points
Importing Data to Create Organization Charts
Creating Scaled Office Spaces
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