|
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:
o
Database
management systems (DBMS), and advantages and disadvantages of using a DBMS.
o
Relational
model terminology, relational tables and their characteristics.
o
Database
design life cycle and aspects of database planning.
o
Relational
database design methodology and phases of database design.
o
Normalization
processes and normal forms.
o
Design issues
related to logical and physical database design.
o
Database
definition languages.
o
Structured
Query Language (SQL) commands and syntax.
o
Relational
algebra and concepts related to relational algebra.
o
JDBC API
architecture and implementation of relational database management systems.
o
Establishment
of database connections.
o
Table and
query manipulation in a database using JDBC.
o
SQL statement
storage and execution.
o
Prepared
statements and stored procedures with database management systems (DBMS).
o
DBMS or
database metadata.
o
Scrollable
and updatable result sets.
o
Batch updates
(a new function of JDBC 2.0 that increases efficiency).
o
Graphical
database clients.
|