• Classroom
  • Online, Instructor-Led
Course Description

This course provides the knowledge and skills to create a Data Warehouse model from an OLTP (On-Line Transaction Processing) system and then design the dimensions and facts for meeting the requirements of the OLAP (On-Line Analytical Processing) system or Data Mart. Presented in a lecture and workshop format, participants will construct star schemas and learn Data Warehouse modeling and design through hands-on techniques and exercises.

Learning Objectives

Provides the knowledge and skills to create a Data Warehouse model from an OLTP (On-Line Transaction Processing) system and then design the dimensions and facts for meeting the requirements of the OLAP (On-Line Analytical Processing) system or Data Mart

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.