Overview
This course engages students to analyze complex business scenarios and create a data model—a conceptual representation of an organization’s information. This course culminates with a project that challenges students to design, implement, and demonstrate a database solution for a business or organization.
Upon completion this course, Student :
– will given a completion sertificate from Oracle Academy Polinela
– Could take 1Z0-006: Oracle Database Foundations in Pearsonvue testing center.
Introduction
• Introduction to the Oracle Academy
• Data vs. Information
• History of the Database
• Major Transformations in Computing
Entities and Attributes
• Conceptual and Physical Models
• Entities, Instances, Attributes, and Identifiers
• Entity Relationship Modeling and ERDs
Relationship Basics
• Identifying Relationships
• ER Diagramming Conventions
• Speaking ERDish & Drawing Relationships
• Matrix Diagrams
Super/Sub Types and Business Rules
• Supertypes and Subtypes
• Documenting Business Rules
Relationship Fundamentals
• Relationship Transferability
• Relationship Types
• Resolving Many-to-Many Relationships
• Understanding CRUD Requirements
UIDs and Normalization
• Artificial, Composite, and Secondary UIDs
• Normalization and First Normal Form
• Second Normal Form
• Third Normal Form
Arcs, Hierarchies, and Recursive Modeling
• Arcs
• Hierarchies and Recursive Relationships
Changes and Historical Modeling
• Modeling Historical Data
• Modeling Change: Time
• Modeling Change: Price
• Drawing Conventions for Readability
Mapping
• Introduction to Relational Database Concepts
• Basic Mapping: The Transformation Process
• Relationship Mapping
• Subtype Mapping
Creating Database Projects
• System Development Life Cycle
• Project Overview and Getting Started
• Presentation Project Management
• Final Presentation Components
• Preparing Written Documentation
• Preparing Visual Materials
• Final Presentations
Leave a Reply