Mastering SQL Server 2000 (eBook)

Mike Gunderloy, an MCSE, MCSD, and MCT, is a seniorconsultant with MCW Technologies, where he specializes in MicrosoftVisual Basic and SQL Server. He is the author of SQL Server 7 InRecord Time,Visual Basic Developer's Guide to ADO, andVB/VBA Developer's Guide to the Windows Installer, all fromSybex. Mike lives on a farm in rural Washington state with hisfamily and an ever-growing population of livestock.Joseph L. Jorden is an MCSE, MCT, CCNA, and CCDA who hasbeen administering databases for the last seven years. CurrentlyJoseph works independently, consulting and instructing on a varietyof technologies.

Introduction.PART I: INTRODUCING SQL SERVER.1. Introduction to SQL Server 2000.2. Overview of Database Concepts.3. Overview of SQL Server.4. Database Design and Normalization.PART II: TRANSACT-SQL.5. Transact-SQL Overview and Basics.6. SELECT Queries.7. Action Queries.8. Advanced Transact-SQL.PART III: DIGGING INTO SQL SERVER.9. Using SQL Server Enterprise Manager.10. Databases.11. Tables.12. Indexing.13. Views.14. Stored Procedures.15. Using Triggers.PART IV: ADMINISTERING SQL SERVER.16. Basic Administrative Tasks.17. Automating Administration.18. Security and SQL Server 2000.PART V: DEVELOPMENT WITH SQL SERVER.19. ADO and SQL Server.20. SQL-DMO.21. SQL Namespace.22. Data Transformation Services.23. The Web Assistant Wizard.24. Integrating SQL Server with Internet Information Server.PART VI: ADVANCED TOPICS.25. Locking.26. Monitoring and Optimizing SQL Server 2000.27. Replication.28. Analysis Services.29. Microsoft English Query.30. Troubleshooting.Appendix A: Transact-SQL Reference.Appendix B: Installing Microsoft SQL Server 2000.Index.