1-877-WEBUCATE
(1-877-932-8228)
info@webucator.com
 

"Webucator took the time to customize the training to meet our needs. The instructor was excellent a..." More quotes

Microsoft Training
Java Training
XML Training
Database & SQL Training
PHP, Perl, ASP, Groovy, Grails, Ruby on Rails Training
HTML, JavaScript, Ajax & CSS Training
Adobe CS3 Training
◊ ONLINE SQL SERVER 2000 DATABASE DESIGN TRAINING

Overview | Catalog | Benefits | FAQs | Try Free Course | Buy | Log in | Support

Online SQL Server 2000 Database Design MCSE 70-229 Training

Only $99.95
12-month subscription

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.

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

ONLINE SQL Server 2000 Database Design MCSE 70-229 TRAINING FEATURES

  • 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. Data Modeling and Database Creation

Time: 4 hours
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.

Objectives

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

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

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

Objectives

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

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. Retrieving and Modifying Data

Time: 2 hours
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.

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

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. Indexes and Views

Time: 3 hours
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.

Objectives

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

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

Time: 4 hours
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.

Objectives

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

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. Remote Data Access and XML

Time: 2 hours
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.

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

Topics

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

7. Optimization and Security

Time: 2 hours
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.

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

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. Exam Preparation 1

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

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

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. Exam Preparation 2

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

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

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
home - onsite classes - instructor-led online courses - self-paced online courses - why webucator - partners - contact - sitemap
© 2008 Webucator. All rights reserved. info@webucator.com | Toll Free: 877-WEBUCATE (877-932-8228) | From Outside the USA: 315-849-2724 | Fax: 315-410-5320
Phoenix, AZ | Santa Clara, CA | Santa Clara, CA | Los Angeles, CA | Sacramento, CA | Washington, DC | Atlanta, GA | Chicago, IL | Indianapolis, IN | Muncie, IN
New Orleans, LA Boston, MA | Cambridge, MA | Charlestown, MA | Framingham, MA | Ipswich, MA | Lincoln, MA | Wellesley, MA | Worcester, MA | Bangor, ME | Detroit, MI
Raleigh, NC Winston-Salem, NC | Lincoln, NE | East Hanover, NJ | Eatontown, NJ | Madison, NJ | Parsippany, NJ | Trenton, NJ | Albany, NY | Buffalo, NY | Rochester, NY
New York City, NY | Syracuse, NY | West Babylon, NY | Dayton, OH | Bethlehem, PA | Philadelphia, PA | Pittsburgh, PA | Pittsburgh, PA | State College, PA
Middletown, RI | Rapid City, SD | Austin, TX | Dallas, TX | Houston, TX | Arlington, VA | McLean, VA | Seattle, WA | Toronto, Canada | Ottawa, Canada | Calgary, CA