A CIW Database Specialist plans and designs relational databases. This individual defines the structure of a database, employs Entity Relationship (ER) diagrams and normalization to optimize databases, builds database client applications, and performs database maintenance and security administration. Skills measured in the 1D0-441 exam include but are not limited to:
Database management systems (DBMS), and advantages and disadvantages of using a DBMS.[edit | edit source]
Relational model terminology, relational tables and their characteristics.[edit | edit source]
Database design life cycle and aspects of database planning.[edit | edit source]
Relational database design methodology and phases of database design.[edit | edit source]
Normalization processes and normal forms.[edit | edit source]
Design issues related to logical and physical database design.[edit | edit source]