Flylib.com
Books
Software
Computers & Technology
Home Computing
Business & Culture
Programming
Software
Web Development
Certification
Networking
Security & Encryption
Computer Science
Operating Systems
Microsoft
Hardware
Databases
Graphic Design
Apple
Digital Music
Digital Photography & Video
Games & Strategy Guides
Project Management
Mobile & Wireless Computing
Education & Reference
Encyclopedias
Test Preparation
Studying & Workbooks
Schools & Teaching
Writing, Research & Publishing Guides
Foreign Language Study & Reference
Atlases & Maps
Dictionaries & Thesauruses
Words, Language & Grammar
College & University
Trivia & Fun Facts
Consumer Guides
Business & Investing
Industries & Professions
Management & Leadership
Organizational Behavior
Personal Finance
Small Business & Entrepreneurship
Popular Economics
Marketing & Sales
Finance
Skills
Business Life
Economics
Job Hunting & Careers
Biography & History
Reference
International
Real Estate
Investing
Women & Business
Science & Math
Mathematics
Technology
Reference
Earth Sciences
Physics
Biological Sciences
Behavioral Sciences
Nature & Ecology
Astronomy & Space Science
History & Philosophy
Experiments, Instruments & Measurement
Agricultural Sciences
Category list
Computers & Technology
Programming
Languages & Tools
XML
Category list
Databases
Relational Databases
Education & Reference
- page 1
Buy on amazon.com >>
Henderson K.
<< Previous book
Next page >>
1
2
3
Table of Content
Table of Content
Starting Page
Copyright
Foreword
Preface
Introduction
About the Sample Databases
Acknowledgments
About the Author
Part I: The Basics
Chapter 1. Stored Procedure Primer
What Is a Stored Procedure?
Stored Procedure Advantages
Creating a Stored Procedure
Altering Stored Procedures
Executing Stored Procedures
Extended Stored Procedures
Environmental Issues
Parameters
Flow Control Language
Errors
Nesting
Recursion
Summary
Chapter 2. Suggested Conventions
Source Formatting
Coding Conventions
Summary
Chapter 3. Common Design Patterns
The Law of Parsimony
Idioms
Design Patterns
Summary
Chapter 4. Source Code Management
The Benefits of Source Code Management
The dt Procedures
Best Practices
Version Control from Query Analyzer
Automating Script Generation with Version Control
Summary
Chapter 5. Database Design
General Approach
Modeling Tools
The Sample Project
The Five Processes
The Five Phases Examined
Modeling Business Processes
Entity-Relationship Modeling
Relational Data Modeling
Summary
Chapter 6. Data Volumes
Approaches to Generating Data
Speed
Summary
Part II: Objects
Chapter 7. Error Handling
Error Reporting
Handling Errors
Summary
Chapter 8. Triggers
Determining What Has Changed
Managing Sequential Values
Trigger Restrictions
INSTEAD OF Triggers
Triggers and Auditing
Transactions
Execution
Calling Stored Procedures
Nested Triggers
Disabling Triggers
Best Practices
Summary
Chapter 9. Views
Meta-data
Restrictions
ANSI SQL Schema Views
Updatable Views
The WITH CHECK OPTION Clause
Derived Tables
1
2
3
Buy on amazon.com >>
Henderson K.
<< Previous book
Next page >>