Mastering^TM SQL Server^TM 2000

by Mike Gunderloy; Joseph L. Jorden

• ISBN13: 9780782126273
• ISBN10: 0782126278
• Format: Paperback
• Copyright: 2000-10-01
• Publisher: Sybex

Summary

Complete. Authoritative. Practical. The only SQL Server book you need.Mastering SQL Server 2000 is the one indispensable resource for anyone working with the latest version of SQL Server. Whether you build or administer SQL Server databases or write applications that communicate with them, you'll find the background knowledge and the practical instruction you need to accomplish any task, from the most basic to the most advanced. Coverage includes: Understanding SQL Server architecture Designing an efficient normalized database Writing Transact-SQL statements and batches Creating databases Creating tables and views Creating stored procedures and triggers Administering SQL Server Managing SQL Server security Designing applications using ADO, SQL-DMO, and SQL-NS Using Data Transformation Services Integrating SQL Server with the Internet Optimizing SQL Server performance Understanding and managing replication Using Analysis Services to analyze data Using Microsoft English Query Troubleshooting common problems

Author Biography

Mike Gunderloy, an MCSE, MCSD, and MCT, is a senior consultant with MCW Technologies, where he specializes in Microsoft Visual Basic and SQL Server. He is the author of SQL Server 7 In Record Time,Visual Basic Developer's Guide to ADO, and VB/VBA Developer's Guide to the Windows Installer, all from Sybex. Mike lives on a farm in rural Washington state with his family and an ever-growing population of livestock.

Joseph L. Jorden is an MCSE, MCT, CCNA, and CCDA who has been administering databases for the last seven years. Currently Joseph works independently, consulting and instructing on a variety of technologies.

Table of Contents

Introduction	xxvii
PART I INTRODUCING SQL SERVER	1	(134)
Introduction to SQL Server 2000	3	(28)
Overview of Database Concepts	31	(30)
Overview of SQL Server	61	(44)
Database Design and Normalization	105	(30)
PART II TRANSACT-SQL	135	(170)
Transact-SQL Overview and Basics	137	(50)
Select Queries	187	(48)
Action Queries	235	(30)
Advanced Transact-SQL	265	(40)
PART III DIGGING INTO SQL SERVER	305	(266)
Using SQL Server Enterprise Manager	307	(62)
Databases	369	(36)
Tables	405	(42)
Indexing	447	(24)
Views	471	(36)
Stored Procedures	507	(30)
Using Triggers	537	(34)
PART IV ADMINISTERING SQL SERVER	571	(150)
Basic Administrative Tasks	573	(50)
Automating Administration	623	(52)
Security and SQL Server 2000	675	(46)
PART V DEVELOPMENT WITH SQL SERVER	721	(200)
ADO and SQL Server	723	(38)
SQL-DMO	761	(36)
SQL Namespace	797	(20)
Data Transformation Services	817	(40)
The Web Assistant Wizard	857	(24)
Integrating SQL Server with Internet Information Server	881	(40)
PART VI ADVANCED TOPICS	921	(198)
Locking	923	(22)
Monitoring and Optimizing SQL Server 2000	945	(34)
Replication	979	(68)
Analysis Services	1047	(32)
Microsoft English Query	1079	(22)
Troubleshooting	1101	(18)
Appendix A Transact-SQL Reference	1119	(10)
Appendix B Installing Microsoft SQL Server 2000	1129	(26)
Index	1155