Complete. Authoritative. Practical. The only SQL Server book youneed.
Mastering SQL Server 2000 is the one indispensableresource for anyone working with the latest version of SQL Server. Whether you build or administer SQL Server databases or writeapplications that communicate with them, you'll find the backgroundknowledge and the practical instruction you need to accomplish anytask, from the most basic to the most advanced. Coverageincludes:
* Understanding SQL Server architecture
* Designing an efficient normalized database
* Writing Transact-SQL statements and batches
* Creating databases
* Creating tables and views
* Creating stored procedures and triggers
* Administering SQL Server
* Managing SQL Server security
* Designing applications using ADO, SQL-DMO, and SQL-NS
* Using Data Transformation Services
* Integrating SQL Server with the Internet
* Optimizing SQL Server performance
* Understanding and managing replication
* Using Analysis Services to analyze data
* Using Microsoft English Query
* Troubleshooting common problems
Mastering SQL Server 2000 is the one indispensableresource for anyone working with the latest version of SQL Server. Whether you build or administer SQL Server databases or writeapplications that communicate with them, you'll find the backgroundknowledge and the practical instruction you need to accomplish anytask, from the most basic to the most advanced. Coverageincludes:
* Understanding SQL Server architecture
* Designing an efficient normalized database
* Writing Transact-SQL statements and batches
* Creating databases
* Creating tables and views
* Creating stored procedures and triggers
* Administering SQL Server
* Managing SQL Server security
* Designing applications using ADO, SQL-DMO, and SQL-NS
* Using Data Transformation Services
* Integrating SQL Server with the Internet
* Optimizing SQL Server performance
* Understanding and managing replication
* Using Analysis Services to analyze data
* Using Microsoft English Query
* Troubleshooting common problems
