This course introduces the principles of relational databases and relational database design. Business requirements will be incorporated into a logical data model. The components of a logical data model are defined and represented as an entity relationship diagram and table diagrams. Table construction rules and data normalization rules will be discussed as well as supertypes, subtypes and recursive relationships. The methodologies discussed are applicable to any relational database environment, including IBM DB2, the Oracle database, Microsoft SQL Server, the open-source MySQL and PostgreSQL databases as well as other RDBMS platforms.
- Data modeling theory, concepts & terminology
- Benefits of data modeling
- Building an initial data model by identifying entities, attributes & relationships
- Increasing the accuracy of the model by finding & fixing attribute mistakes and resolving many to many relationships
- Object oriented modeling of entities (super and sub entities) & relationships (exclusive arcs)
- Object oriented modeling of domains & types
- Modeling time-dependency or historical (audit) information
- Identifying classic structures & patterns such as role entities, or structure entities for many to many recursive relationships
- Normalization and denormalization
- Producing and understanding an entity relationship diagram
- Logical to physical model transformation
This course is designed for all database professionals and non-technical professionals including:
- Database Administrators
- Application Designers
- Business Analysts
- Others concerned with logical database design
- Data Models
No mandatory prerequisites, but basic knowledge of computer systems and business system requirements are helpful.
Students will understand the principles and tasks of relational data modeling and be able to communicate using relational database terminology. Students will also be able to translate business requirements into logical data models.
- Student Manual
- Lecture and discussion followed by team-based workshops for each major topic to reinforce the material.
- Each participant will receive an extensive lecture guide with several examples and workshop solutions.
- O120 – Oracle SQL Fundamentals
- O125 – Oracle PL/SQL Fundamentals
No Reviews found for this course.