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.
- Free to startOpen a free account and start. Any price is shown before you pay.
- Earned, not boughtCertificates are never sold. You pass a graded project, and anyone can verify it.
- Self-pacedShort lessons you take at your own pace. Your progress is saved.
- Built for real workLessons follow how the work is actually done and paid for, and end in a project you can show.
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
- 1What a database is and why this skill pays12 min
- 2Tables, rows, columns and keys: the building blocks13 min
- 3Relationships: one-to-many, many-to-many and how to connect tables13 min
- 4Data types and constraints: rules that keep data clean13 min
- 5Normalisation: splitting data so it never becomes a mess13 min
- 6Writing SQL: SELECT, INSERT, UPDATE, DELETE14 min
- 7JOINs, plus SQL vs NoSQL: bringing it together and choosing your tool14 min
- 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%
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