Chapter 1: The SQL Server 2005 Environment and Tools


Overview

You already know that SQL Server 2005 is a full-featured and powerful database management system. You may also be experienced in some or many aspects of this system. But before you proceed to become an expert in application development using SQL Server stored procedures, we should probably take a step back and look at the big picture to ensure that we share the same conceptual grounding.

To attain this conceptual grounding, I will start with a 30,000-ft. overview that will cover the following topics:

  • A brief introduction to SQL Server 2005 tools

  • A quick overview of stored procedure and table design

I have written this overview to enable people who are in a hurry to learn the basics and then get down to developing complex stored procedures to retrieve, manipulate, update, and delete data, and to address a variety of business problems. I am going to assume that you have already had an opportunity to work with SQL as a language for making queries on SQL Server or some other database system, and that you understand common database concepts. The purpose of this overview is to define the terminology that you will use as the foundation on which to build your knowledge of programming in the SQL Server environment. If you need a more in-depth conceptual grounding than that offered here, I direct you to SQL Server 2005: A Beginner's Guide by Dušan Petković(McGraw-Hill/Osborne, 2005).

Note 

To those of you who find the material in this chapter excessively basic, I offer my apologies and suggest you skip ahead to the next chapter. However, if you have any doubts about whether you should skip ahead, don't. The information presented in the following pages may be basic, but it is extremely important that you have a full understanding of the fundamentals before you tackle the more complex topics built upon those basics.




Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL &  .NET
Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
ISBN: 0072262281
EAN: 2147483647
Year: 2006
Pages: 165

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net