Microsoft SQL Server 2000 for Dummies - Softcover

Mann, A. T.

Softcover

ISBN 10: 0764507753 ISBN 13: 9780764507755

Publisher: For Dummies, 2001

Synopsis

Network administrators challenged with the task of building and deploying a network database can look to Microsoft SQL Server 2000 For Dummies for simple answers about a complex tool. Microsoft bills its SQL server as the best and fastest network database for NT-based networks and the Internet. Microsoft SQL Server 2000 For Dummies explores the processes and tasks involved with installing, configuring, and using the latest release of Microsoft SQL Server. This book explores designing SQL databases, scaling your server to handle the tasks you need, creating a database system to handle your business, and SQL's tight integration with other Microsoft networking and Internet management products including BackOffice and the rest of the Windows DNA 2000 suite. This book includes a CD that contains such software as IE 5.5, Vision Builder, Vision JADE and sp_Assist.

About this title

Review

Microsoft SQL Server 2000 has become standard equipment in lots of organizations, largely owing to its relatively friendly user interface on top of its solid infrastructure. That user interface, however, can intimidate users who are new to the environment and lack the experience to interpret what they see. Microsoft SQL Server 2000 for Dummies decodes this top-of-the-line relational database management system (RDBMS) for the benefit of such novices, as well as for people coming to SQL Server 2000 from one of its competitors. Anthony Mann does a fine job of explaining not only administrative matters, but also issues of database design, Structured Query Language (SQL), and integration of SQL Server databases into larger information systems.

The instructional style in this book varies depending on the subject at hand. When explaining subjects that are mostly conceptual in nature, such as relational database structure, Mann relies mainly on text and bulleted lists (and perhaps not enough on diagrams, which can really clarify these topics). When covering areas that have more to do with the specifics of SQL Server 2000--running Data Transformation Services (DTS) imports and exports, for instance--he employs steps (with options and alternate paths explained) and screen shots of the user interface. --David Wall

Topics covered: How to set up and maintain databases under SQL Server 2000, with some instruction in relational database design and Structured Query Language (SQL) thrown in. Databases, tables, keys, foreign keys, basic Transact-SQL, stored procedures, triggers, and administrative subjects like backup, restoration, and distributed databases are all covered.

From the Back Cover

Your fun and easy guide to building scalable databases

Get the lowdown on distributed queries and programming

Create a robust, Internet-ready database system--starting today!
With its new tools, wizards, services, and enhancements, the latest version of SQL Server is better -- and more complicated -- than ever. Relax! With SQL Server guru Anthony T. Mann at your side, you'll quickly pick up the know-how you need to build, deploy, and manage a scalable database system for your business or e-business.

Discover how to:
* Use SQL Server 2000 tools
* Design a multi-tier database
* Create tables and other database objects
* Work with SQL and the Query Analyzer
* Harness the DTS Import/Export Wizard
* Back up your data
all this on the bonus CD-ROM
Microsoft SQL Server 2000 120-day Enterprise Evaluation Edition

Get Smart! www.dummies.com
* Register to win cool prizes
* Browse exclusive articles and excerpts
* Get a free Dummies Daily e-mail newsletter
* Chat with authors and preview other books
* Talk to us, ask questions, get answers

Edition details

• Publisher: For Dummies
• Publication date: 2001
• ISBN 10: 0764507753
• ISBN 13: 9780764507755
• Binding: Paperback
• Language: English
• Number of pages: 384