| |
|
|
Course Name: Exam 70-229: SQL Server 2000 - Database Design
Course Number: MCSE-0-0229
Pre-Requisites:
Candidates have at least one year of experience implementing relational databases.
Benefits:
This course will pave the way to sound knowledge, technical proficiency and expertise in deriving physical design. By creating and managing database you will be able to configure and manage SQL Server 2000 database. This course is intended for those interested or already in a career in administrator, developer or database analyst.
What you will learn:
The candidate will learn to design and develop, and manage databases.
Course Content:
 | Database Logical Modeling
|  | Database Physical Modeling
|  | Creating and Maintaining Tables
|  | Implementing Data Integrity
|  | Creating and Maintaining Indexes
|  | Creating and Maintaining Database Objects
|  | Accessing Data
|  | Modifying Data
|  | Importing and Exporting Data
|  | Locking
|  | Developing a Security Plan
|  | Analyzing and Optimizing Data Access | |
|
|
|