SQL Server 2000 Design and T-SQL Programming

SQL Server 2000 Design and T-SQL Programming

by Michelle Poolet, Michael Poolet, Michelle Reilly, Michelle Poolet
     
 
Build the best SQL Server 2000 database solution for your organization. This book explains how to design a robust,scalable SQL Server 2000 database model,planning for business requirements,data integrity,and security. You'll learn to write queries and develop custom reports and views and create stored procedures,functions,and triggers in T-SQL.

Overview

Build the best SQL Server 2000 database solution for your organization. This book explains how to design a robust,scalable SQL Server 2000 database model,planning for business requirements,data integrity,and security. You'll learn to write queries and develop custom reports and views and create stored procedures,functions,and triggers in T-SQL.

Design,develop,implement,and optimize a SQL Server 2000 database that meets your company's needs.

SQL Server 2000 Design and T-SQL Programming explains how to plan and build a database from the ground up in SQL Server 2000. You'll start with data modeling and database design and then you'll implement your database plan. Next,you'll learn to query the database,generate reports,and create custom views. Then,it's on to data integrity,triggers,stored procedures,and distributed data topologies. Throughout the book,you'll follow a real-world business model that demonstrates a SQL Server 2000 database plan in action.

  • Plan and design an SQL Server 2000 database
  • Map an entity-relationship diagram to a database table architecture
  • Create tables and load data into your database
  • Write queries and use the Query Analyzer Window
  • Combine data from multiple tables using joins and subqueries
  • Write summary reports which aggregate data and group by common values
  • Create custom views
  • Write transaction control statements and locking schemes
  • Handle performance tuning and optimization
  • Create stored procedures and triggers
  • Manage distributed database queries and transactions

Product Details

ISBN-13:
9780072123753
Publisher:
McGraw-Hill Professional
Publication date:
12/29/2000
Series:
Database Professional's Library
Pages:
612
Product dimensions:
7.36(w) x 9.02(h) x 1.66(d)

Read an Excerpt

Chapter 1: Database Design

SQL Server is a relational database management system (RDBMS). In a relational database, data is stored in tables, each of which contains information about an object in the database. A table is a two-dimensional grid consisting of rows and columns, sometimes referred to as records and fields. A column or field contains data about some attribute of the object, such as the name of a customer, the color of a product, or the date of a sale. A row or record represents one instance of the object, such as a customer, an invoice, or a product.

In a relational database, there is no structure imposed on the data by the database or the database software. All the structure comes from the relationships you define between the tables. The relationships describe how the objects in the database interact. The relational database provides a set of tools to help you safeguard and maintain these relationships. For example, once you have defined the relationship between customers and invoices, the database can prevent you from deleting a customer who has an outstanding invoice.

A relational database also safeguards your data by employing transaction logging. This means that whenever a change is made to data stored in the database, the change is first written to a transaction log. Only then is the change made to the actual data. If the system were to crash during the change, SQL Server can complete or cancel the change entirely by referring to the transaction log. The data will never be left in an inconsistent state. As you develop applications in SQL Server 2000, keep in mind that how you program can impact the performance of the transaction log. Transaction loggingcannot be turned off-logging change is inherent to a relational database.

A Brief Summary Of The Development Of The Relational Da

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >