Special Edition Using Microsoft SQL Server 6.5 Second Edition
Table of Contents:
Introduction
Part I - Understanding The Basics
Chapter 1 - Introducing Microsoft SQL Server
Chapter 2 - Understanding the Underlying Operating System, Windows NT
Chapter 3 - Installing and Setting Up the Server and Client Software
Chapter 4 - Data Modeling, Database Design, and the Client/Server Model
Chapter 5 - Creating Devices, Databases, and Transaction Logs
Chapter 6 - Creating Database Tables and Using Datatypes
Part II - Up and Running with SQL Server
Chapter 7 - Retrieving Data with Transact-SQL
Chapter 8 - Adding, Changing, and Deleting Information in Tables
Chapter 9 - Using Functions
Chapter 10 - Managing and Using Views
Chapter 11 - Managing and Using Indexes and Keys
Chapter 12 - Understanding Transactions and Locking
Part III - Server-Side Logic and Capabilities
Chapter 13 - Managing and Using Rules, Constraints, and Defaults
Chapter 14 - Managing Stored Procedures and Using Flow-Control Statements
Chapter 15 - Creating and Managing Triggers
Chapter 16 - Understanding Server, Database, and Design Query Options
Chapter 17 - Setting Up and Managing Replication
Chapter 18 - Using the Distributed Transaction Coordinator
Part IV - SQL Server Administration Topics
Chapter 19 - SQL Server Administration
Chapter 20 - SQL Server Security
Chapter 21 - Optimizing Performance
Part V - Developing Applications and Solutions
Chapter 22 - Developing Applications to Work with SQL Server
Chapter 23 - Understanding SQL Server and the Internet
Chapter 24 - Creating and Using Cursors
Chapter 25 - Accessing SQL Server Databases Through Front-End Products
Chapter 26 - Upsizing Microsoft Office 97 Applications to SQL Server
Part VII - Appendixes
Appendix A - Mail-Enabling Your SQL Server
Appendix B - Understanding RAID
Appendix C - Understanding the SQL System Tables
Appendix D - Understanding SQL Trace
Appendix E - How to Become a Reality Check Site
Appendix F - Case Study: New York Metropolitan Museum of Art
Appendix G - Data Access Objects 3.5 API
Appendix H - What's On the CD?
©
Copyright
, Macmillan Computer Publishing. All rights reserved.