This Competency Exam tests your mastery of the objectives for the courses that make up the Using Structured Query Language (SQL) series:
- SQL Fundamentals
- Coding SQL Statements in a Free-Form RPG Program
- Coding SQL Statements in an RPG Program
- Coding SQL Statements in a COBOL Program
- SQL Stored Procedures
The exam is divided into separate parts, one for each course in the series. Successfully completing all parts of the exam demonstrates your proficiency in the skills required to code SQL statements and develop SQL applications.
Approximate time to complete all parts of the exam: 2 hours
This Competency Exam was designed as a mastery test for the Using Structured Query Language (SQL) series. We recommend that you take the exam after you complete the series. Alternatively, you can take the corresponding portion of the exam when you complete each course.
Another use for the Competency Exam is as a pretest. Depending on your previous experience and training, you may feel that you already know the material covered by a given course. If this is the case, you should take the exam corresponding to that course. If you successfully complete the exam, you can skip the course, confident that you have already mastered the skills it teaches.
The exam automatically evaluates your performance and reports how you did. To "pass" the exam, you must successfully work at least 80% of the exercises corresponding to each topic. If you score less than 80%, you will be directed to the appropriate course for review.
The Using Structured Query Language (SQL) series, including this exam, is intended for programmers who will code SQL statements and/or develop applications that include SQL statements.
All courses in this series assume that you have a basic knowledge of DB2. You can satisfy this prerequisite by successfully completing the course Introduction to DB2.