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.
