This series of courses serves as preparation for Microsoft Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition; which is one of several electives for the MCSE certification track, and a core requirement for
This SQL Server 2000 Database Design MCSE 70-229 online training series provides over 21 hours of self-paced courseware. This web-based training provides 6 months of unlimited access to all of the following lessons:
1 . Data Modeling and Database Creation
2 . Database Objects
3 . Database Programming
4 . Exam Preparation 1
5 . Exam Preparation 2
6 . Indexes and Views
7 . Optimization and Security
8 . Remote Data Access and XML
9 . Retrieving and Modifying Data
Lesson Detail:
Data Modeling and Database Creation
This course 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.
Database Objects
This course shows users how to create and alter tables, define data types, and ensure integrity by implementing constraints.
Database Programming
This course shows users how to create and use stored procedures, triggers, functions, user-defined functions (UDFs), transactions, cursors, and locks in database application programming.
Exam Preparation 1
This course provides practice questions with explanatory feedback for Microsoft Exam 70-229: "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition."
Exam Preparation 2
This course provides practice questions with explanatory feedback for Microsoft Exam 70-229: "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition."
Indexes and Views
This course 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.
Optimization and Security
This course 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.
Remote Data Access and XML
This course 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.
Retrieving and Modifying Data
This course shows users how to retrieve, filter, and modify data using Transact-SQL, and explains techniques for importing and exporting data in SQL Server 2000.
Certification:
SQL Server 2000 Database Design MCSE 70-229
Audience:
This series is for anyone preparing for Microsoft Exam 70-229: "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition."
Features:
What You Get:
You will receive Unlimited Access to all of the SQL Server 2000 Database Design MCSE 70-229 training tutorials listed above. Your online training courses will be available from anywhere you have internet access.This e-learning series includes all of the online training tutorials listed and is provided in an interactive, self-paced format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 6 months of unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.
Web-Based Training Products:
You might also be interested in our Microsoft Certifications Package which includes all of the SQL Server 2000 Database Design MCSE 70-229 training courses listed above plus hundreds of hours of related online training courses