SQL Server 2000 : The Complete Reference
by SHAPIROEdition: 1st
Format: Paperback
Pub. Date: 2000-12-08
Publisher(s): McGraw-Hill Osborne Media
Availability: This title is currently not available.
Other versions by this Author
-
This Item Qualifies for Free Shipping!*
*Excludes marketplace orders.
List Price: $49.99
Rent Book
Select for Price
New Book
We're Sorry
Sold Out
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
Summary
Master the revolutionary new release of Microsoft's high-performance, scalable database management system. This complete reference explains installation, configuration, administration, replication, security, backup, and recovery. You'll also learn to exploit all the advanced features of SQL Server 2000, including the Enterprise Manager, TSQL, data warehousing, and OLAP services.
Author Biography
Jeffrey Shapiro (Boca Raton, FL) has been involved in IT for more than 12 years and has worked with hundreds of companies around the world including Microsoft, IBM and Novell. He has been a key speaker on IT and Software Engineering at numerous conferences. Trained as a journalist, Jeffrey now spends most of his time writing on IT. He is also the editor of two new newsletters: Service Level and CRM Review.
Table of Contents
Part I: SQL Server 2000 System and Platform Architecture. Chapter 1: Getting to Know SQL Server 2000. Chapter 2: Database Architecture. Chapter 3: SQL Server 2000 Client/Server Architecture. Chapter 4: DBMS Architecure. Chapter 5: Meta Data Services. Chapter 6: Installing SQL Server 2000. Part II: SQL Server 2000 Platform Adminstration. Chapter 7: Adminstering Architecture. Chapter 8: SQL Server Security and Access Control. Chapter 9: SQL Server Disaster Recovery. Chapter 10: SQL Server Replication. Chapter 11: SQL Server 2000 Databases. Chapter 12: Administering SQL Server 2000. Chapter 13: SQL Server 2000 high Availability. Part III: Programming SQL Server 2000. Chapter 14: SQL Server 2000 Programming Concepts, Strategies, and Models. Chapter 15: Getting Started with SQL Query Analyzer. Chapter 16: Transact-SQL Primer. Chapter 17: SQL Server Integrity Programming and Management. Chapter 18: Stored Procedures and Triggers. Chapter 19: Query Fundamentals and Strategy. Chapter 20: Working with Operational Data. Chapter 21: SQL Server 2000 Advanced Concepts. Chapter 22: English Query. Chapter 23: SQL Server and the Internet. Part IV: SQL Server 2000 Analysis Services. Chapter 24: Data Mining and Data Warehousing. Chapter 25: Getting Started: Analysis Services and OLAP.
Chapter 2: Database Architecture. Chapter 3: SQL Server 2000 Client/Server Architecture. Chapter 4: DBMS Architecure. Chapter 5: Meta Data Services. Chapter 6: Installing SQL Server 2000. Part II: SQL Server 2000 Platform Adminstration. Chapter 7: Adminstering Architecture. Chapter 8: SQL Server Security and Access Control. Chapter 9: SQL Server Disaster Recovery. Chapter 10: SQL Server Replication. Chapter 11: SQL Server 2000 Databases. Chapter 12: Administering SQL Server 2000. Chapter 13: SQL Server 2000 high Availability. Part III: Programming SQL Server 2000. Chapter 14: SQL Server 2000 Programming Concepts, Strategies, and Models. Chapter 15: Getting Started with SQL Query Analyzer. Chapter 16: Transact-SQL Primer. Chapter 17: SQL Server Integrity Programming and Management. Chapter 18: Stored Procedures and Triggers. Chapter 19: Query Fundamentals and Strategy. Chapter 20: Working with Operational Data. Chapter 21: SQL Server 2000 Advanced Concepts. Chapter 22: English Query. Chapter 23: SQL Server and the Internet. Part IV: SQL Server 2000 Analysis Services. Chapter 24: Data Mining and Data Warehousing. Chapter 25: Getting Started: Analysis Services and OLAP.
Chapter 4: DBMS Architecure. Chapter 5: Meta Data Services. Chapter 6: Installing SQL Server 2000. Part II: SQL Server 2000 Platform Adminstration. Chapter 7: Adminstering Architecture. Chapter 8: SQL Server Security and Access Control. Chapter 9: SQL Server Disaster Recovery. Chapter 10: SQL Server Replication. Chapter 11: SQL Server 2000 Databases. Chapter 12: Administering SQL Server 2000. Chapter 13: SQL Server 2000 high Availability. Part III: Programming SQL Server 2000. Chapter 14: SQL Server 2000 Programming Concepts, Strategies, and Models. Chapter 15: Getting Started with SQL Query Analyzer. Chapter 16: Transact-SQL Primer. Chapter 17: SQL Server Integrity Programming and Management. Chapter 18: Stored Procedures and Triggers. Chapter 19: Query Fundamentals and Strategy. Chapter 20: Working with Operational Data. Chapter 21: SQL Server 2000 Advanced Concepts. Chapter 22: English Query. Chapter 23: SQL Server and the Internet. Part IV: SQL Server 2000 Analysis Services. Chapter 24: Data Mining and Data Warehousing. Chapter 25: Getting Started: Analysis Services and OLAP.
Chapter 6: Installing SQL Server 2000. Part II: SQL Server 2000 Platform Adminstration. Chapter 7: Adminstering Architecture. Chapter 8: SQL Server Security and Access Control. Chapter 9: SQL Server Disaster Recovery. Chapter 10: SQL Server Replication. Chapter 11: SQL Server 2000 Databases. Chapter 12: Administering SQL Server 2000. Chapter 13: SQL Server 2000 high Availability. Part III: Programming SQL Server 2000. Chapter 14: SQL Server 2000 Programming Concepts, Strategies, and Models. Chapter 15: Getting Started with SQL Query Analyzer. Chapter 16: Transact-SQL Primer. Chapter 17: SQL Server Integrity Programming and Management. Chapter 18: Stored Procedures and Triggers. Chapter 19: Query Fundamentals and Strategy. Chapter 20: Working with Operational Data. Chapter 21: SQL Server 2000 Advanced Concepts. Chapter 22: English Query. Chapter 23: SQL Server and the Internet. Part IV: SQL Server 2000 Analysis Services. Chapter 24: Data Mining and Data Warehousing. Chapter 25: Getting Started: Analysis Services and OLAP.
Chapter 7: Adminstering Architecture. Chapter 8: SQL Server Security and Access Control. Chapter 9: SQL Server Disaster Recovery. Chapter 10: SQL Server Replication. Chapter 11: SQL Server 2000 Databases. Chapter 12: Administering SQL Server 2000. Chapter 13: SQL Server 2000 high Availability. Part III: Programming SQL Server 2000. Chapter 14: SQL Server 2000 Programming Concepts, Strategies, and Models. Chapter 15: Getting Started with SQL Query Analyzer. Chapter 16: Transact-SQL Primer. Chapter 17: SQL Server Integrity Programming and Management. Chapter 18: Stored Procedures and Triggers. Chapter 19: Query Fundamentals and Strategy. Chapter 20: Working with Operational Data. Chapter 21: SQL Server 2000 Advanced Concepts. Chapter 22: English Query. Chapter 23: SQL Server and the Internet. Part IV: SQL Server 2000 Analysis Services. Chapter 24: Data Mining and Data Warehousing. Chapter 25: Getting Started: Analysis Services and OLAP.
Chapter 9: SQL Server Disaster Recovery. Chapter 10: SQL Server Replication. Chapter 11: SQL Server 2000 Databases. Chapter 12: Administering SQL Server 2000. Chapter 13: SQL Server 2000 high Availability. Part III: Programming SQL Server 2000. Chapter 14: SQL Server 2000 Programming Concepts, Strategies, and Models. Chapter 15: Getting Started with SQL Query Analyzer. Chapter 16: Transact-SQL Primer. Chapter 17: SQL Server Integrity Programming and Management. Chapter 18: Stored Procedures and Triggers. Chapter 19: Query Fundamentals and Strategy. Chapter 20: Working with Operational Data. Chapter 21: SQL Server 2000 Advanced Concepts. Chapter 22: English Query. Chapter 23: SQL Server and the Internet. Part IV: SQL Server 2000 Analysis Services. Chapter 24: Data Mining and Data Warehousing. Chapter 25: Getting Started: Analysis Services and OLAP.
Chapter 11: SQL Server 2000 Databases. Chapter 12: Administering SQL Server 2000. Chapter 13: SQL Server 2000 high Availability. Part III: Programming SQL Server 2000. Chapter 14: SQL Server 2000 Programming Concepts, Strategies, and Models. Chapter 15: Getting Started with SQL Query Analyzer. Chapter 16: Transact-SQL Primer. Chapter 17: SQL Server Integrity Programming and Management. Chapter 18: Stored Procedures and Triggers. Chapter 19: Query Fundamentals and Strategy. Chapter 20: Working with Operational Data. Chapter 21: SQL Server 2000 Advanced Concepts. Chapter 22: English Query. Chapter 23: SQL Server and the Internet. Part IV: SQL Server 2000 Analysis Services. Chapter 24: Data Mining and Data Warehousing. Chapter 25: Getting Started: Analysis Services and OLAP.
Chapter 13: SQL Server 2000 high Availability. Part III: Programming SQL Server 2000. Chapter 14: SQL Server 2000 Programming Concepts, Strategies, and Models. Chapter 15: Getting Started with SQL Query Analyzer. Chapter 16: Transact-SQL Primer. Chapter 17: SQL Server Integrity Programming and Management. Chapter 18: Stored Procedures and Triggers. Chapter 19: Query Fundamentals and Strategy. Chapter 20: Working with Operational Data. Chapter 21: SQL Server 2000 Advanced Concepts. Chapter 22: English Query. Chapter 23: SQL Server and the Internet. Part IV: SQL Server 2000 Analysis Services. Chapter 24: Data Mining and Data Warehousing. Chapter 25: Getting Started: Analysis Services and OLAP.
Chapter 14: SQL Server 2000 Programming Concepts, Strategies, and Models. Chapter 15: Getting Started with SQL Query Analyzer. Chapter 16: Transact-SQL Primer. Chapter 17: SQL Server Integrity Programming and Management. Chapter 18: Stored Procedures and Triggers. Chapter 19: Query Fundamentals and Strategy. Chapter 20: Working with Operational Data. Chapter 21: SQL Server 2000 Advanced Concepts. Chapter 22: English Query. Chapter 23: SQL Server and the Internet. Part IV: SQL Server 2000 Analysis Services. Chapter 24: Data Mining and Data Warehousing. Chapter 25: Getting Started: Analysis Services and OLAP.
Chapter 16: Transact-SQL Primer. Chapter 17: SQL Server Integrity Programming and Management. Chapter 18: Stored Procedures and Triggers. Chapter 19: Query Fundamentals and Strategy. Chapter 20: Working with Operational Data. Chapter 21: SQL Server 2000 Advanced Concepts. Chapter 22: English Query. Chapter 23: SQL Server and the Internet. Part IV: SQL Server 2000 Analysis Services. Chapter 24: Data Mining and Data Warehousing. Chapter 25: Getting Started: Analysis Services and OLAP.
Chapter 18: Stored Procedures and Triggers. Chapter 19: Query Fundamentals and Strategy. Chapter 20: Working with Operational Data. Chapter 21: SQL Server 2000 Advanced Concepts. Chapter 22: English Query. Chapter 23: SQL Server and the Internet. Part IV: SQL Server 2000 Analysis Services. Chapter 24: Data Mining and Data Warehousing. Chapter 25: Getting Started: Analysis Services and OLAP.
Chapter 20: Working with Operational Data. Chapter 21: SQL Server 2000 Advanced Concepts. Chapter 22: English Query. Chapter 23: SQL Server and the Internet. Part IV: SQL Server 2000 Analysis Services. Chapter 24: Data Mining and Data Warehousing. Chapter 25: Getting Started: Analysis Services and OLAP.
Chapter 22: English Query. Chapter 23: SQL Server and the Internet. Part IV: SQL Server 2000 Analysis Services. Chapter 24: Data Mining and Data Warehousing. Chapter 25: Getting Started: Analysis Services and OLAP.
Part IV: SQL Server 2000 Analysis Services. Chapter 24: Data Mining and Data Warehousing. Chapter 25: Getting Started: Analysis Services and OLAP.
Chapter 25: Getting Started: Analysis Services and OLAP.
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.