Using Microsoft SQL server 6.5 /

Saved in:
Bibliographic Details
Other Authors: Branchek, Bob
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?