En savoir plus
Zusammenfassung This book is written for all levels of SQL Server users. It begins with an introduction to database design and basic SQL Server concepts! and then expands on those ideas to thoroughly explore the power of the product.
Table des matières
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.
