SQL Server Solutions, OCC
OLTP/OLAP
Career Center
SQL Server Skills Matrix v3.2
This is the core skill set necessary to
obtain certification as a Microsoft SQL Server database administrator.
|
Skill |
Version 6.5 |
Version 7.0 |
Version 2000 |
|
Analysis
Services (OLAP Services) |
----- |
Yes |
Yes |
|
Backup/Recovery |
Yes |
Yes |
Yes |
|
Batch processing |
Yes |
Yes |
Yes |
|
BCP/Export/Import |
Yes |
Yes |
Yes |
|
Capacity planning |
Yes |
Yes |
Yes |
|
Clustering and redundancy design |
Yes |
Yes |
Yes |
|
Daily maintenance |
Yes |
Yes |
Yes |
|
Database maintenance plans, scheduling, alerts |
Yes |
Yes |
Yes |
|
DCL/DDL/DML |
Yes |
Yes |
Yes |
|
Devices, databases and logs – design, creation, and
updating |
Yes |
Yes |
Yes |
|
Disaster Recovery |
Yes |
Yes |
Yes |
|
Documentation - policies and procedures |
Yes |
Yes |
Yes |
|
DTS (Data Transformation Services) |
Yes |
Yes |
Yes |
|
Hardware/RAID |
Yes |
Yes |
Yes |
|
Indexing, index statistics updating and index optimization |
Yes |
Yes |
Yes |
|
Install/Configure/Upgrade |
Yes |
Yes |
Yes |
|
Load balancing |
Yes |
Yes |
Yes |
|
Logical design (schema) |
Yes |
Yes |
Yes |
|
Migration |
Yes |
Yes |
Yes |
|
Monitoring, including DBCC (Database Consistency Checking) |
Yes |
Yes |
Yes |
|
NT |
NT, Win 2000 |
NT, Win 2000 |
|
|
Yes |
Yes |
Yes |
|
|
OLAP (Data warehousing) |
Yes |
Yes |
Yes |
|
OLTP |
Yes |
Yes |
Yes |
|
Performance Tuning (Optimization) |
Yes |
Yes |
Yes |
|
Physical design |
Yes |
Yes |
Yes |
|
Query Optimization |
Yes |
Yes |
Yes |
|
Replication |
Yes |
Yes |
Yes |
|
Security (User) administration |
Yes |
Yes |
Yes |
|
SQL |
Yes |
Yes |
Yes |
|
SQL Server end of architecture (2-tier, 2½-tier, 3-tier
& other n-tier) |
Yes |
Yes |
Yes |
|
SQL Server end of ecommerce solutions |
Yes |
Yes |
Yes |
|
SQL Server vendor relations |
Yes |
Yes |
Yes |
|
Stored procedures, triggers, constraints, views |
Yes |
Yes |
Yes |
|
Tables, fields (columns), records (rows) - creation and
updating |
Yes |
Yes |
Yes |
|
Troubleshooting |
Yes |
Yes |
Yes |