AS/Credentials System i Relational Database Class

The purpose of this course is to introduce students to relational database design concepts. It demonstrates the correct implementation of database files in the System i environment. Upon course completion, each student should be able to design a normalized database utilizing reference, physical, logical and join files. This course is designed for programmers and managers who have minimal or no understanding of System i database concepts.

Class Details:

• Prerequisites: Basic Overview and PDM. Students should have a basic understanding of programming concepts.
• Duration: Two Days
• Cost: $450/day
• Associated Roadmap
• Downloadable flyer

Course Content:

• Explanation of physical and logical files and the differences between the two.
• Structure of a physical file such as record formats, access paths, and data members.
• Data file management of Structured Query Language (SQL) and Data Description Specifications (DDS).
• Explanation of files, records and field level key words. Concepts such as editing, naming, and various data types will be discussed.
• Creation of physical and logical files and the description maintenance.
• Concepts behind the access path process, such as join files, open query files, multi-format files, and access path sharing.
• Explanation and examples of the database normalization process.
• Performance considerations for file sharing, record locking, access path maintenance and the open data path.
• Advanced database concepts such as: check constraints, referential constraints and trigger programs are also covered.