MCDBA — Microsoft Certified Database Administrator
Module 2: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition (Exam 70-229)
- SQL Server
Overview
- Overview
of Programming SQL Server
- Creating
and Managing Databases
- Creating
Data Types and Tables
- Implementing
Data Integrity
- Planning
Indexes
- Creating
and Maintaining Indexes
- Implementing
Views
- Implementing
Stored Procedures
- Implementing
User-defined Functions
- Implementing
Triggers
- Programming
Across Multiple Servers
- Optimizing
Query Performance
- Analyzing
Queries
- Managing
Transactions and Locks
For more details, please contact our Technical Adviser at 503-725-2395 or email it@pdx.edu.
