Database Design & SQL for Developers
By the end of this course, learners should be able to explain Model schemas, write efficient SQL, index wisely, and keep migrations safe in production.
Model schemas, write efficient SQL, index wisely, and keep migrations safe in production.
Skills you will develop
Relational databases and SQL · SQL for analysts
Skills you’ll develop
Course completion demonstrates these skills. Verification requires assessment or reviewed challenge work.
What you will build and prove
- Practice: Practice: Lesson 2: Ship a secure authenticated API feature
- Quiz: Lesson 2: Ship a secure authenticated API feature check (pass 70%)
- Final assessment: Database Design & SQL for Developers — course assessment (pass 70%)
Course journey
How this free course is structured — watch, practise, and progress module by module.
- Week 1: Foundations
- Week 2: Core Concepts
- Week 3: Applied Patterns
- Week 4: Ship Your Project
Practice
1 optional practice exercise — apply what you learned. Practice is not required to complete the course.
Assessment
- Lesson 2: Ship a secure authenticated API feature check · pass mark 70%
- Database Design & SQL for Developers — course assessment · pass mark 70%
Prove
Course completion means finishing required lessons , and the course assessment . That grants a certificate of completion — not a professional certification. Optional practice does not block completion.
Curriculum
Week 1: Week 1: Foundations
- Lesson 1: Set up your backend development environment Preview 14min
- Lesson 2: Project structure for APIs and services 15min
- Lesson 3: Configure databases and environment secrets 16min
Week 2: Week 2: Core Concepts
- Lesson 1: Design RESTful endpoints and status codes 16min
- Lesson 2: Validate input and shape API responses 17min
- Lesson 3: Model data with migrations and relations 18min
Week 3: Week 3: Applied Patterns
- Lesson 1: Backend engineering fundamentals 18min
- Lesson 2: Ship a secure authenticated API feature 19min
- Lesson 3: Work with databases, caches, and queues 20min
Week 4: Week 4: Ship Your Project
- Lesson 1: Backend engineering fundamentals 20min
- Lesson 2: Ship a secure authenticated API feature Practice 21min
- Lesson 3: Work with databases, caches, and queues 22min
Free to enroll — no purchase required.
Instructor: Africoders
Start learning Already have an account? Sign in Course forum →