Databases – (Traditional and Columnar) and Data Modeling - Logical/Physical, Relational/3NF modeling (Operational/Application Data Stores), Canonical Modeling, Data Vault Modeling and Dimensional modeling (Data Warehouses, Data Marts) including handling slowly changing dimensions, aggregations,
Data Architecture –Data Vault 2.0, Entity-Relationship diagrams, Star/Snow Flake Schema Designs, Data Governance, Data Security/Access Strategies
Data Warehousing - Decision Support Systems (DSS), Online transactional processing (OLTP) and Data warehouse/Business Intelligence (BI) applications