Sams Teach Yourself Microsoft SQL Server 7 in 21 Days

By Richard Waymire and Rick Sawtell

Welcome to Sams Teach Yourself Microsoft SQL Server 7.0 in 21 Days. We hope this book will help not only teach you about SQL Server but also prove valuable for everyday work involving SQL Server. We have worked hard to see that the skills you learn from this book will easily translate into real-world methods and solutions.

There are certain skills you need to successfully install, administer, troubleshoot, and configure SQL Server. The kinds of skills you must know can be divided into two general categories:

• SQL Server programmer
• SQL Server administrator

Note
In a small company, the developer, programmer, and administrator might be the same person; large companies usually have the functions separate.

A SQL Server developer is generally responsible for designing, programming, and populating the database. Sams Teach Yourself Transact-SQL in 21 Days is a great place to start for beginning SQL programmers. After the database has been created, responsibility for the database is often turned over to an administrator, who takes care of the ongoing maintenance.

A SQL Server administrator is usually responsible for the day-to-day administration of the database. This book is designed more for administrators, although many lessons apply to programmers as well. Although some administrators might never have to do any SQL programming, we have these lessons in enough detail so that administrators can begin to pick up on SQL programming if they want to. Programming tasks covered here relate to skills administrators might be called on to perform—such as creating tables, creating indexes, and writing complex queries.

Click to Read More