The learner will build the base backend by planning the database model, implementing Postgres tables and migrations, creating scripts to load and verify dataset imports, developing repository and endpoint layers, and adding tests/smoke checks to ensure reliable queries and stable behavior over time.
Overview
Syllabus
- Unit 1: Loading Data into Postgres
- Creating the Netflix Database Schema
- Building Command Line Arguments Parser
- Implementing Core Data Loading Functions
- Transforming Raw Data into Relational Structure
- Completing the Data Pipeline Integration
- Documenting the Data Verification Script
- Implementing the Database Verification Script
- Unit 2: Designing AGENTS.md Files
- Generate Your AI Assistant Handbook
- Refining Your AI Assistant Handbook
- Document Your Database Schema for Codex
- Unit 3: Creating Database Repositories
- Building Database Configuration from Environment
- Building Connection Pools and Repository Layer
- Implementing the Show Repository Layer
- Generating a README file
- Unit 4: Adding User Reviews
- Adding User Tables to Schema
- Verifying User Tables in Database