Jump to content

CIW Certification/Study Guides/Database Specialist Exam

From Wikibooks, open books for an open world

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.

[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]
[edit | edit source]

Database definition languages.

[edit | edit source]

Structured Query Language (SQL) commands and syntax.

[edit | edit source]
[edit | edit source]

JDBC API architecture and implementation of relational database management systems.

[edit | edit source]

Establishment of database connections.

[edit | edit source]

Table and query manipulation in a database using JDBC.

[edit | edit source]

SQL statement storage and execution.

[edit | edit source]

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

[edit | edit source]

DBMS or database metadata.

[edit | edit source]

Scrollable and updatable result sets.

[edit | edit source]

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

[edit | edit source]

Graphical database clients.

[edit | edit source]