SQL Server 2000
The Complete Reference
Published on 8. December 2000
Book
Paperback/Softback
960 pages
978-0-07-212588-7 (ISBN)
Description
This volume covers basic to advanced topics, including the management and access of distributed data, as well as the creation and management of advanced online analytical processing (OLAP) systems.
More details
Series
Language
English
Place of publication
New York
United States
Publishing group
McGraw-Hill Education - Europe
Target group
College/higher education
Professional and scholarly
Illustrations
10 illustrations, index
Dimensions
Height: 235 mm
Width: 185 mm
Weight
1840 gr
ISBN-13
978-0-07-212588-7 (9780072125887)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Content
Introducing SQL Server 2000 system architecture: m architecture: SQL Server 2000, Windows 2000 and DNA; active directory services integration; installing and upgrading SQL Server; configuration; planning for SQL Server 2000. SQL Server 2000 DBA: SQL Server administration; SQL Server agent; managing databases; managing tables and indexes; SQL Server security; SQL Server connectivity; disaster recovery; import and export; performance tuning and optimisation. SQL Server 2000 development: SQL database normalisation and design; transact-SQL and SQL; data types; English query; SQL Server and OLEDB; SQL Server and ADO; cursors; stored procedures and triggers; transactions and locks; query and retrieval; manipulating data and views; batches and scripts; advanced programming. Advanced SQL Server database processing: OLAP; transaction-based processing; distributed databases and DNA; SQL Server distribution services. Backmatter: appendices - error codes and troubleshooting; exception handling; ODBC.