Database Designing and Modeling

Faculty profile:

Real time professionals with 15+ years of experience.

Duration:

25 Hours

Audience:

Database Administrators, Oracle Developers

Course Topics:

Conceptual Modeling

Logical Data Modeling

Data Modeling Relations

Data Modeling Standards

Physical Data Modeling

    • Choosing Index
    • Data Pruning Methodolgies
    • Partitioning
    • Case Studies
    • Indexing
    • Data Pruning
    • Partitions
    • PL/SQL Optimization for ETL

 Relational Modeling.

    • Normalization
    • Normalization Case Studies
    • Denormalizing

 Dimensional Modeling

    • Dimension
    • FACTS
    • Slowly Changing Dimensions
    • Star Schema
    • Snowflake Schema

 Case Studies

    • Star Schema
    • Slowly Changing Dimension
    • Snowflake