Microsoft SQL Server 2000 provides enterprise-class database solutions, offering interactive development tools and complete management of your relational database applications.
In this book youll build a sample database with SQL Server and in the process learn how to design with solutions in mind. If you are migrating from a desktop solution such as Access to SQL Server, this book will provide you with clear and practical demonstrations of the relevant tasks at every stage in the process. Once youve mastered the basics of SQL Server, youll move on to learn more advanced techniques. By the end of this book, youll have a firm grasp of the most important SQL Server features and be able to develop your own effective database solutions.
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.