Overview
Students will learn the importance of creating business requirements and data artifacts that define the data in a "Single Version of Truth." From ingesting data into a staging database, moving the data to the operational data store where data is transformed, to ultimately accessing the data warehouse.
Students will learn how the data warehouse helps eliminate data silos and bring data from across the enterprise into one central system, which can be governed and accessible by anyone in the enterprise to understand and analyze intelligent insights to address business challenges and opportunities. The Designing Data Systems program is offered by Udacity.
Course Skills
- Designing Data Systems
- Data architecture fluency
- Data staging
- Data ingestion
- Star schemas
- ELT
- Erds
- SQL queries
- Database normalization
- Data cleaning
- Database schemas
- Data dictionaries
- Snowflake schemas
- Data definition
- Online transactional processing models
- Operational data store models
- Online analytical processing models
Programme Structure
Courses include:
- Data Architecture
- Staging Data
- Operational Data Store
- Data Warehouse
- Project: Design a Data Warehouse for Reporting and OLAP
Key information
Duration
- Part-time
- 2 days
Start dates & application deadlines
Language
Delivered
Campus Location
- Mountain View, United States
Disciplines
Design Data Science & Big Data View 467 other Short Courses in Data Science & Big Data in United StatesWhat students do after studying
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
Prior to enrolling, you should have the following knowledge:
- JSON
- Relational database basics
- Intermediate SQL
Tuition Fees
Additional Details
- This program can be paid for with the Udacity subscription.