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
MySQL Clustering
Restarting a Cluster
RAM Usage
Management Nodes
Benchmarking
Logging Commands
Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference
Point-to-Point Protocol (PPP)
Internet Control Message Protocol (ICMP)
Transmission Control Protocol (TCP) Data Flow
Internet Protocol Security (IPSec)
Virtual Private Networks (VPNs)
The Complete Cisco VPN Configuration Guide
Summary
Summary
Concentrator Site-to-Site Connections
ISAKMP/IKE Phase 1 Preparation
Summary
Practical Intrusion Analysis: Prevention and Detection for the Twenty-First Century: Prevention and Detection for the Twenty-First Century
Crash Course in the Internet Protocol Suite
Unauthorized Activity II
Internet Security Systems RealSecure
Laws, Standards, and Organizations
Security Business Issues
Google Maps Hacks: Tips & Tools for Geographic Searching and Remixing
Hack 9. Use del.icio.us to Keep Up with Google Maps
Hack 15. Map a Slideshow of Your Travels
Hack 16. How Big Is the World?
Hack 29. Find the Best Gasoline Prices
Hack 51. Make a Fullscreen Map the Right Way
GO! with Microsoft Office 2003 Brief (2nd Edition)
Objective 5. Insert Frequently Used Text
Skill Assessments
Project 3A. Geography Lecture
Mastery Assessments
Objective 3. Create a Presentation Using a Design Template
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