ISBN.nu logo
isbn.nu
search for books and compare prices
Search >
Tables of Contents for Msde Bible
Chapter/Section Title
Page #
Page Count
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