I was completely satisfied with everything that I learned in class. I'm confident that I'll be able to offer my... More Testimonials »

SQL Server 2000 Database Design eLearning Course

  1. Overview
  2.  | 
  3. Catalog
  4.  | 
  5. Packages
  6.  | 
  7. Benefits
  8.  | 
  9. FAQs
  10.  | 
  11. Try Free
  12.  | 
  13. Cancellation
  14.  | 
  15. Login
  16.  | 
  17. Support
Click here for Microsoft Official Curriculum eLearning courses

SQL Server 2000 Database Design MCSE 70-229 eLearning Course Series (21 hours)

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

Self-Paced SQL Server 2000 Database Design MCSE 70-229 eLearning Course Benefits

Only $99.95

12-month subscription!

Register Now

  • Learn SQL Server 2000 Database Design MCSE 70-229 online with these interactive online SQL Server 2000 Database Design MCSE 70-229 courses.
  • Affordable Pricing (Only $99.95 for the complete series)
  • A full year to complete the SQL Server 2000 Database Design MCSE 70-229 courses
  • Retake the SQL Server 2000 Database Design MCSE 70-229 courses as many times as you like
  • Measure your progress with assessment tests after each course
  • Earn completion certificates after passing each assessment test

1. SQL Server 2000 Database Design MCSE 70-229:1 Data Modeling and Database Creation (Time: 4 hours)

This eLearning 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.

Course Objectives

  • Gather database requirements
  • Build a logical data model
  • Create and alter databases, files, and filegroups
  • View and change database properties and options

Course Topics

  • 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

2. SQL Server 2000 Database Design MCSE 70-229:2 Database Objects (Time: 2 hours)

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

Course Objectives

  • Create and alter database objects
  • Create and alter tables
  • Design and create constraints
  • Alter database objects to support replication

Course Topics

  • 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

3. SQL Server 2000 Database Design MCSE 70-229:3 Retrieving and Modifying Data (Time: 2 hours)

This eLearning 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.

Course Objectives

  • Use the Transact-SQL Data Manipulation Language statements SELECT, INSERT, UPDATE, and DELETE to retrieve and modify data
  • Use SQL Server built-in functions, including CASE, CONVERT, and CAST
  • Define a collation at the server, database, or column level
  • Use the Transact-SQL BULK INSERT statement, the BCP utility, or Data Transformation Services (DTS) to import and export data

Course Topics

  • 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

4. SQL Server 2000 Database Design MCSE 70-229:4 Indexes and Views (Time: 3 hours)

This eLearning 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.

Course Objectives

  • Create various types of indexes
  • Create and modify table views
  • Modify table data through a view
  • Partition data using views

Course Topics

  • 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

5. SQL Server 2000 Database Design MCSE 70-229:5 Database Programming (Time: 4 hours)

This eLearning course shows users how to create and use stored procedures, triggers, functions, user-defined functions (UDFs), transactions, cursors, and locks in database application programming.

Course Objectives

  • Create, modify, and execute stored procedures
  • Create and modify triggers
  • Create and execute user-defined functions
  • Work with transactions, cursors, and locks

Course Topics

  • 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

6. SQL Server 2000 Database Design MCSE 70-229:6 Remote Data Access and XML (Time: 2 hours)

This eLearning 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.

Course Objectives

  • Create a linked server
  • Create ad hoc and pass-through queries
  • Set up the SQL Server to return XML results
  • Request, retrieve, and parse XML data

Course Topics

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

7. SQL Server 2000 Database Design MCSE 70-229:7 Optimization and Security (Time: 2 hours)

This eLearning 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.

Course Objectives

  • Configure Windows 2000 Server and SQL Server 2000
  • Use SQL Profiler, Query Analyzer, and other tools to monitor database activity
  • Design a database security plan

Course Topics

  • 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

8. SQL Server 2000 Database Design MCSE 70-229:8 Exam Preparation 1 (Time: 1 hours)

This eLearning course provides practice questions with explanatory feedback for Microsoft Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.

Course Objectives

  • Demonstrate familiarity with the concepts of developing a logical data model
  • Demonstrate familiarity with the concepts of implementing the physical database
  • Demonstrate familiarity with the concepts of retrieving and modifying data
  • Demonstrate familiarity with the concepts of programming business logic
  • Demonstrate familiarity with the concepts of tuning and optimizing data access
  • Demonstrate familiarity with the concepts of designing a database security plan

Course Topics

  • 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

9. SQL Server 2000 Database Design MCSE 70-229:9 Exam Preparation 2 (Time: 1 hours)

This eLearning course provides practice questions with explanatory feedback for Microsoft Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.

Course Objectives

  • Demonstrate familiarity with the concepts of developing a logical data model
  • Demonstrate familiarity with the concepts of implementing the physical database
  • Demonstrate familiarity with the concepts of retrieving and modifying data
  • Demonstrate familiarity with the concepts of programming business logic
  • Demonstrate familiarity with the concepts of tuning and optimizing data access
  • Demonstrate familiarity with the concepts of designing a database security plan

Course Topics

  • 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
Quick Links
  1. Watch Presentation
  2. Free Demo
  3. Purchase Vouchers
  4. Partners
  5. Remote Courses
  6. Contact Us
  7. Sitemap
  8. Privacy Policy
Courseware
  1. Purchase Courseware
Client Success
  1. Independent Survey
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Locations
  1. Where We've Trained
  2. We have trainers all over North America.
Training Options
  1. Live eLearning Public Classes
  2. Private Training
  3. Self-Paced eLearning
Microsoft Partner
  1. Microsoft Certifications
  2. Certified Microsoft Courses
  3. Software Assurance Training Vouchers
Watch 3-minute Demo Video
of Live Online Training: Learn the benefits of online training with Webucator

Free Webinars

A Crash Course in CSS

Wed, 3/21 1:00 PM EST

Compare Webucator to leading Competitors
Microsoft Certified Learning Solutions

» Microsoft Certifications

» Certified Microsoft Courses

» Software Assurance Training Vouchers

Project Management Institute Partner

Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.

© Webucator, Inc. All rights reserved. | Toll Free: 1-877-932-8228 | From outside the USA: 315-849-2724| Fax: 315-849-2723