Udacity Logo
Log InJoin for Free

Data Architecture Foundations

Course

In this course, you will cover the foundations of data architecture.

In this course, you will cover the foundations of data architecture.

Advanced

4 weeks

Real-world Projects

Completion Certificate

Last Updated June 19, 2023

Skills you'll learn:
Erds • Data definition language • Data manipulation language • Data storage
Prerequisites:
Intermediate SQL • Relational database basics

Course Lessons

Lesson 1

Welcome to Data Architecture Foundations

This is the welcome lesson of the course.

Lesson 2

What is Data Architecture

This lesson will cover basic data architecture characteristics, data governance and business requirements.

Lesson 3

Database Framework

This lesson will cover model, schema and normalization

Lesson 4

Relational Data Design

This lesson will cover conceptual, logical and physical ERD, and how to create ERDs

Lesson 5

Creating a Physical Database Schema

This lesson will cover how to create and populate a database and run CRUD command

Lesson 6 • Project

Project: Designing an HR Database

Architect a database based on the business requirements for a Human Resources Department, combining all the skills you've learned so far!

Taught By The Best

Photo of Ben Larson

Ben Larson

Data Architect / Analytics Consultant

Benjamin has over 15 years of experience working as a data professional in fields including medicine, telecomm, and finance, in roles ranging from data architect to data scientist and analytics consultant. He holds a Ph.D. in Decision Sciences, where his research was focused on rare event detection.

The Udacity Difference

Combine technology training for employees with industry experts, mentors, and projects, for critical thinking that pushes innovation. Our proven upskilling system goes after success—relentlessly.

Demonstrate proficiency with practical projects

Projects are based on real-world scenarios and challenges, allowing you to apply the skills you learn to practical situations, while giving you real hands-on experience.

  • Gain proven experience

  • Retain knowledge longer

  • Apply new skills immediately

Top-tier services to ensure learner success

Reviewers provide timely and constructive feedback on your project submissions, highlighting areas of improvement and offering practical tips to enhance your work.

  • Get help from subject matter experts

  • Learn industry best practices

  • Gain valuable insights and improve your skills