Complete SQL Server 7 Training Course

Complete SQL Server 7 Training Course

by Jeffry L. Byrne, Steve Correia, John Deep
     
 

ISBN-10: 0130868639

ISBN-13: 9780130868633

Pub. Date: 02/01/2000

Publisher: Prentice Hall

Ace your SQL Server 7 Exam! Total training for Planning, deployment & management!

  • Total interactive prep for Microsoft's SQL Server 7 exam (70-028)!
  • 80+ digital videos, 16 animations, 44 hours of expert audio annotations & hundreds of interactive exercises!
  • 100% Microsoft certified! More than a "cram guide"—your best

Overview

Ace your SQL Server 7 Exam! Total training for Planning, deployment & management!

  • Total interactive prep for Microsoft's SQL Server 7 exam (70-028)!
  • 80+ digital videos, 16 animations, 44 hours of expert audio annotations & hundreds of interactive exercises!
  • 100% Microsoft certified! More than a "cram guide"—your best resource for planning, implementing, and managing SQL Server 7!
  • Includes Self Test Software's suite of 16 interactive practice exams covering every MCSE course!

Now, in one awesome package, here's everything you need to pass your MCSE SQL Server exam (70-028) with flying colors! You get the #1 Site Server training CD-ROM, SQL Server 7 Multimedia Cyber Classroom—complete with 16 digital videos that walk you through key planning, deployment, configuration, management, security, and troubleshooting techniques you must know! Includes expert techniques for publishing SQL Server data on the Web! You'll find hours of expert audio commentary and hundreds of interactive exercises—plus a copy of MCSE: Administering Microsoft SQL Server 7, the industry's best prep book! Together, they'll prepare you faster and more effectively than you ever imagined!

Comes with MCSE: Administering Microsoft SQL Server 7—the industry's best prep guide!

Your total SQL Server 7 training resource—covers every exam objective!

  • Database planning, installation, and configuration
  • Day-to-day administration techniques
  • Maximizing integrity, consistency, and security
  • Publishing SQL Server 7 data on the Web
  • Replication planningand deployment

BONUS

Complete library of 16 Microsoft-certified practice exams! Get all the sample exams you need, no matter what MCSE exams you decide to take! This package includes sample exams for 16 MCSE courses, from the core exams to Networking Essentials, SQL Server 7 to TCP/IP, and beyond—all fully interactive, fully timed and scored—and 100% Microsoft-certified!

Product Details

ISBN-13:
9780130868633
Publisher:
Prentice Hall
Publication date:
02/01/2000
Edition description:
Book & CD-ROM
Pages:
567
Product dimensions:
7.48(w) x 9.72(h) x 2.76(d)

Table of Contents

Introduction xvii
PART ONE Microsoft SQL Server Overview 1(146)
An Overview of Microsoft SQL Server
3(36)
Microsoft SQL Server and Windows NT
4(1)
Windows NT Subsystems
4(1)
Windows 95/98
5(1)
Client/Server and Microsoft SQL Server
5(3)
Why Use SQL Applications?
8(5)
Ease of Use
9(1)
Simplify Systems
9(2)
Enforcement of Business Procedures
11(1)
Building Custom Applications
12(1)
Cost Factors
13(1)
Multiprocessing Versus Multithreaded
13(4)
Multiprocess Systems
14(1)
Multithreaded Systems
15(2)
Networking
17(4)
Protocol Options
17(1)
Local Area Networks
18(1)
Wide Area Networks
19(1)
Internet or Intranet
20(1)
Commonly Used SQL Server Interfaces
21(5)
Transact-SQL
21(1)
OLE DB
22(2)
ODBC
24(1)
Microsoft English Query
25(1)
Fundamental of Database Building
26(2)
The Relational Database
28(7)
What Is a Relational Database?
30(1)
The Normalized Database
31(2)
Tables, Columns, and Rows
33(1)
Device Independence
34(1)
Key Points
35(1)
Review Questions
36(3)
What Is SQL?
39(34)
T-SQL and Ansi-Sql
40(2)
Standards and Compatibility
41(1)
Types of Sql Commands
42(4)
Data Definition Language (Ddl)
42(2)
Data Manipulation Language (Dml)
44(1)
Data Control Language (Dcl)
45(1)
Commonly Used T-Sql Statements
46(20)
How to Use T-Sql Statements
46(5)
SELECT
51(10)
INSERT
61(3)
UPDATE
64(2)
DELETE
66(1)
Transactions and Sql
66(3)
Key Points
69(1)
Review Questions
69(4)
SQL Server Structure
73(48)
Creating a Database with Sql Server 7.0
74(3)
Compatibility with Earlier Devices
77(1)
Database Objects
78(39)
Tables
84(3)
Views
87(3)
Database Roles
90(1)
Defaults
90(4)
Rules
94(2)
Stored Procedures
96(4)
Triggers
100(4)
Cursors
104(3)
Indexes
107(9)
System Catalog
116(1)
Key Points
117(1)
Review Questions
118(3)
Microsoft Sql Server Components
121(26)
SQL Mail
122(2)
Database Maintenance Plans
124(5)
Processes
129(4)
Files
133(9)
master Database
134(1)
model Database
135(1)
msdb Database
136(1)
Sample Databases
137(1)
tempdb Database
138(1)
Log Files
138(3)
Web Files
141(1)
Key Points
142(1)
Review Questions
143(4)
PART TWO Installation and Configuration 147(68)
Installing Microsoft Sql Server 7.0
149(28)
Operating System Requirements
150(2)
Windows NT
151(1)
Windows 95/98
151(1)
Hardware Requirements
151(1)
Reqired User Acounts
152(2)
Running the Setup Application
154(13)
Full-Text Search Option
166(1)
Installation Options
167(3)
Network Installations
167(3)
Installing Sql Server Clients Tools
170(1)
Troubleshooting Setup
170(3)
Client Connections
172(1)
Key Points
173(1)
Review Questions
174(3)
Configuration Options
177(20)
Optimizing Memory Usage
178(2)
System Memory
178(2)
Monitoring and Profiling
180(10)
Performance Monitors
181(2)
The Profiler
183(1)
Allocating Memory
184(6)
Optimizing Disk Performance
190(2)
The Multithreaded Server
192(1)
Key Points
193(1)
Review Questions
194(3)
Startup and Shutdown
197(18)
Starting Microsoft Sql Server
198(6)
Using the Services Applet
198(1)
Using the SQL Server Enterprise Manager
199(2)
SQL Server Service Manager
201(1)
Using the Server Manager
202(1)
Using a Command Line Startup
203(1)
Options for Startup
204(1)
Troubleshooting Startup
205(5)
Using the SQL Server Error Log
206(2)
Using the Windows NT Event Viewer
208(1)
Viewing the Output Files
209(1)
Checking Named Pipes
210(1)
Key Points
210(1)
Review Questions
211(4)
PART THREE Planning and Managing Security 215(52)
Security
217(50)
Identification and Authentication
218(4)
Windows NT Security
219(1)
SQL Server Security
220(1)
Database Security
220(2)
Selecting the Type of Security
222(9)
Windows NT Authentication
223(6)
SQL Server Authentication
229(1)
Mixed Security
229(1)
Trusted Connections
230(1)
Setting Security Modes
230(1)
Creating Users
231(16)
Devising Usernames
232(4)
Passwords
236(1)
Guest User
237(1)
Using Roles
238(5)
Application Roles
243(1)
An Owner
243(4)
Using the Permissions System
247(11)
GRANTing Permission
248(3)
DENYing Permission
251(2)
REVOKE Permissions
253(1)
Permissions and the SQL Server Enterprise Manager
254(4)
Using the SQL Server SEcurity Wizard
258(3)
Security Between Linked Servers
261(2)
Key Points
263(1)
Review Questions
264(3)
PART FOUR Working with Database Files 267(62)
Managing Your Database Files
269(10)
The Relational Database
270(5)
The Normalized Database
271(3)
Tables, Columns, and Rows
274(1)
What Is a Relational Database?
275(1)
Device Independence
276(1)
Key Points
277(1)
Review Questions
277(2)
What Is Data Integrity?
279(24)
What Is Data Integrity?
280(1)
Entity Integrity
280(5)
Primary Key Constraint
280(4)
UNIQUE Constraints
284(1)
Using the uniqueidentifier Data Type
285(1)
Domain Integrity
285(9)
The DEFAULT Constraint
286(1)
Using the CHECK Constraint
287(2)
Domain Rules
289(1)
Datatypes
289(5)
Referential Integrity
294(4)
What Is Referential Integrity?
294(4)
User-Defined Integrity
298(2)
Key Points
300(1)
Review Questions
301(2)
Data Consistency and Concurrency
303(14)
Statements and Transactions
304(1)
Using Locks for Consistency
305(9)
Understanding a Lock
306(7)
Setting Transaction Isolation Level
313(1)
Key Points
314(1)
Review Questions
314(3)
Managing Database Space
317(12)
Planning Database Space Requirements
318(6)
Planning the Database
319(3)
Sizing the Log File
322(1)
Expanding a Database
323(1)
Shrinking a Database
324(1)
Delecting a Database
325(2)
Key Points
327(1)
Review Questions
327(2)
PART FIVE Transferring Data 329(48)
Planning Data Transfers
331(6)
Where Is the Data Now?
332(1)
What Kind of Data?
332(1)
Transforming Versusu Inserting Data
333(1)
Key Points
334(1)
Review Questions
335(2)
Metods of Transferring Data
337(40)
Using the Bulk Copy Program (bcp)
338(12)
Making a Database Ready for bcp
339(3)
Creating the bcp Format File
342(6)
Editing the bcp Format File
348(2)
Using Select Into Statements
350(2)
SQL Server Version Upgrade Wizard
352(2)
Data Transformation Services (Dts)
354(19)
What Is DTS?
355(12)
Scrubbing and Validating Data
367(1)
Creating a Data Warehouse
368(5)
Key Points
373(1)
Review Questions
373(4)
PART SIX Backing Up a Database 377(28)
Why Back Up Your Data
379(6)
Types of Failures
380(1)
Client Application Failure
380(1)
Program Failure
381(1)
Disk for Media Failures
381(1)
Key Points
382(1)
Review Questions
383(2)
Backing Up the Database
385(20)
Using Backups
386(3)
Forms of Backups
387(2)
Creating Your Backup Strategy
389(8)
Creating a Backup Device
390(2)
Performing a Backup
392(5)
Heavy Duty Protection---Mirrors and RAID
397(2)
RAID and Disk Arrays
398(1)
Using Removable Media
399(1)
SQL Server Failover Support
400(2)
Key Points
402(1)
Review Questions
402(3)
PART SEVEN Restoring Databases 405(12)
Restoring the Database
407(10)
Restoring a Database
408(4)
Restoring a Damaged Database
408(3)
Restoring Transaction Logs and Differential Backups
411(1)
Recovering the Master Database
412(2)
Key Points
414(1)
Review Questions
415(2)
PART EIGHT Monitoring Sql Server Performance 417(16)
Optimizing Performance
419(14)
Optimizing Queries
420(7)
Cost-Based Optimization
421(4)
Clustered Indexes
425(1)
Using Nonclustered Indexes
426(1)
Creatng Useful Indexes
426(1)
Other Performance-Tuning Factors
427(1)
Creatng Full-Text Search Indexes
428(2)
Key Points
430(1)
Review Questions
431(2)
PART NINE Automating Tasks 433(38)
The SQL Server Agent
435(14)
The Role of the SQL Server Agent
436(1)
Settng Up the SQL Srver Agent Service
436(2)
The SQL Server Agent Error Logs
438(1)
Multiserver Administration
439(7)
Creating the Multiserver Group
441(5)
Defecting a Target Server
446(1)
Key Points
446(1)
Review Questions
447(2)
Creating and Using Schedules
449(22)
Defining a Job
450(4)
Starting a Job Definition
450(2)
Defining the Steps of a Job
452(2)
Creating Schedules
454(7)
Using Notifications on a Job
457(4)
Troubleshooting Scheduling
461(1)
Stopping a Scheduled Job
461(1)
Using a Stored Procedure
462(1)
Using Alerts
462(6)
Setting Alerts
463(3)
Alert Responses
466(1)
Using a Stored Procedures with Alerts
467(1)
Removing an Alert
467(1)
Key Points
468(1)
Review Questions
468(3)
PART TEN Publishing Data on the Web 471(14)
Your Data and the Web
473(12)
The Web Assistant
474(8)
Key Points
482(1)
Review Questions
482(3)
PART ELEVEN Beginning Replication 485(14)
Replication Basics
487(12)
Replication Models
488(3)
Publisher
489(1)
Subscriber
489(1)
Replicated Data
489(2)
Push Versus Pull
491(1)
Types of Replication
491(4)
Snapshot Replication
493(1)
Transactional Replication
493(1)
Merge Replication
494(1)
Key Points
495(1)
Review Questions
496(3)
PART TWELVE Planning a Replication Strategy 499(26)
Planning and Setting Up a Replication Strategy
501(24)
Planning Replication
502(3)
What Information Needs to be Replicated
502(1)
Chossing a Replication Model
502(1)
When to Replicate
503(2)
Site Autonomy
505(1)
Who Can Subscribe?
505(1)
Setting Up Your Servers
506(8)
Setting Up a Publisher and Distributor
506(6)
Setting Up Subscribing Servers
512(2)
Replication and Synchronization
514(6)
Creating Articles and Publications
514(6)
Key Points
520(1)
Review Questions
521(4)
PART THIRTEEN Managing Replication and Distributed Transactions 525(18)
Replication Management
527(16)
Distributed Transactions
528(6)
Two-Phase Commit
528(1)
Definitions
529(1)
How the Two-Phase Commit Works
530(2)
Configuring MS Dtc
532(1)
Problem Areas
533(1)
Heterogeneous Replication
534(1)
Monitoring Replication
535(5)
Performance Monitoring Tools
535(3)
Troubleshooting Replication and Viewing Error Logs
538(2)
Key Points
540(1)
Review Questions
541(2)
Appendix: Answers to Chapter Review Questions 543(14)
Index 557

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >