Complete...Authoritative...Practical! The only SQL Server book you need. "Mastering SQL Server 2000" is the one indispensable resource for anyone working with the latest version of SQL Server. Whether you build or administer SQL Server databases or write applications that communicate with them, you'll find the background knowledge and the practical instruction you need to accomplish any task, from the most basic to the most advanced. The coverage includes: 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; and troubleshooting common problems.
- ISBN10 1280536748
- ISBN13 9781280536748
- Publish Date 1 January 2006 (first published 10 October 2000)
- Publish Status Active
- Out of Print 4 March 2015
- Publish Country US
- Imprint Sybex
- Format eBook
- Pages 1201
- Language English