Skip to main content
SpringerLink
Log in
Apress
Book cover

Pro SQL Server 2012 Relational Database Design and Implementation

  • Book
  • © 2012

Overview

Authors:
  1. Louis Davidson
    View author publications

    You can also search for this author in PubMed   Google Scholar

  2. Jessica M. Moss
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Pro SQL Server 2012 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database.

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 44.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (14 chapters)

  1. Front Matter

    Pages i-xxxi
    Download chapter PDF

  2. The Fundamentals

    • Louis Davidson, Jessica M. Moss
    Pages 1-36

  3. Introduction to Requirements

    • Louis Davidson, Jessica M. Moss
    Pages 37-51

  4. The Language of Data Modeling

    • Louis Davidson, Jessica M. Moss
    Pages 53-90

  5. Initial Data Model Production

    • Louis Davidson, Jessica M. Moss
    Pages 91-128

  6. Normalization

    • Louis Davidson, Jessica M. Moss
    Pages 129-167

  7. Physical Model Implementation Case Study

    • Louis Davidson, Jessica M. Moss
    Pages 169-243

  8. Data Protection with Check Constraints and Triggers

    • Louis Davidson, Jessica M. Moss
    Pages 245-299

  9. Patterns and Anti-Patterns

    • Louis Davidson, Jessica M. Moss
    Pages 301-369

  10. Database Security and Security Patterns

    • Louis Davidson, Jessica M. Moss
    Pages 371-443

  11. Table Structures and Indexing

    • Louis Davidson, Jessica M. Moss
    Pages 445-503

  12. Coding for Concurrency

    • Louis Davidson, Jessica M. Moss
    Pages 505-561

  13. Reusable Standard Database Components

    • Louis Davidson, Jessica M. Moss
    Pages 563-593

  14. Considering Data Access Strategies

    • Louis Davidson, Jessica M. Moss
    Pages 595-638

  15. Reporting Design

    • Louis Davidson, Jessica M. Moss
    Pages 639-670

  16. Back Matter

    Pages 671-751
    Download chapter PDF
Back to top

About this book

Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2012 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, Louis Davidson shows how to “get it right” in SQL Server database design and lay a solid groundwork for the future use of valuable business data.

  • Gives a solid foundation in best practices and relational theory
  • Covers the latest implementation features in SQL Server
  • Takes you from conceptual design to an effective, physical implementation

About the authors

Louis Davidson has been in the IT industry for more than 15 years as a corporate database developer and architect. He has spent the majority of his career working with Microsoft SQL Server, beginning from the early days of version 1.0. He has a bachelor s degree from the University of Tennessee at Chattanooga in computer science, with a minor in mathematics. Louis is the data architect for Compass Technology (Compass.net) in Chesapeake, Virginia, leading database development on their suite of nonprofit oriented CRM products, built on the Microsoft CRM platform and SQL Server technologies.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation