- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
Microsoft SQL Server 2000 provides enterprise-class database solutions, offering interactive development tools and complete management of your relational database applications. In this book, you'll 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 you've mastered the basics of SQL Server, you'll move on to learn more advanced techniques. By the end of this book, you'll have a firm grasp of the most important SQL Server features and be able to develop your own effective database solutions.
Contents
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
