Skip to main content

Microsoft® SQL Server® 2000 For Dummies®

Microsoft® SQL Server® 2000 For Dummies®

Anthony T. Mann

ISBN: 978-0-764-50775-5

Jan 2001

408 pages

Select type: Paperback

Product not available for purchase


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.

PART I: An Introduction to Microsoft SQL Server 2000.

Chapter 1: What's New with You? New Features in SQL Server 2000.

Chapter 2: A Quick Tour of Microsoft SQL Server 2000 Tools.

PART II: Database Design.

Chapter 3: Understanding the Relational Data Model.

Chapter 4: Creating Base-Level SQL Server Objects.

Chapter 5: Creating Advanced SQL Server Objects.

Chapter 6: Programming SQL Server 2000.

Chapter 7: Fun with Stored Procedures.

PART III: Interface Design.

Chapter 8: Making Microsoft SQL Server 2000 Work by Using SQL.

Chapter 9: Now That I Have a Structure, How Do I Use It?

Chapter 10: Maintaining Flexibility by Importing and Exporting Data.

PART IV: Enterprise Issues.

Chapter 11: Preventing the Inevitable Disaster (Losing Data).

Chapter 12: So You Want to Be Published.

Chapter 13: Distributed Queries.

PART V: Administrative Issues.

Chapter 14: Using Jobs and Alerts to Make SQL Server Work for You.

Chapter 15: Maintenance Plans.

PART VI: The Parts of Tens.

Chapter 16: Ten Microsoft SQL Server Resources.

Chapter 17: Ten Popular Ways to Give SQL Server More Pizzazz.

PART VII: Appendixes.

Appendix A: Wizard Flowcharts.

Appendix B: About the CD.


End-User License Agreement.

Installation Instructions.

Book Registration Information.

View the Bonus Material

View the Bonus Material for this title.