SQL Server 2000 Database Design MCSE 70-229 Training

Summary:

This online training 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 MCDBA certification. Topics covered include developing a logical data model, implementing the database and objects, retrieving and modifying data using Transact-SQL and XML, using indexes and views, programming business logic (stored procedures, functions, views, triggers), tuning and optimizing data access, and designing a database security plan. This online training series is tightly focused on exam preparation and review, not on providing general knowledge. Some background knowledge and hands-on experience with enterprise systems and relational databases is assumed.

This SQL Server 2000 Database Design MCSE 70-229 online training series provides 21 hours of self-paced courseware. This web-based training provides 1 year of unlimited access to all of the following lessons:

1 . Data Modeling and Database Creation
2 . Database Objects
3 . Retrieving and Modifying Data
4 . Indexes and Views
5 . Database Programming
6 . Remote Data Access and XML
7 . Optimization and Security
8 . Exam Preparation 1
9 . Exam Preparation 2

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.

Data modeling
Logical design
Components of the logical model
Entity relationships
Normalization
Data integrity and constraints
Physical design considerations
The SQL Server 2000 software
System files and tables
Database files and filegroups
Creating a database
Altering a database
Other database modifications
Useful functions and stored procedures

Database Objects
This course shows users how to create and alter tables, define data types, and ensure integrity by implementing constraints.

Creating and altering database objects
Tables and data types
Creating tables
Modifying and deleting tables
System-supplied data types
User-defined data types
Designing attribute integrity
Cascading referential integrity/disabling constraints
Replication and data types
Generating column values
Creating DEFAULT and RULE objects

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.

Referring to a SQL Server object
Transact-SQL
System functions
Collation precedence
Using the SELECT statement
Clauses for the SELECT statement
Subqueries
Using the DELETE statement
Using the UPDATE statement
Using the INSERT statement
Bulk copy operations
Data Transformation Services

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.

Types of indexes
Creating indexes
Using the Create Index Wizard
Analyzing index performance
Altering indexes
Using views
Guidelines for views
Creating views
Analyzing CREATE VIEW statements
Modifying a view
Using views to modify data
Creating partitioned views
Using indexed and XML views

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.

Introduction to stored procedures
Guidelines for creating stored procedures
Creating stored procedures
Modifying stored procedures
Working with stored procedures
Error handling within stored procedures
Introduction to triggers
Creating triggers
Using INSTEAD OF triggers
Modifying triggers
Introduction to functions and UDFs
Scalar-valued and table-valued UDFs
System UDFs and functions
Obtaining information about UDFs
Transactions
Transaction isolation levels
Cursors
Locks

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.

Linked servers
Ad hoc queries
Pass-through queries
XML and Internet Information Services (IIS)
The FOR XML clause
The OPENXML statement

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.

Monitoring performance
Configuring Windows 2000 Server
Configuring SQL Server 2000
Using SQL Profiler
Analyzing performance
Login authentication
Permissions
Database user accounts
Roles
Authentication modes
The database security plan

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."

Developing a logical data model
Implementing the physical database
Retrieving and modifying data
Programming business logic
Tuning and optimizing data access
Designing a database security plan

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."

Developing a logical data model
Implementing the physical database
Retrieving and modifying data
Programming business logic
Tuning and optimizing data access
Designing a database security plan

Certification:
SQL Server 2000 Database Design MCSE 70-229

Audience:
This online training series is for anyone preparing for Microsoft Exam 70-229: "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition."

Features:

Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
Activities allow learners to apply course concepts in an interactive questioning environment.
Exercises allow learners to practice in the actual application being studied.
A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
Search text enables learners to rapidly search all text within a course to easily retrieve information required.
Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
A skill assessment generates a customized learning path based on the results of a pre-test.
A glossary provides a reference for definitions of unfamiliar terms.
Bookmarking tracks the learner's progress in a course.

Technical Requirements:

Internet connection
Browser: Internet Explorer, FireFox, Chrome, Safari, Opera or any standards compliant browser.
Authorware and Macromedia Flash player recommended but not required.
JavaScript must be enabled.

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 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.

StaffKit is a leader in providing online computer training tutorials and online education. We have customers use our online training courses in over 75 countries. StaffKit has been providing e-learning solutions for 10 years.

Web-Based Training Products:

SQL Server 2000 Database Design MCSE 70-229 Online Training Series

Only $59.95

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