SQL Server 2000: A Beginner's Guide (Book/CD-ROM)

by Petkovic, Dusan

• ISBN13: 9780072125870
• ISBN10: 007212587X
• Edition: 2nd
• Format: Paperback
• Copyright: 2000-09-28
• Publisher: McGraw-Hill Osborne Media

Summary

Provides in-depth information on database systems and SQL Server 2000. Covers T-SQL language and its real-world application. Explains SQL Server Administration from managing database files to performing backup and recovery. Offers downloadable databases on the Osborne Web site. CD-ROM contains SQL Server 2000 Trial version.

Author Biography

Dusan Petrovic (Germany) is a professor in the Department of Computer Science at the Polytechnic in Rosenheim, Germany. He frequently contributes to SQL Server Magazine and has published 8 other computer books in Germany for Addison Wesley and McGraw-Hill.

Table of Contents

SQL Server: Basic Concepts.

Database Systems and SQL Server.

SQL Server Enterprise Manager and Query Analyzer.

Transact-SQL Language.

SQL Components.

Data Definition Language.

Simple Queries.

Complex Queries.

Modification of a Table's Contents.

SQL Extensions and Stored Procedures.

Views.

Indices and Query Optimization.

Systems Catalog.

SQL Server.

Triggers.

Transactions.

SQL Server System Environment.

SQL Server Administration.

Overview of System Administration.

Planning and Completing the Installation of SQL Server.

Managing Database and Database Files.

Managing Security.

Backup and Recovery.

Data Transfer.

Automating System Administration Tasks.

Troubleshooting SQL Server.

Performance Tuning.

Data Replication.

Microsoft Decision Support Services.

Data Warehousing--An Introduction.

Client Components for MS Decision Support Services.

Server Components in Microsoft Decisions Support Services.

A: SQL Server Keywords.

B: Answers.