did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9781861005236

Beginning SQL Server 2000 Programming

by
  • ISBN13:

    9781861005236

  • ISBN10:

    1861005237

  • Edition: CD
  • Format: Trade Paper
  • Copyright: 2001-06-28
  • Publisher: Springer-Verlag New York Inc
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
  • Write a Review Icon Write a Review
List Price: $49.99

Summary

SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system. This new release is tightly integrated with Windows 2000 and offers more support for XML, as well as improved Analysis Services. This book will take you through choosing which version of SQL Server 2000 to purchase, to installing SQL Server 2000 Developer Edition, starting up SQL Server 2000, on to creating an application. As the book progresses, a simple example application will be built taking you stage by stage, how the example is created and developed, in a clear, but simple manner that is easy to follow and understand. This book is for beginners interested in learning how to develop solutions with Microsoft SQL Server 2000 but have no prior knowledge of SQL Server 2000.

Table of Contents

Introduction 1(6)
SQL Server 2000 Installation
7(52)
Managing SQL Server
59(30)
Query Analyzer
89(48)
Database Analysis and Design
137(14)
Creating the Sample Database
151(38)
Defining Tables
189(40)
Creating Indexes
229(36)
Building Relationships
265(20)
Diagramming the Database
285(38)
Database Backups and Recovery
323(44)
Maintaining Your Database
367(20)
Inserting Data
387(32)
Retrieving Data
419(38)
Updating Data and Transactions
457(20)
Deleting Data
477(12)
Building a View
489(32)
Stored Procedures
521(34)
Advanced Stored Procedures
555(24)
XML and Data Retrieval
579(52)
Triggers
631(24)
Appendix A: Further References 655(20)
Appendix B: System Functions 675(14)
Appendix C: Function Listing 689(22)
Appendix D: Access Upsizing 711(8)
Appendix E: Security 719(8)
Appendix F: Glossary of Terms 727(16)
Appendix G: Support, Errata, and P2P.Wrox.Com 743(8)
Index 751

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program