Pro SQL Server 2012 Relational Database Design and Implementation

Table of contents

1. Title Page
2. Dedication
3. Contents at a Glance
4. Contents
5. Foreword
6. About the Author
7. About the Technical Reviewer
8. Acknowledgments
9. Introduction
10. CHAPTER 1: The Fundamentals
    1. Taking a Brief Jaunt Through History
    2. Recognizing Relational Data Structures
    3. Understanding Relationships
    4. Understanding Dependencies
    5. Relational Programming
    6. Outlining the Database-Specific Project Phases
    7. Summary
11. CHAPTER 2: Introduction to Requirements
    1. Documenting Requirements
    2. Gathering Requirements
    3. Interviewing Clients
    4. Asking the Right Questions
    5. Working with Existing Systems and Prototypes
    6. Utilizing Other Types of Documentation
    7. Following Best Practices
    8. Summary
12. CHAPTER 3: The Language of Data Modeling
    1. Introducing Data Modeling
    2. Entities
    3. Attributes
    4. Relationships
    5. Descriptive Information
    6. Alternative Modeling Methodologies
    7. Best Practices
    8. Summary
13. CHAPTER 4: Initial Data Model Production
    1. Example Scenario
    2. Identifying Entities
    3. Relationships between Entities
    4. Identifying Attributes and Domains
    5. Identifying Business Rules
    6. Identifying Fundamental Processes
    7. The Intermediate Version of the Logical Model
    8. Best Practices
    9. Summary
14. CHAPTER 5: Normalization
    1. The Process of Normalization
    2. Table and Column Shape
    3. Relationships Between Columns
    4. Surrogate Keys Effect on Dependency
    5. Tables with Multiple Meanings
    6. Denormalization
    7. Best Practices
    8. Summary
    9. The Story of the Book So Far
15. CHAPTER 6: Physical Model Implementation Case Study
    1. Choosing Names
    2. Choosing Key Implementation
    3. Determining Domain Implementation
    4. Setting Up Schemas
    5. Adding Implementation Columns
    6. Using DDL to Create the Database
    7. Unit Testing Your Structures
    8. Best Practices
    9. Summary
16. CHAPTER 7: Data Protection with Check Constraints and Triggers
    1. Check Constraints
    2. DML Triggers
    3. Dealing with Triggers and Constraints Errors
    4. Best Practices
    5. Summary
17. CHAPTER 8: Patterns and Anti-Patterns
    1. Desirable Patterns
    2. Images, Documents, and Other Files, Oh My
    3. Anti-Patterns
    4. Summary
18. CHAPTER 9: Database Security and Security Patterns
    1. Database Access Prerequisites
    2. Database Securables
    3. Controlling Access to Data via T-SQL-Coded Objects
    4. Crossing Database Lines
    5. Obfuscating Data
    6. Monitoring and Auditing
    7. Best Practices
    8. Summary
19. CHAPTER 10: Table Structures and Indexing
    1. Physical Database Structure
    2. Indexes Overview
    3. Basic Index Structure
    4. Index Types
    5. Basics of Index Creation
    6. Basic Index Usage Patterns
    7. Index Usage Scenarios
    8. Index Dynamic Management View Queries
    9. Best Practices
    10. Summary
20. CHAPTER 11: Coding for Concurrency
    1. What Is Concurrency?
    2. OS and Hardware Concerns
    3. Transactions
    4. Isolating Sessions
    5. Coding for Integrity and Concurrency
    6. Best Practices
    7. Summary
21. CHAPTER 12: Reusable Standard Database Components
    1. Numbers Table
    2. Calendar Table
    3. Utility Objects
    4. Logging Objects
    5. Other Possibilities...
    6. Summary
22. CHAPTER 13: Considering Data Access Strategies
    1. Ad Hoc SQL
    2. Stored Procedures
    3. T-SQL and the CLR
    4. Best Practices
    5. Summary
23. CHAPTER 14: Reporting Design
    1. Reporting Styles
    2. Requirements-Gathering Process
    3. Dimensional Modeling for Analytical Reporting
    4. Analytical Querying
    5. Summary Modeling for Aggregation Reporting
    6. Aggregation Querying
    7. Summary
24. Appendix A
25. Appendix B
26. Index