Skip to main content

Course

Database Design

Beginner

4.7+

Updated 05/2025

Learn to design databases in SQL to process, store, and organize data in a more efficient way.

Start Course for Free

Included withPremium or Teams

SQLData Engineering4 hours13 videos52 Exercises4,150 XP92,644Statement of Accomplishment

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Course Description

A good database design is crucial for a high-performance application. Just like you wouldn't start building a house without the benefit of a blueprint, you need to think about how your data will be stored beforehand. Taking the time to design a database saves time and frustration later on, and a well-designed database ensures ease of access and retrieval of information. While choosing a design, a lot of considerations have to be accounted for. In this course, you'll learn how to process, store, and organize data in an efficient way. You'll see how to structure data through normalization and present your data with views. Finally, you'll learn how to manage your database and all of this will be done on a variety of datasets from book sales, car rentals, to music reviews.

Prerequisites

Introduction to Relational Databases in SQL

1

Processing, Storing, and Organizing Data

OLTP and OLAP

OLAP vs. OLTP

Which is better?

Storing data

Name that data type!

Ordering ETL Tasks

Recommend a storage solution

Database design

Classifying data models

Deciding fact and dimension tables

Querying the dimensional model

2

Database Schemas and Normalization

Star and snowflake schema

Running from star to snowflake

Adding foreign keys

Extending the book dimension

Normalized and denormalized databases

Querying the star schema

Querying the snowflake schema

Updating countries

Extending the snowflake schema

Normal forms

Converting to 1NF

Converting to 2NF

Converting to 3NF

3

Database Views

Database views

Tables vs. views

Viewing views

Creating and querying a view

Managing views

Creating a view from other views

Granting and revoking access

Updatable views

Redefining a view

Materialized views

Materialized versus non-materialized

Creating and refreshing a materialized view

Managing materialized views

4

Database Management

Database roles and access control

Create a role

GRANT privileges and ALTER attributes

Add a user role to a group role

Table partitioning

Reasons to partition

Partitioning and normalization

Creating vertical partitions

Creating horizontal partitions

Data integration

Data integration do's and dont's

Analyzing a data integration plan

Picking a Database Management System (DBMS)

SQL versus NoSQL

Choosing the right DBMS

Database Design

Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

Included withPremium or Teams

Don’t just take our word for it

*4.7

from 1,748 reviews

82%

15%

2%

0%

0%

Highest to Lowest
Lowest to Highest
Most recent
Top reviews

Paul

23 minutes

Good overview of DB design. Enjoyed it.

João

about 1 hour

Cian

about 2 hours

Judith

about 3 hours

Peerawas

about 4 hours

Patryk

about 5 hours

"Good overview of DB design. Enjoyed it."

Paul

João

Cian

FAQs

Join over 16 million learners and start Database Design today!

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.