Sams Teach Yourself Microsoft SQL Server 7 in 10 Minutes

by Robison, William; Robinson, William

• ISBN13: 9780672316630
• ISBN10: 0672316633
• Format: Paperback
• Copyright: 1999-08-01
• Publisher: Sams

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.

Table of Contents

Introduction	ix
What Is SQL Server?	1	(6)
SQL Server Components	1	(2)
Database Elements	3	(3)
Summary	6	(1)
Understanding Databases	7	(10)
Tables	7	(7)
Constraints	14	(1)
Relations	14	(2)
Summary	16	(1)
Finding Information in the Database	17	(11)
Understanding Structured Query Language (SQL)	17	(1)
The SELECT Statement	18	(8)
Transact SQL Versus ANSI SQL92	26	(1)
Summary	27	(1)
Adding and Changing Data	28	(9)
Data Manipulation Language (DML)	28	(7)
Transactions	35	(1)
Summary	36	(1)
Using Data in Microsoft Word	37	(10)
Defining Your Query	38	(4)
Linking Data to Your Document	42	(3)
Printing the Results	45	(1)
Summary	46	(1)
Analyzing Numerical Data with Microsoft Excel	47	(9)
Defining Your Query	47	(5)
Using the Results	52	(3)
Summary	55	(1)
Including SQL Server Data in Your Microsoft Access Database	56	(10)
Linking Tables	56	(3)
Using Access for Reporting	59	(5)
Summary	64	(2)
Simple Web Publishing	66	(13)
How It Works	68	(1)
The IDC File	69	(2)
The HTX File	71	(4)
Using Parameters	75	(3)
Summary	78	(1)
Advanced Web Publishing	79	(13)
How It Works	80	(5)
Displaying Data	85	(6)
Summary	91	(1)
An Interactive Web Application	92	(16)
Deciding What to Do: Step by Step	92	(5)
Selecting a Publishing Method	97	(1)
Handling Updates	98	(1)
Guest Book Example	99	(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