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

by
Edition: 2nd
Format: Paperback
Pub. Date: 2000-09-28
Publisher(s): McGraw-Hill Osborne Media
List Price: $57.04

Rent Textbook

Select for Price
There was a problem. Please try again later.

New Textbook

We're Sorry
Sold Out

Used Textbook

We're Sorry
Sold Out

eTextbook

We're Sorry
Not Available

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

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.

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.