Month 6 · Week 21 of 40

Relational Databases & SQL Foundations

Transition from flat files to relational databases.

Enroll Now to Start Week 21 View Month 6 Overview

Week Overview

Discover why modern backends rely on relational database management systems (RDBMS). Learn table design, primary keys, foreign keys, and standard SELECT/INSERT/UPDATE/DELETE queries.

Core Concepts & Topics

RDBMS Concepts & ACID Guarantees

Creating Tables with Data Types & Constraints

Primary Keys, Foreign Keys & Cascading Deletes

Filtering with WHERE, LIKE, IN, BETWEEN

Sorting and Pagination (ORDER BY, LIMIT, OFFSET)

Hands-On Challenge

Week 21 Project: CSV Data Analyzer that imports raw sales data into a structured SQLite/PostgreSQL database.

Every week at DoxaTech Hub requires submitting real working code tested by our automated grading suite. You will push code to your personal GitHub repository, open pull requests, and receive instant feedback.

Frequently Asked Questions

What is a Foreign Key?

A foreign key is a column in a table that references the primary key of another table, establishing a relationship and enforcing referential integrity.

Week 20: Library Management Automation System

Week 22: Advanced SQL & Database Normalization

Interactive Learning