RDBMS Solutions, OCC

OLTP/OLAP Career Center

 

 

 

HOME PAGE

SQL Server Site Map

Oracle Site Map

RDBMS Site Map

 

 

 

 

 

 

RDBMS Skills Matrix v1.2

 

 

This is the core skill set necessary to obtain certification as a Sybase, Informix, DB2, or other RDBMS (not including SQL Server and Oracle) database administrator.

 

 

 

Skill

Backup/Recovery

Batch processing

Export/Import

Capacity planning

Clustering and redundancy design

Daily maintenance

Database maintenance plans, scheduling, alerts

DCL/DDL/DML

Devices and databases design, creation, and updating

Disaster Recovery

Documentation - policies and procedures

Hardware/RAID

Indexing and index optimization

Install/Configure/Upgrade

Load balancing

Logical design (schema)

Migration

Monitoring

Network/OS - NT, Windows 2000, Unix

Normalization

OLAP (Data warehousing)

OLTP

Performance Tuning (Optimization)

Physical design

Query Optimization

Replication

Security (User) administration

SQL

RDBMS end of architecture (2-tier, 2-tier, 3-tier & other n-tier)

RDBMS end of ecommerce solutions

RDBMS vendor relations

Stored procedures, triggers, constraints, views

Tables, fields (columns), records (rows) - creation and updating

Troubleshooting