MS SQL Server 6.5 DBA Home
MS SQL Server 6.5 DBA eCertification

The following outline describes the content of the MS SQL Server 6.5 DBA eCertification.  To qualify as a Certified MS SQL Server 6.5 DBA, you must pass the examination with a score of 60% or higher.  To be certified as a Master MS SQL Server 6.5, you must obtain a score of 75% or higher.

Topic

Subtopic

Additional Concepts

Concept

Additional Concepts

Replication

Architecture

APIs

Architecture

Concept

Architecture

Data Dictionary

Architecture

Integration Approaches

Architecture

Role of RDBMS

Architecture

Schema

Cursors

Concept

Design

Concept

Design

Data Modeling

Design

Denormalization

Design

Logical vs Physical

Design

Normalization

Design

Normalization Forms

Design

Redefining Tables

Indexes

Concept

Indexes

Considerations

Locking

Concept

Locking

Deadlocks

Performance

Common Bottlenecks

Performance

Common Problems/Causes

Performance

Concept

Performance

Dimensions

Performance

Tradeoffs

Procedures

Concept

Referential Integrity

Cascades

Referential Integrity

Concept

Referential Integrity

Keys

Roles

DBA

Roles

System Administrator

SQL Basics

Basic Rules

SQL Basics

Concept

SQL Basics

Result Sets

SQL Functions

Examples

SQL Object Creation

Concept

SQL Object Creation

Table, View, Index Mgmt

SQL Programming Constructs

Batches

SQL Programming Constructs

Conditions

SQL Queries

Joins

Transactions

Concept

Transactions

Recoverability

Triggers

Concept

Views

Concept

Security Object-Level
Security Database
Security Administration
Security Authentication Methods

 

All eCertification examinations are delivered through the web and use computer adaptive testing (CAT), in which the degree of complexity for questions areas based on previous answers.  Additionally, questions are selected from large question banks, so that it is not productive to memorize questions. 

The expected time to complete the MS SQL Server DBA eCertification examination is 60 minutes.  In addition to registration with eCertifications.com, all certified professionals may use one of the logos below on their resume followed by a professional certificate which is suitable for framing.

MS SQL 6.5 DBA MS SQL 6.5 DBA - Master

 


This page and its contents are Copyright 2010- www.ecertifications.com.
All Rights Reserved.