Using Microsoft SQL server 6.5 /
Saved in:
| Other Authors: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Indianapolis, Ind. :
Que,
c1996.
|
| Edition: | Special ed. |
| Subjects: |
Table of Contents:
- 1. Introducing Microsoft SQL Server
- 2. Data Modeling and Database Design
- 3. Understanding the Underlying Operating System, Windows NT
- 4. Creating Devices, Databases, and Transaction Logs
- 5. Creating Database Tables and Using Datatypes
- 6. Retrieving Data with Transact-SQL
- 7. Performing Operations on Tables
- 8. Using Functions
- 9. Managing and Using Views
- 10. Managing and Using Indexes and Keys
- 11. Managing and Using Rules and Defaults
- 12. Understanding Transactions and Locking
- 13. Managing Stored Procedures and Using Flow-Control Statements
- 14. Creating and Managing Triggers
- 15. Creating and Using Cursors
- 16. Understanding Server, Database, and Query Options
- 17. Optimizing Performance
- 18. SQL Server Administration
- 19. SQL Server Security
- 20. Setting Up and Managing Replication
- 21. Communicating with SQL Server
- 22. Accessing SQL Server Databases Through Front-End Products.
- App. A. Installation and Setup of the Client and Server Software
- App. B. SQL Server and Web pages
- App. C. Using SQL Trace
- App. D. Redundant Arrays of Inexpensive Drives (RAID)
- App. E. Case Study: New York Metropolitan Museum of Art
- App. F. What's on the CD?