₹0 for students · Certificate · Beginner

Database Design

1 mini course, 5 lessons: modelling data, keys and relationships, normalisation, constraints and transactions

Start free in the app

5 lessons · ~1 hours · 10-question final exam · pass mark 70%

About the course

What you’ll learn

Design databases that stay correct as an app grows. Model entities and relationships, choose keys, link tables with foreign keys and junction tables, normalise away duplication, protect data with constraints and indexes, and keep it consistent with transactions. Practise with SQL exercises that run in the browser. Pass every lesson quiz and the final exam to earn a verifiable certificate.

Database designSQLData modellingNormalisation

Part of the career tracks: Web Developer, Data Analyst, Computer Science Foundations

How the certificate works

  1. Read each lesson’s study guide, then the full lesson and any notebooks or exercises.
  2. Pass every lesson quiz with 70% or more.
  3. Pass the final exam: 10 questions in 20 minutes.
  4. Get a certificate with a public verification link, and add it to LinkedIn.

Syllabus

5 lessons in 1 mini courses

Each mini course takes about an hour. Already know one? Test out in the app and skip it.

1. Designing a database

Model data, link tables, normalise and protect data with constraints and transactions.

1
Modelling Entities and Relationships
12 min · Entities are the things you store; attributes describe them.
2
Keys, Foreign Keys and Junction Tables
12 min · Primary keys uniquely identify rows; prefer stable surrogate keys.
3
Normalisation
12 min · Normalisation stores each fact once to avoid inconsistency.
4
Constraints and Indexes
10 min · Constraints make the database reject bad data from any source.
5
Transactions and ACID
10 min · A transaction makes several statements succeed or fail together.

Written by Vikosha. Lessons, questions and exercises are original. Licence: Original Vikosha course..