2000•McGraw-Hill, Inc. eBooksRequires access
SQL Server 2000: A Beginner's Guide (Book/CD-ROM)
Dusan Petrovic
Open publisher page 2 citations
Abstract
Build and manage SQL Server 2000 databases easily. Work with Transact-SQL and data definition language, and handle simple and complex queries. You'll also learn to use SQL extensions and stored procedures, views, triggers, and transactions.
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.