computer training image
Online Training Classes Purchased Securely
Shopping cart  Shopping cart
0 Product(s) in cart
Total $0.00
> Checkout
Online Payments

Benefits of Computer Coach's online computer training classes

  • Accessible 24 hours a day 7 days a week, so you can learn when you have time.
  • Cost-effective solutions, so you don’t go broke learning the skills you need.
  • Available Anytime, anywhere with an Internet connection, so you can study at your house, office, or where you feel comfortable.
  • Interactive & fun courses allow for greater retention of course topics.
  • Easy to use so you can start learning right away.
  • Full of hands-on labs so you can get the practice you need
  • HTML Based so you don’t need any additional downloads
  • Live Mentor Available to ask questions and get clarification

online computer training questions answered

SQL Server 2000 Database Design MCSE 70-229

12 Month Subscription - $70
Live Mentor +$30

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

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:
●  Exercises that allow users to practice the application
●  A file containing the text of the exercises
●  Activities that allow users to apply course concepts in an interactive questioning environment
●  A glossary
●  A Skill Assessment

Topics icluded in this course:
SQL Server 2000 Database Design MCSE 70-229 : Data Modeling and Database Creation
SQL Server 2000 Database Design MCSE 70-229 : Database Objects
SQL Server 2000 Database Design MCSE 70-229 : Retrieving and Modifying Data
SQL Server 2000 Database Design MCSE 70-229 : Indexes and Views
SQL Server 2000 Database Design MCSE 70-229 : Database Programming
SQL Server 2000 Database Design MCSE 70-229 : Remote Data Access and XML
SQL Server 2000 Database Design MCSE 70-229 : Optimization and Security
SQL Server 2000 Database Design MCSE 70-229 : Exam Preparation 1
SQL Server 2000 Database Design MCSE 70-229 : Exam Preparation 2

SQL Server 2000 Database Design MCSE 70-229 : Data Modeling and Database Creation
Summary:
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:
After completing this course, students will be able to:
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
top

SQL Server 2000 Database Design MCSE 70-229 : Database Objects
Summary:
This course shows users how to create and alter tables, define data types, and ensure integrity by implementing constraints.

Objectives:
After completing this course, students will be able to:
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
top

SQL Server 2000 Database Design MCSE 70-229 : Retrieving and Modifying Data
Summary:
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:
After completing this course, students will be able to:
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
top

SQL Server 2000 Database Design MCSE 70-229 : Indexes and Views
Summary:
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:
After completing this course, students will be able to:
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
top

SQL Server 2000 Database Design MCSE 70-229 : Database Programming
Summary:
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:
After completing this course, students will be able to:
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
top

SQL Server 2000 Database Design MCSE 70-229 : Remote Data Access and XML
Summary:
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:
After completing this course, students will be able to:
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
top

SQL Server 2000 Database Design MCSE 70-229 : Optimization and Security
Summary:
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:
After completing this course, students will be able to:
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
top

SQL Server 2000 Database Design MCSE 70-229 : Exam Preparation 1
Summary:
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:
After completing this course, students will be able to:
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
top

SQL Server 2000 Database Design MCSE 70-229 : Exam Preparation 2
Summary:
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:
After completing this course, students will be able to:
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
top

12 Month Subscription - $70
Live Mentor +$30