9780764546815

Msde Bible

by ;
  • ISBN13:

    9780764546815

  • ISBN10:

    0764546813

  • Edition: CD
  • Format: Paperback
  • Copyright: 2000-12-01
  • Publisher: John Wiley & Sons 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
List Price: $49.99

Summary

Developers, programmers, software architects, technical managers, and technical support staff who work with MSDE (Microsoft Data Engine) applications will all benefit from this book, which guides you through everything from installation and configuration of MSDE to administration and deployment. Some of the topics covered in this reference include: the MSDE architecture; database structures; data retrieval and modification; database administration; securing MSDE applications; database monitoring and maintenance; and packaging SQL in stored procedures. The CD-ROM included with the book contains all the example code.

Table of Contents

Preface ix
Acknowledgment xiii
Part I: The MSDE Environment 1(78)
What is MSDE?
3(8)
MSDE Architecture
11(10)
Methods for Communicating with MSDE
21(30)
Preparing to Use MSDE
51(8)
Understanding Microsoft Object Models
59(20)
Part II: Database Structures 79(116)
Databases
81(22)
Using Tables to Store Data
103(22)
Ensuring Database Consistency
125(24)
Improving Performance with Indexes
149(24)
Locking: The Key to a Consistent Multiuser System
173(22)
Part III: Data Retrieval and Modification 195(70)
Retrieving Data with the Structured Query Language (SQL)
197(24)
Modifying Data with SQL
221(22)
Programming with SQL
243(22)
Part IV: Advanced Database Structures 265(76)
Enhancing Data Access with Views
267(18)
Packaging SQL in Stored Procedures
285(20)
Using Triggers to Enforce Data Integrity
305(18)
Accessing Data with Cursors
323(18)
Part V: Working with External Data 341(118)
Importing and Exporting Data
343(26)
Transforming Data With DTS
369(38)
Using Replication to Distribute Data
407(34)
Using Transactions to Distribute Data
441(18)
Part VI: Database Administration 459(150)
Controlling MSDE
461(16)
Backing Up and Restoring Data
477(26)
Accessing Data from Programs, Scripts, and Web Pages Using ADO and XML
503(20)
Administering Security
523(32)
Automating Tasks with SQL Agent
555(36)
Creating Web Pages
591(18)
Part VII: Database Monitoring, Maintenance, and Optimization 609(74)
Monitoring and Optimizing MSDE
611(26)
Maintaining Databases with DBCC
637(22)
Improving the Performance of Data Access
659(24)
Part VIII: Database Deployment 683(44)
MSDE Deployment Overview
685(8)
Deploying MSDE with Access Projects
693(18)
Deploying MSDE with Visual Studio Projects
711(16)
Appendix A: What's On the CD-ROM 727(2)
Index 729(31)
End-User License Agreement 760(4)
CD-ROM Installation Instructions 764

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