Training Center
Computer Training courses online, at your pace !

Computer Training Online


Or call 800 639 0160








SQL Server 2000 Database Design MCSE 70 229
 Join over 1 million people who learn online, with these complete interactive computer training courses.




See How It Works
This online course includes: Time Needed
Data Modeling and Database Creation  4 hours
Database Objects  2 hours
Retrieving and Modifying Data  2 hours
Indexes and Views  3 hours
Database Programming  4 hours
Remote Data Access and XML  2 hours
Optimization and Security  2 hours
Exam Preparation 1 1 hour
Exam Preparation 2 1 hour
Estimated time needed to complete entire course 21 hours


Receive your login ID to take the training courses online, as many times as you wish, for 1 year.  Click here for group orders.

Buy this entire online training course with one easy payment of $67

OR

Buy the Microsoft Pack, and receive this course plus many more, for only $197



Benefits
  • Unlimited access for 1 year
  • Learn anytime, anywhere
  • You control the pace
  • Start & stop wherever you want
  • No books to read
  • No software needed
  • Value Packs include Free online tech support
  • Double guarantee
  • 100% Money back guarantee
  • One time payment No monthly fee
  • Use the course index for review anytime
  • Answer course questions with at least 70% accuracy and print your own certificates of completion to prove that you have mastered each training course.
  • Free status reports for company managers

Requirements
All you need is a PC with Windows, the Microsoft Internet Explorer (browser) and an Internet connection.
Note: The online computer training is designed to work only with Internet Explorer.  Prices shown are per user.




What You will Learn
This online training course 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 online training course 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.




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



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



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



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



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



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



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



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



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





 

 

Copyright © 2007 TrainingCenter.com