SQL Server 2000

Dusan Petkovic

663 pages, parution le 01/09/2000

Ajouter à une liste

Indisponible

Résumé

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.

Develop and deploy large-scale applications with SQL Server 2000. In this book,
database expert Dugan Petkovic explains how to use all the features of this powerful,
scaleable relational database management system. You'll learn to configure SQL
Server 2000, use T -SQL, execute efficient database queries, and enable secure
transactions. Troubleshooting, data warehousing, and optimization are also covered.
You'll find complete details on Microsoft Analysis Services, managing multiple
servers, maximizing uptime, and performance tuning. With SQL Server 2000:
A Beginner's Guide, your mission-critical database applications will be up and
running in no time!

Setup, manage, and customize SQL Server 2000
Administer multiple instances of SQL Server 2000 using the SQL Server
Perform simple and complex databse queries
Tune teh performance of your SELECT statements
Use SQL extensions, stores procedures, transactions, views, and triggers

Contents

Part I: SQL Server: Basic Concepts: 1: Database Systems and SQL Server; 2: SQL Server Enterprise Manager and Query Analyzer
Part II: Transact-SQL Language: 3: SQL Components; 4: Data Definition Language; 5: Simple Queries; 6: Complex Queries; 7: Modification of a Table's Contents; 8: SQL Extensions and Stored Procedures; 9: Views; 10: Indices and Query Optimization; 11: Systems Catalog; 12: SQL Server; 13: Triggers; 14: Transactions; 15: SQL Server System Environment
Part III: SQL Server Administration: 16: Overview of System Administration; 17: Planning and Completing the Installation of SQL Server; 18: Managing Database and Database Files; 19: Managing Security; 20: Backup and Recovery; 21: Data Transfer; 22: Automating System Administration Tasks; 23: Troubleshooting SQL Server; 24: Performance Tuning; 25: Data Replication
Part IV: Microsoft Decision Support Services: 26: Data Warehousing--An Introduction; 27: Client Components for MS Decision Support Services

L'auteur - Dusan Petkovic

Dusan Petkovic Is a professor in the Department of Computer Science at the Polytechnic in Rosenheim, Germany. He is the author of SQL Server 7: A Beginner's Guide and a frequent contributor to SQL Server magazine.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Mc Graw Hill
Auteur(s)	Dusan Petkovic
Parution	01/09/2000
Nb. de pages	663
Format	18,5 x 23,2
Couverture	Broché
Poids	1393g
Intérieur	Noir et Blanc
EAN13	9780072125870
ISBN13	978-0-07-212587-0