SQL Server 2000 database and data warehouse

Author: FeiSi Technology Product R&D Center
Publisher:
Publish Date: 2001-06-01
Features: SQL Server 2000 is the latest database software from Microsoft, which not only supports traditional relational databases but also knowledge warehouses. This book consists of two parts: Database and Data Warehouse. The database section provides a detailed introduction to the creation and usage of major database elements, including databases, tables, indexes, views, triggers, stored procedures, and user-defined functions. Additionally, it thoroughly discusses the implementation of data integrity. The data warehouse section elaborates on the components of a data warehouse, as well as its creation, maintenance, and usage. The book is rich in examples and clear in concepts, enabling readers to fully grasp the practical applications of SQL Server databases and data warehouses. This book is suitable for intermediate readers learning database technology, and it is also an excellent reference for advanced readers.