Introduction

Database solutions are integral to every organization that needs to store, analyze, and report on data. Microsoft SQL Server 2005 provides a robust platform for implementing your database solutions. SQL Server 2005 is packed with easy-to-use features that make it an ideal environment. In particular, this latest version of SQL Server is more secure, more scalable, and easier to use and manage than previous versions.

Microsoft SQL Server 2005: Database Essentials Step by Step is the first book in a series of two designed to help you build skills in a number of essential SQL Server areas. You can use this book if you are new to programming databases or if you are switching from another information storage system, such as Microsoft Office Access, or from a file-based storage system, such as .dbf or .txt files.

Inside, youll find information on which installation options to use in both a development and a production environment; which tools to use during your database design, database creation, and database objects definition; and what steps to take to retrieve and update data. The hands-on presentation of database skills will prepare you to move to the next level of SQL Server database management and to start applying the tools youve practiced in these chapters to your own work.

The second book in the series, Microsoft SQL Server 2005: Applied Techniques Step by Step , builds on the material presented in this book, with more extensive coverage of retrieving and analyzing data and of many features that make SQL Server 2005 such a comprehensive solution to your database needs.

Who This Book Is For

Microsoft SQL Server 2005: Database Essentials Step by Step is intended for developers and database administrators who want to begin using SQL Server 2005 as their main data repository and to use it not only as another file storage method, but also to enhance and speed their applications. By following the step-by-step procedures in each chapter, you will obtain a comprehensive, hands-on introduction to the most important options needed to program your database solutions using SQL Server 2005. Your skill level, job function, and familiarity with SQL Server will determine how this book will best serve you. See the chart in Finding Your Best Starting Point in This Book to determine how you can get what you need from this book.