Skillnaija Start free

DATA & TECH

Database Design for Beginners

Design databases that don't become a mess — the skill behind every app, dashboard and backend job.

  • 7 lessons
  • ~2 hours
  • Beginner-friendly
  • Project + certificate

Free account required to open the lessons. Any price is shown before you pay.

What you'll learn

  • Relational thinking: tables, rows, columns, keys
  • Primary and foreign keys and relationships
  • Normalisation to remove duplication and mess
  • Choosing data types and constraints
  • Writing SQL — SELECT, INSERT, UPDATE, DELETE, JOIN
  • Designing a schema for a real app
  • Knowing when to use SQL vs NoSQL

About this course

Learn to design clean, reliable databases the way working developers do: tables, keys and relationships, normalisation, data types and constraints, real SQL (SELECT, INSERT, UPDATE, DELETE and JOINs), and when to reach for SQL versus NoSQL. By the end you will design a full schema for a real app (a shop or school) and write five useful SQL queries — the exact proof that lands backend, data and remote developer work paid in naira and dollars.

A database is the organised store at the heart of nearly every app — and someone has to design it so it does not lose data or turn into a mess. That designer is what you are becoming.

Who it's for

Beginner-friendly. You can start from scratch: no prior experience is assumed.

The lessons 7 lessons, ending in a graded project

  1. 1What a database is and why this skill pays12 min
  2. 2Tables, rows, columns and keys: the building blocks13 min
  3. 3Relationships: one-to-many, many-to-many and how to connect tables13 min
  4. 4Data types and constraints: rules that keep data clean13 min
  5. 5Normalisation: splitting data so it never becomes a mess13 min
  6. 6Writing SQL: SELECT, INSERT, UPDATE, DELETE14 min
  7. 7JOINs, plus SQL vs NoSQL: bringing it together and choosing your tool14 min
  8. Project: Design a Database Schema and Write 5 Useful SQL QueriesGraded

THE PROJECT AND YOUR CERTIFICATE

Design a Database Schema and Write 5 Useful SQL Queries

A shared link (Google Doc, GitHub README, Notion, or dbdiagram.io) containing: a short app description, a schema of at least 4 tables with data types and key constraints, clearly marked relationships including at least one many-to-many junction table, and 5 working SQL queries (with a SELECT+WHERE, an INSERT, an UPDATE/DELETE with WHERE, and a JOIN), each explained in plain English.

Certificates on Skillnaija are earned, not issued for attendance: you submit this project, an examiner grades the real work against a published rubric (you need 65% to pass), and passing issues a certificate anyone can verify. If you don't pass yet, you get written feedback and can try again.

  • Schema design: at least 4 well-chosen tables, each with a clear primary key and a sensible data type for every column (VARCHAR for phone/account numbers, DECIMAL for money), reflecting one focused 'thing' per table25%
  • Relationships: all foreign keys are correctly placed and labelled, relationship types (one-to-many / many-to-many) are stated, and at least one many-to-many is correctly handled with a junction table25%
  • Normalisation and constraints: no error-prone duplication (IDs used instead of repeated names/prices), one value per cell, sensible NOT NULL/UNIQUE/DEFAULT constraints, and a note on one duplication removed20%
  • SQL queries: five queries that run against the schema and answer real questions, including a SELECT with WHERE, an INSERT, an UPDATE or DELETE that uses a WHERE, and at least one correct JOIN matching a foreign key to a primary key20%
  • Clarity and presentation: a clear app description, readable diagram/table list, and a plain-English explanation above each query, all in one accessible shared link10%

See the full project brief, rubric and free workbook →

Frequently asked questions

Is Database Design for Beginners free?

Most Skillnaija courses can be started free with a free account: your first two courses are free to start, then one new course each month. Some courses are paid; the course page in the app shows whether Database Design for Beginners is one, and its price, before you pay. You can also buy any course on its own for twelve months, or open every course with the All-Access Pass. Certificates are never sold: you earn one by passing the course's project.

How long does Database Design for Beginners take to complete?

5 weeks · ~4 hrs/week. There are 7 lessons, about 2 hours of material in total. You learn at your own pace and your progress is saved.

Do I need any experience to start Database Design for Beginners?

Beginner-friendly. You can start from scratch — no prior experience is assumed.

What will I learn in Database Design for Beginners?

You will build practical skills in Relational thinking: tables, rows, columns, keys, Primary and foreign keys and relationships, Normalisation to remove duplication and mess, Choosing data types and constraints, Writing SQL — SELECT, INSERT, UPDATE, DELETE, JOIN, Designing a schema for a real app, Knowing when to use SQL vs NoSQL. Every lesson is written in plain English, with examples drawn from how the work is actually done and paid for, in Nigeria and beyond.

Do I get a certificate for Database Design for Beginners?

Yes, but it has to be earned. You complete the course project — Design a Database Schema and Write 5 Useful SQL Queries and submit it for grading. Passing the project issues a verifiable certificate; finishing the lessons alone does not.

Ready to start Database Design for Beginners?

It is self-paced, and it ends with something you can show an employer.

Start learning free