SQL Server 2000 Database Design MCSE 70-229: Data Modeling and Database Creation

SQL Server 2000 Database Design MCSE 70-229: Data Modeling and Database Creation provides an overview of data modeling with an emphasis on relational database systems, and shows users how to implement a logical design by creating a database in SQL Server 2000.

SQL Server 2000 Database Design MCSE 70-229: Database Objects shows users how to create and alter tables, define data types, and ensure integrity by implementing constraints.

SQL Server 2000 Database Design MCSE 70-229: Retrieving and Modifying Data shows users how to retrieve, filter, and modify data using Transact-SQL, and explains techniques for importing and exporting data in SQL Server 2000.

SQL Server 2000 Database Design MCSE 70-229: Indexes and Views explains the types of indexes and views available in SQL Server 2000, and shows how they can be used to enhance and control access to data.

SQL Server 2000 Database Design MCSE 70-229: Database Programming shows users how to create and use stored procedures, triggers, functions, user-defined functions (UDFs), transactions, cursors, and locks in database application programming.

SQL Server 2000 Database Design MCSE 70-229: Remote Data Access and XML explains techniques for accessing heterogeneous data using linked servers, ad hoc queries, and pass-through queries, and shows users how to retrieve and write data using XML.

SQL Server 2000 Database Design MCSE 70-229: Optimization and Security shows users the tools and techniques that can be used to monitor and optimize the performance of a SQL Server 2000 database, and how to design and implement a database security plan.

SQL Server 2000 Database Design MCSE 70-229: Exam Preparation 1 provides practice questions with explanatory feedback for Microsoft Exam 70-229: "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition."