|
Prerequisites: Basic Overview
and PDM. Students should have a basic understanding of programming
concepts.
Audience: This course is designed for programmers and
managers who have minimal or no understanding of iSeries
database concepts.
Description: The purpose of this course is to introduce
students to relational database design concepts. It demonstrates the
correct implementation of database files in the iSeries
environment. Upon course completion, each student should be able to
design a normalized database utilizing reference, physical, logical
and join files.
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.
Duration: Two Days
Click here to register on-line or review
our current Course Schedule.
Download
class flier in PDF format.
|