Learn Online with StaffKit Training Courses
Online Employee Business and Computer Training

SQL Server 2000 Database Design MCSE 70-229 Training


Summary:

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.


  • 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

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

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

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

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

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

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

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:

  • 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:


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

 

Microsoft Certifications Package

Only $249.95   staffkit

SQL Server 2000 Database Design MCSE 70-229
Training Series
Total Courses: 9
Total Time: 21+ hours
$119.99
Only $99.95
Available in Package only
Total Courses: 829
Total Time: 1776+ hours
$499.99
Only $249.95
Satisfaction Guaranteed    BBB Online Accredited Business          Fruad Protection Guaranteed By American Express            Paypal World Seller

Reviews:

'offers employers an excellent way to train their staff economically and without having to send them out of the office.'
HRMReport.com

'this is a must have resource'
California Technology Magazine

'this is theUltimate
Career Development
Package.'
MidWest Technology Journal

Read more customer
reviews about our
e-learning training tutorials

StaffKit offers a centralized e-learning solution for business, computer, technical, compliance and employee training.
Copyright © 2001-2017 StaffKit All Rights Reserved