Home Page Icon
Home Page
Table of Contents for
Cover
Close
Cover
by Jessica M. Moss, Louis Davidson
Pro SQL Server 2012 Relational Database Design and Implementation
Title Page
Dedication
Contents at a Glance
Contents
Foreword
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
CHAPTER 1: The Fundamentals
Taking a Brief Jaunt Through History
Recognizing Relational Data Structures
Understanding Relationships
Understanding Dependencies
Relational Programming
Outlining the Database-Specific Project Phases
Summary
CHAPTER 2: Introduction to Requirements
Documenting Requirements
Gathering Requirements
Interviewing Clients
Asking the Right Questions
Working with Existing Systems and Prototypes
Utilizing Other Types of Documentation
Following Best Practices
Summary
CHAPTER 3: The Language of Data Modeling
Introducing Data Modeling
Entities
Attributes
Relationships
Descriptive Information
Alternative Modeling Methodologies
Best Practices
Summary
CHAPTER 4: Initial Data Model Production
Example Scenario
Identifying Entities
Relationships between Entities
Identifying Attributes and Domains
Identifying Business Rules
Identifying Fundamental Processes
The Intermediate Version of the Logical Model
Best Practices
Summary
CHAPTER 5: Normalization
The Process of Normalization
Table and Column Shape
Relationships Between Columns
Surrogate Keys Effect on Dependency
Tables with Multiple Meanings
Denormalization
Best Practices
Summary
The Story of the Book So Far
CHAPTER 6: Physical Model Implementation Case Study
Choosing Names
Choosing Key Implementation
Determining Domain Implementation
Setting Up Schemas
Adding Implementation Columns
Using DDL to Create the Database
Unit Testing Your Structures
Best Practices
Summary
CHAPTER 7: Data Protection with Check Constraints and Triggers
Check Constraints
DML Triggers
Dealing with Triggers and Constraints Errors
Best Practices
Summary
CHAPTER 8: Patterns and Anti-Patterns
Desirable Patterns
Images, Documents, and Other Files, Oh My
Anti-Patterns
Summary
CHAPTER 9: Database Security and Security Patterns
Database Access Prerequisites
Database Securables
Controlling Access to Data via T-SQL-Coded Objects
Crossing Database Lines
Obfuscating Data
Monitoring and Auditing
Best Practices
Summary
CHAPTER 10: Table Structures and Indexing
Physical Database Structure
Indexes Overview
Basic Index Structure
Index Types
Basics of Index Creation
Basic Index Usage Patterns
Index Usage Scenarios
Index Dynamic Management View Queries
Best Practices
Summary
CHAPTER 11: Coding for Concurrency
What Is Concurrency?
OS and Hardware Concerns
Transactions
Isolating Sessions
Coding for Integrity and Concurrency
Best Practices
Summary
CHAPTER 12: Reusable Standard Database Components
Numbers Table
Calendar Table
Utility Objects
Logging Objects
Other Possibilities...
Summary
CHAPTER 13: Considering Data Access Strategies
Ad Hoc SQL
Stored Procedures
T-SQL and the CLR
Best Practices
Summary
CHAPTER 14: Reporting Design
Reporting Styles
Requirements-Gathering Process
Dimensional Modeling for Analytical Reporting
Analytical Querying
Summary Modeling for Aggregation Reporting
Aggregation Querying
Summary
Appendix A
Appendix B
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Title Page
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset