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
Kanban Made Simple: Demystifying and Applying Toyotas Legendary Manufacturing Process
Conduct Data Collection
Appendix B Kanban Supermarkets
Appendix D Organizational Changes Required for Kanban
Appendix E EOQ vs. Kanban
Appendix I Case Study 2: Rubber Extrusion Plant
WebLogic: The Definitive Guide
A Closer Look at the Frontend Tier
Combined-Tier Architecture
Tuning WebLogic Applications
SSL
Using the SNMP Agent
MySQL Clustering
Configuration
Backup and Recovery
Common Setups
An Overview of Binary Options
Individual Programs
Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain
The Internationalization of the Retail Supply Chain
Fashion Logistics and Quick Response
Rethinking Efficient Replenishment in the Grocery Sector
The Development of E-tail Logistics
Transforming Technologies: Retail Exchanges and RFID
GO! with Microsoft Office 2003 Brief (2nd Edition)
Concepts Assessments
Performance Assessments
Problem Solving
Objective 12. Compare Data with a Line Chart
Chapter Four. Linking Data in Office Documents
.NET System Management Services
.NET Framework and Windows Management Instrumentation
Using the System.Management Namespace
Instrumenting .NET Applications with WMI
The WMI Schema
WMI Providers
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