1D0-441

(1D0-441) Database Specialist

SYNOPSIS • CIW Professional ^vs • Master CIW Enterprise Dev ^vs

CIW’s exam 1D0-441, “CIW Database Specialistâ€‌ is an elective requirement for the CIW Professional certification, and one of the requirements for the Master CIW Enterprise Developer certification.

It is designed for candidates who “are responsible for designing, implementing, and maintaining database schemas; designing and developing database client applications and components; and performing database administration and maintenance.â€‌ These candidates typically fulfill these roles: application developers, programmers, enterprise developers, Web developers and database developers.
The prerequisites for this exam are: 1) to fill out the on-line CIW Certification Agreement; and 2) to hold the CIW Associate certification. CIW also recommends, but does not require, that “students seeking Master CIW Enterprise Developer status to take (and pass) the CIW Web Languages (JavaScript and Perl), CIW Application Developer, Sun/jCert Java Programmer, and CIW Object-Oriented Analysis and Design with UML exams prior to the CIW Database Specialist exam.â€‌

This exam is easy to moderately difficult and costs $125 USD. It may be taken from Pearson Vue or Thomson Prometric.

The pass score for this form-based multiple choice exam is 75%. There are 54 questions and the exam has a duration of 75 minutes.

The topics covered by this exam include:

• 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

For more information:
http://www.ciwcertified.com/exams/1d0441.asp?comm=home&llm=3