Apress Windows 10 Release Sale

Pro SQL Server 2000 Database Design

Building Quality OLTP Databases

By Louis Davidson

  • eBook Price: $34.99 $20.99
  • Print Book Price: $49.99
Buy eBook Buy Print Book

Pro SQL Server 2000 Database Design Cover Image

This book's goal is to cover—from a "real-world" point of view—all of the essential elements in designing, modeling, and building efficient relational databases, while avoiding a dry, theoretical approach.

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-59059-302-8
  • 592 Pages
  • User Level: Beginner to Advanced
  • Publication Date: January 21, 2004
  • Available eBook Formats: PDF

Related Titles

  • SQL Server T-SQL Recipes
  • Energy Efficient Servers
  • Pro SQL Server Wait Statistics
  • Extending SSIS with .NET Scripting
  • Pro PowerShell for Database Developers
  • Healthy SQL
Full Description

Database design is one of the most contentious issues in computer science. There is always a delicate balance to be struck between the strict academic rules that govern the design of relational databases and the real-world techniques that programmers apply to get the job done in a certain time frame. This book's goal is to coverfrom a "real-world" point of viewall of the essential elements in designing, modeling, and building efficient relational databases, while avoiding a dry, theoretical approach.

Author Louis Davidson explains the process of implementing a database—from generating tables and allowing access to these tables using Microsoft SQL Server 2000. This includes tackling data modeling (focusing on the IDEF1X notation), requirements gathering, normalization (beyond the Third Normal Form), and implementing tables, constraints, triggers, procedures, user-defined functions, and so on. Davidson provides a full and realistic case study that clearly illustrates the entire process, from the initial discussions of a client's needs, through development of a logical model, to a complete implementation of the system.

Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

Please Login to submit errata.

No errata are currently published

Best-Sellers

    1. Pro T-SQL Programmer\'s Guide

      $41.99

      View Details

    2. Expert T-SQL Window Functions in SQL Server

      $17.99

      View Details

    3. Beginning SQL Server 2012 Administration

      $34.99

      View Details

    4. Business Intelligence with SQL Server Reporting Services

      $34.99

      View Details