SKILLS MEASURED

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.

Relational model terminology, relational tables and their characteristics.

Database design life cycle and aspects of database planning.

Relational database design methodology and phases of database design.

Normalization processes and normal forms.

Design issues related to logical and physical database design.

Database definition languages.

Structured Query Language (SQL) commands and syntax.

Relational algebra and concepts related to relational algebra.

JDBC API architecture and implementation of relational database management systems.

Establishment of database connections.

Table and query manipulation in a database using JDBC.

SQL statement storage and execution.

Prepared statements and stored procedures with database management systems (DBMS).

DBMS or database metadata.

Scrollable and updatable result sets.

Batch updates (a new function of JDBC 2.0 that increases efficiency).

Graphical database clients.