Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition - Exam 70-229
Course Description:
This certification exam measures your ability to design and implement database solutions by using Microsoft SQL Server 2000 Enterprise Edition. Upon successful completion of this course, the student will be able to pass the Microsoft 70-229 exam, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition, which is one of the core electives in the Microsoft's MCSE 2003 and one of the core exams in the Microsoft MCDBA certification program.
Prerequisites:
Candidates should have at least six months to one year of experience implementing relational databases in environments that contain:
Heterogeneous databases.
SQL Server security integrated with Windows Authentication.
Client/server configurations of 50 to 5,000 or more users.
Web configurations that use Microsoft Internet Information Services (IIS) or COM+.
Databases as large as two terabytes.
Multiple installations of SQL Server 2000.
Audience:
Candidates for this course operate in medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition
Deployment Options:
- Video Training
- CD-ROM
- E-learning
- ThinkTank Server Solution
Learning / Exam module:
MCSA/MCSE Certification - Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition - Exam 70-229 Course Duration: 30 - 40 hours
About Our Experts:
Elizabeth Hague has been working in the IT Industry with SQL 6.5, 7.0 and 2000 as a consultant and a trainer for almost four years. She possesses extensive hands-on experience including working with migrations from Access to SQL, writing numerous stored procedures that are called from VB, using SQL Server DTS (Data Transformation Services) to transfer data between an AS400 and flat file systems. She has taught preparatory classes for SQL exams as well as classes for
the beginner. Her students leave her classes feeling as if they have a much better understanding of SQL both for real world applications and for examination purposes.
Learning Segments:
Introduction
Chapter One - Overview
Data Modeling
Organizing Information
Tools
Chapter Two - Designing Database Structure
Database Structure
Database Creation
Managing Size
File Groups
Chapter Eight - Views
Creating A View
Definition And Dependencies
Modifying Data
Chapter Nine - Stored Procedures
Kinds Of Stored Procedures
Input Parameters
Output Parameters
Recompiling
Chapter Ten - Functions
Kinds Of Functions
Scalar
In-Line
Multi-Statement
Chapter Eleven - Indexing
Clustered Index
Nonclustered Index
Dropping An Index
Composite Indexes
Defragmenting Indexes
Fill Factor And Pad Index
Index Statistics
Fine Tuning Indexes
