Forgot My Password Support
◊ SQL SERVER 2000 DATABASE DESIGN ONLINE TRAINING SERIES

Online SQL Server 2000 Database Design Training

Database » SQL Server

Check out these great money-saving course packages:

Only $99.95

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. SQL Server 2000 Database Design MCSE 70-229: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. SQL Server 2000 Database Design MCSE 70-229: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. SQL Server 2000 Database Design MCSE 70-229: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. SQL Server 2000 Database Design MCSE 70-229: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. SQL Server 2000 Database Design MCSE 70-229: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. SQL Server 2000 Database Design MCSE 70-229: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. SQL Server 2000 Database Design MCSE 70-229: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. SQL Server 2000 Database Design MCSE 70-229: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. SQL Server 2000 Database Design MCSE 70-229: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



Resources for SQL Server 2000 Database Design