Chapter 1: SQL Server 2000 Installation Chapter 2: Managing SQL Server Chapter 3: Query Analyzer Chapter 4: Database Analysis and Design Chapter 5: Creating the Sample Database Chapter 6: Defining Tables Chapter 7: Creating Indexes Chapter 8: Building Relationships Chapter 9: Diagramming the Database Chapter 10: Database Backups and Recovery Chapter 11: Maintaining Your Database Chapter 12: Inserting Data Chapter 13: Retrieving Data Chapter 14: Updating Data and Transactions Chapter 15: Deleting Data Chapter 16: Building a View Chapter 17: Stored Procedures Chapter 18: Advanced Stored Procedures Chapter 19: XML and Data Retrieval Chapter 20: Triggers Appendix A: Further References Appendix B: System Functions Appendix C: Function Listing Appendix D: Access Upsizing Appendix E: Security Appendix F: Glossary of Terms Appendix G: Support and Errata
Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at Fat-Belly.com.