Special Edition Using Microsoft SQL Server 7.0

Special Edition Using Microsoft SQL Server 7.0

by Stephen Wynkoop

Paperback(BK&CD ROM)

$49.99

Temporarily Out of Stock Online

Eligible for FREE SHIPPING

Overview

Special Edition Using Microsoft SQL Server 7.0 by Stephen Wynkoop

SQL Server is a large, complex application that requires detailed coverage of many different kinds of tools, techniques and skills; SE Using SQL Server provides that coverage Focuses on three key SQL Server topic areas: database administration, system administration and application development Learn about Transact-SQL programming, server-side scripting and third-party tools for application development Learn to take advantage of SQL Server in an enterprise using DCOM, DTC (Distributed Transaction Coordinator) and MTS (Microsoft Transaction Server) Includes expanded coverage of web database programming, Active Server pages, IDC and ADC Internet technologies Special Reality Check elements provide feedback on how to apply SQL Server concepts to real-world situations

  • Comprehensive: Complete coverage of all the new SQL Server features and enhancements
  • Authoritative: Written by expert author Steve Wynkoop, founder and President of the World Wide SQL Server User s Group
  • Recommended: Presented as the recommended resource on SQL Server at Microsoft s 1997 Tech Ed conference

Product Details

ISBN-13: 9780789715234
Publisher: Pearson Education
Publication date: 01/22/1999
Series: Special Edition Using Series
Edition description: BK&CD ROM
Pages: 766
Product dimensions: 7.39(w) x 9.04(h) x 2.04(d)

Table of Contents

Introduction1
IUnderstanding the Basics
1Understanding Microsoft SQL Server 7.0 Fundamentals11
2Understanding the Underlying Operating System, Windows NT35
3Installing and Setting Up the Server and Client Software63
4Data Modeling and Database Design75
5Creating Database and Transaction Logs93
6Creating Database Tables and Using Datatypes113
IIUp and Running with SQL Server
7Retrieving Data with Transact-SQL155
8Adding, Changing, and Deleting Information in Tables193
9Using Functions227
10Managing and Using Views257
11Managing and Using Indexes and Keys287
12Understanding Transactions and Locking309
IIIServer-Side Logic and Capabilities
13Managing and Using Rules, Constraints, and Defaults333
14Managing Stored Procedures and Using Flow-Control Statements355
15Creating and Managing Triggers395
16Understanding Server, Database, and Query Options411
17Setting Up and Managing Replication443
18Using the Distributed Transaction Coordinator481
IVSQL Server Administration Topics
19SQL Server Administration495
20SQL Server Security519
21Optimizing Performance539
VDeveloping Applications and Solutions
22Backward Compatibility Options for Developers561
23Understanding SQL Server and the Internet577
24Creating and Using Cursors619
25Using the SQL Server Agent633
26Integrating Microsoft Office Applications and SQL Server657
27Using Advanced Data Objects with SQL Server 7.0673
Appendixes
AMail-Enabling Your SQL Server701
BRedundant Arrays of Inexpensive Disks715
CUnderstanding the SQL System Tables719
DUsing SQL Server Profiler725
Index733

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews