Amazon no longer offers textbook rentals. We do!

Sams Teach Yourself Microsoft SQL Server 7 in 10 Minutes

by: Robison, William; Robinson, William

Sams Teach Yourself Microsoft SQL Server 7 in 10 Minutes

by: Robison, William; Robinson, William

ISBN 13:
9780672316630
ISBN 10:
0672316633
Format: Paperback
Copyright: 08/01/1999
Publisher: Sams
Newer Edition

Rent

Sorry, this item is currently unavailable.

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Summary

Sams Teach Yourself Microsoft SQL Server 7 in 10 Minutes is a short but detailed reference to Microsoft SQL Server 7. This book brings together the most common commands and tasks that programmers and database administrators need to perform. Concise, goal-oriented lessons allow you to get up to speed quickly and efficiently. Application developers and administrators who are new to Microsoft SQL Server will learn to store, retrieve, and manipulate data in a Microsoft SQL Server database. This book serves as a reference guide even after you have become proficient.

Introduction

What Is SQL Server?

(6)

SQL Server Components

(2)

Database Elements

(3)

Summary

(1)

Understanding Databases

(10)

Tables

(7)

Constraints

(1)

Relations

(2)

Summary

(1)

Finding Information in the Database

(11)

Understanding Structured Query Language (SQL)

(1)

The SELECT Statement

(8)

Transact SQL Versus ANSI SQL92

(1)

Summary

(1)

Adding and Changing Data

(9)

Data Manipulation Language (DML)

(7)

Transactions

(1)

Summary

(1)

Using Data in Microsoft Word

(10)

Defining Your Query

(4)

Linking Data to Your Document

(3)

Printing the Results

(1)

Summary

(1)

Analyzing Numerical Data with Microsoft Excel

(9)

Defining Your Query

(5)

Using the Results

(3)

Summary

(1)

Including SQL Server Data in Your Microsoft Access Database

(10)

Linking Tables

(3)

Using Access for Reporting

(5)

Summary

(2)

Simple Web Publishing

(13)

How It Works

(1)

The IDC File

(2)

The HTX File

(4)

Using Parameters

(3)

Summary

(1)

Advanced Web Publishing

(13)

How It Works

(5)

Displaying Data

(6)

Summary

(1)

An Interactive Web Application

(16)

Deciding What to Do: Step by Step

(5)

Selecting a Publishing Method

(1)

Handling Updates

(1)

Guest Book Example

(8)

Summary

107

(1)

Improving Query Performance

108

(11)

Execution Plans

109

(5)

Index Analysis

114

(3)

Summary

117

(2)

Analyzing Your Data with SQL

119

(10)

Rollups and Summaries

119

(7)

Correlating Data with Subqueries

126

(2)

Summary

128

(1)

More SQL: Defining Data

129

(13)

Databases, Files, and File Groups

129

(2)

Data Definition Language Commands

131

(10)

Summary

141

(1)

Storing SQL in the Database

142

(11)

Creating Stored Procedures

143

(5)

Passing Parameters

148

(2)

Returning Results

150

(2)

Summary

152

(1)

Controlling How Changes Are Made

153

(7)

Working with Triggers

154

(3)

Managing Triggers

157

(1)

Special Tables: Inserted and Deleted

158

(1)

Summary

159

(1)

Simplifying Common Queries

160

(8)

Logical Versus Physical Data Model

161

(1)

Views of Logical Objects

162

(3)

Problems with Views

165

(1)

Summary

166

(2)

Managing Databases the Easy Way

168

(11)

Working in SQL Server Enterprise Manager

169

(2)

Creating Databases

171

(7)

Summary

178

(1)

Keeping Your Server Safe

179

(13)

Backing Up Your Database

179

(7)

Controlling Access

186

(5)

Summary

191

(1)

Monitoring Activity

192

(8)

Creating Traces

192

(5)

Saving and Replaying Captures

197

(2)

Summary

199

(1)

More Powerful Options for Moving Data

200

(9)

Choosing the Data Source and Destination

201

(4)

Transfer Scripts

205

(2)

For More Information About DTS

207

(1)

Summary

208

(1)

Index

209

Amazon no longer offers textbook rentals. We do!

Sams Teach Yourself Microsoft SQL Server 7 in 10 Minutes

Sams Teach Yourself Microsoft SQL Server 7 in 10 Minutes

9780672316630

0672316633

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

Sams Teach Yourself Microsoft SQL Server 7 in 10 Minutes

Sams Teach Yourself Microsoft SQL Server 7 in 10 Minutes

9780672316630

0672316633

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products