|
sybex.com
Table of Contents
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. |
