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
- Implementing Business Rules Using Constraints and Triggers
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 working knowledge of basic IBM i concepts and facilities. You can satisfy this prerequisite by successfully completing the courses in the following series:
The courses also assume you familiar with IBM i programming concepts and facilities. You can satisfy this prerequisite by successfully completing the courses in the following series:
In addition, the three courses that cover how to embed SQL statements within a high-level language program also assume that you are an experienced RPG or COBOL programmer. Of these courses, you need to take only the single course that corresponds to your preferred programming language.