Mastering SQL Server 2000

Mike Gunderloy, Joseph L. Jorden (Autoren)

Buch | Softcover

1201 Seiten

2000
Sybex Inc.,U.S. (Verlag)
978-0-7821-2627-3 (ISBN)

Titel ist leider vergriffen;
keine Neuauflage

Artikel merken

Intended for those working with the SQL Server, this book provides the background knowledge and the practical instruction needed to accomplish various tasks, from the basic to the advanced. It covers: understanding SQL Server architecture; designing an efficient normalized database; writing Transact-SQL statements and batches; and more.

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.

Mike Gunderloy, an MCSE, MCSD, and MCT, is a senior consultant with MCW Technologies, where he specializes in Microsoft Visual Basic and SQL Server. He is the author of SQL Server 7 In Record Time,Visual Basic Developer's Guide to ADO, and VB/VBA Developer's Guide to the Windows Installer, all from Sybex. Mike lives on a farm in rural Washington state with his family and an ever--growing population of livestock. Joseph L. Jorden is an MCSE, MCT, CCNA, and CCDA who has been administering databases for the last seven years. Currently Joseph works independently, consulting and instructing on a variety of technologies.

Introduction. PART I: INTRODUCING SQL SERVER. 1. Introduction to SQL Server 2000. 2. Overview of Database Concepts. 3. Overview of SQL Server. 4. Database Design and Normalization. PART II: TRANSACT--SQL. 5. Transact--SQL Overview and Basics. 6. SELECT Queries. 7. Action Queries. 8. Advanced Transact--SQL. PART III: DIGGING INTO SQL SERVER. 9. Using SQL Server Enterprise Manager. 10. Databases. 11. Tables. 12. Indexing. 13. Views. 14. Stored Procedures. 15. Using Triggers. PART IV: ADMINISTERING SQL SERVER. 16. Basic Administrative Tasks. 17. Automating Administration. 18. Security and SQL Server 2000. PART V: DEVELOPMENT WITH SQL SERVER. 19. ADO and SQL Server. 20. SQL--DMO. 21. SQL Namespace. 22. Data Transformation Services. 23. The Web Assistant Wizard. 24. Integrating SQL Server with Internet Information Server. PART VI: ADVANCED TOPICS. 25. Locking. 26. Monitoring and Optimizing SQL Server 2000. 27. Replication. 28. Analysis Services. 29. Microsoft English Query. 30. Troubleshooting. Appendix A: Transact--SQL Reference. Appendix B: Installing Microsoft SQL Server 2000. Index.

Erscheint lt. Verlag	10.10.2000
Zusatzinfo	illustrations
Verlagsort	New York
Sprache	englisch
Maße	190 x 228 mm
Gewicht	1971 g
Einbandart	Paperback
Themenwelt	Informatik ► Datenbanken ► SQL Server
	Mathematik / Informatik ► Informatik ► Programmiersprachen / -werkzeuge
	Mathematik / Informatik ► Informatik ► Software Entwicklung
ISBN-10	0-7821-2627-8 / 0782126278
ISBN-13	978-0-7821-2627-3 / 9780782126273
Zustand	Neuware