Yiga AI

Course 9 of 11

Database Design Basics

Tables & keys, Normalisation, Schemas, and more.

Yiga AI

Beginner en

Beginner · Course · 3 weeks at 5 hrs/week

Duration
3 weeks
Effort
5 hrs/week
Lessons
16
Hands-on exercises
16
Projects
1
Language
en

What you’ll learn

Skills you can put to work.

Introduction to SQL

Joining Data in SQL

Intermediate SQL

Window Functions & Advanced SQL

Syllabus

Every module, step by step.

4 modules · 21 lessons · 14 hours · 1 graded project

840 minutes of guided lesson time.

Sign in and enrol to unlock every lesson. The first lesson is open as a preview.

Module 1 · 5 lessons · 3 hoursTables & keysModule 1 of 4 in Database Design Basics.

  1. Overview and set-up

    Overview and set-up — Tables & keys in Database Design Basics.

    Lesson

    40 min

  2. Core concepts

    Core concepts — Tables & keys in Database Design Basics.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Tables & keys in Database Design Basics.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Tables & keys in Database Design Basics.

    Lesson · Locked

    40 min

  5. Module quiz: Tables & keys

    Check what you learned in Tables & keys before moving on.

    Quiz · Locked

    20 min
Module 2 · 5 lessons · 3 hours LockedNormalisationModule 2 of 4 in Database Design Basics.

  1. Overview and set-up

    Overview and set-up — Normalisation in Database Design Basics.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Normalisation in Database Design Basics.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Normalisation in Database Design Basics.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Normalisation in Database Design Basics.

    Lesson · Locked

    40 min

  5. Module quiz: Normalisation

    Check what you learned in Normalisation before moving on.

    Quiz · Locked

    20 min
Module 3 · 5 lessons · 3 hours LockedSchemasModule 3 of 4 in Database Design Basics.

  1. Overview and set-up

    Overview and set-up — Schemas in Database Design Basics.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Schemas in Database Design Basics.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Schemas in Database Design Basics.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Schemas in Database Design Basics.

    Lesson · Locked

    40 min

  5. Module quiz: Schemas

    Check what you learned in Schemas before moving on.

    Quiz · Locked

    20 min
Module 4 · 6 lessons · 5 hours LockedIndexesModule 4 of 4 in Database Design Basics.

  1. Overview and set-up

    Overview and set-up — Indexes in Database Design Basics.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Indexes in Database Design Basics.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Indexes in Database Design Basics.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Indexes in Database Design Basics.

    Lesson · Locked

    40 min

  5. Module quiz: Indexes

    Check what you learned in Indexes before moving on.

    Quiz · Locked

    20 min

  6. Graded project: Database Design Basics

    Apply everything from Database Design Basics in one graded, portfolio-ready build.

    Graded project · Locked

    120 min

Applied learning project

Make the learning visible.

Use Graded project: Database Design Basics to apply this course to a practical challenge. You’ll finish with a clear solution and the reasoning behind your choices.

Apply the course’s core skillMake and explain practical decisionsCreate evidence you can share
Daniel O., Data & analytics

Your instructor

Daniel O.

Data & analytics

Turns real African data problems into practical lessons learners can apply immediately.

Brian Okello, Yiga learner

“The course content made machine learning understandable, and the practice kept me moving.”

Brian Okello

Software developer, Kampala

Continue with

Your next best step.

Following the order of Data Analyst with SQL & Power BI.

See the full chain

Next lesson

Overview and set-up

Database Design Basics

40 min · Resume

Course 10 in the track

Introduction to SQL

Databases, SELECT, Filtering, and more.

Beginner · Course · 3 weeks at 5 hrs/week

Course 11 in the track

Joining Data in SQL

Inner/outer joins, Self joins, Set operations, and more.

Beginner · Course · 3 weeks at 5 hrs/week

Learner reviews

What learners say.

Write a review

Sign in to share your experience with this course.

Sign in to review

Loading reviews…

Previous courseDAX FundamentalsNext courseIntroduction to SQL

Keep going

Other courses in this track.

View full track