Beginning SQL Server 2000 Programming (Programmer to programmer) - Softcover

Dewson, Robin

Softcover

ISBN 10: 1861005237 ISBN 13: 9781861005236

Publisher: WROX Press Ltd, 2001

Synopsis

Microsoft SQL Server 2000 is the latest and most powerful version of a product that provides enterprise-class database solutions, offering interactive development tools and complete management of your relational database applications.

Beginning SQL Server 2000 Programming develops an example database, at every point providing clear and practical demonstrations of the relevant ideas. Once you have mastered the basics of SQL Server, this book will take you on to more advanced techniques to enable a firm grasp of the most important features quickly and easily, in order to develop your own effective database solutions straight away.

Included with this book is a 120-day Enterprise Evaluation edition of Microsoft SQL Server 2000. An end user license agreement is contained in this licensed software.

This book covers:
Choosing and installing the correct version of SQL Server 2000
The important tools used as an interface to SQL Server 2000
Basics of relational database design
Building the sample database for the book
Creating and deleting databases, tables, relationships, and indexes with the interactive tools of SQL Server, and through the Transact-SQL language
Maintaining, inserting, retrieving, and updating data
Managing transactions to safeguard data modifications
Using stored procedures to control the flow of execution of SQL statements
Using XML to retrieve data from SQL Server and publish this data to the Internet
Creating triggers to ensure data integrity
Includes 120-Day Enterprise Evaluation Edition of Microsoft SQL Server 2000

About this title

Review:

Aimed at those starting out with SQL Server databases as programmers or administrators, Beginning SQL Server 2000 Programming can put basic database skills into reach for readers of all levels. Packed with screenshots of how to use the relevant SQL Server tools and wizards, this book sets a high standard for accessibility for a tutorial text on Microsoft databases.

Most titles use screenshots to at least guide readers through installation of computer software and then turn to a more text-based presentation style later on. Not so with this text, which has several hundred screenshots used throughout showing SQL Server tools in action. After covering how to install and configure SQL Server (a trial edition is including on the accompanying CD), the author continues to show off tools like Enterprise Manager and Query Analyzer at work with plenty of step-by-step, hands-on tutorials with plentiful screenshots.

This book walks you through designing and creating a simple database (one that stores results for a golf league). In most every case, the author shows off using a tool alongside a more "manual" approach using SQL to get the job done. (For example, there's step-by-step coverage of how to create tables and indexes using Enterprise Manager, as well as how to do the same tasks using raw SQL in Query Analyzer.) Along the way, there is a solid tutorial to basic SQL for querying, inserting, updating, and deleting data, plus a good introduction to stored procedures and triggers. The strong sections on backing up and restoring databases are all you need to get started with basic database administration in SQL Server. Besides nuts-and-bolts DBA tasks, this book also offers a quick introduction to XML support available on the Microsoft database platform. The text closes with a handy listing of all T-SQL keywords, plus a guide to security options and settings available in SQL Server.

In all, this hands-on guide to database essentials can let you start effectively administering and programming with SQL Server regardless of your level of database experience. --Richard Dragan

From the Author:

This book is aimed at anyone who is starting out on SQL Server 2000, whether you know a previous database or not. Many people have commented that it is excellent if moving from Access for example. The U.S.The book is well paced and will not rush you through any of the topics and will enable you to be up and running developing SQL Server solutions very quickly. Every area for beginners is covered well with lots of examples enabling you to get to grips with this technology in a clear and concise manner.

About this edition

• Publisher: WROX Press Ltd
• Publication date: 2001
• ISBN 10: 1861005237
• ISBN 13: 9781861005236
• Binding: Paperback
• Edition number: 1
• Number of pages: 800