Month 6 of 10
Databases & Web APIs (SQL & Flask)
Every app needs a backbone — databases and APIs are yours.
About This Month
What you'll experience in Month 6
Every application that stores, retrieves, and shares data relies on databases and APIs. Month 6 teaches you to design relational databases with SQL, query data efficiently with PostgreSQL, and expose that data through clean REST APIs built with Python's Flask framework. You will understand how the web actually works at the protocol level, design real database schemas, and build the kind of backend that powers modern web and mobile applications.
What You'll Learn
Concrete skills you'll walk away with after this month
Design normalised relational database schemas from real-world requirements
Write confident SQL: SELECT, JOIN, GROUP BY, subqueries, and transactions
Set up and manage a PostgreSQL database server
Build RESTful APIs with Flask following HTTP standards
Authenticate API users with token-based authentication
Connect a Python application to a database using an ORM
Test and document APIs using tools like Postman
Technologies & Tools
What you'll be working with this month
SQL
PostgreSQL
Flask
REST APIs
SQLAlchemy ORM
HTTP / JSON
Postman
Authentication
Week-by-Week Breakdown
A detailed look at what you'll build each week
Week 21
SQL & Relational Database Design
Tables, relationships, normalization, and essential SQL queries from scratch.
Week 22
PostgreSQL & Advanced Querying
Set up PostgreSQL, write complex joins, and manage database migrations.
Week 23
Flask & REST API Fundamentals
Build HTTP endpoints, handle routing, request parsing, and return JSON responses.
Week 24
Capstone: Full Backend API Project
Design and deploy a complete REST API with authentication, CRUD operations, and a real database.
Full 10-Month Curriculum
Explore every module in the programme
Month 1
Engineering Foundations
Month 2
Linux & Shell Scripting
Month 3
Systems Programming in C
Month 4
Data Structures & Algorithms
Month 5
Python Programming
Month 6
Databases & Web APIs
Month 7
Frontend Web Development
Month 8
Advanced Frontend
Month 9
DevOps & React
Month 10
Mobile & Full-Stack Capstone