- STAFF PICKS
- GIFTS + GIFT CARDS
- SELL BOOKS
- FIND A STORE
Beginning SQL Server 2000 Programmingby Robin Dewson
Synopses & Reviews
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.
Table of Contents
SQL Server 2000 Installation; Managing SQL Server; Query Analyzer; Database Analysis and Design; Creating the Sample Database; Defining Tables; Creating Indexes; Building Relationships; Diagramming the Database; Database Backups and Recovery; Maintaining Your Database; Inserting Data; Retrieving Data; Updating Data and Transactions; Deleting Data; Building a View; Stored Procedures; Advanced Stored Procedures; XML and Data Retrieval; 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.
What Our Readers Are Saying
Other books you might like
Computers and Internet » Database » Design