Cursos en esta ruta
Data Modeling And Database Design
Learn to design the schema of a relational database: from a real-world problem to a model, covering entities, attributes, relationships, keys, normalization, integrity constraints, types, and indexes. You work by modeling Reservo, a coworking room-booking system, from the entity-relationship diagram all the way to the full DDL. You come out knowing how to design a correct, normalized schema with integrity guaranteed by the database itself, and knowing when to denormalize with judgment.
64 lecciones
Advanced Sql Querying
Learn to query a relational database with real SQL: JOINs in depth, aggregation, subqueries, CTEs (including recursive ones), window functions, and query optimization by reading the execution plan. You work on Reservo's database, a coworking room-booking system, and come out knowing how to answer complex business questions with a single query that's well written, readable, and efficient. It closes with a full analytical report: revenue by room and by month, top members by spend, occupancy, refund rate, and ranking.
64 lecciones
Data Quality And Sql Testing
Learn to measure and guarantee data quality with SQL, and to test the SQL itself. Data quality shows up in a large share of data job postings: it's about detecting incomplete, invalid, duplicate, and inconsistent data, encoding business rules as queries that return the violations, and proving your queries and migrations produce the correct result. You work on Reservo's database, populated on purpose with real dirty data, and come out knowing how to build a data quality checking system that runs and reports.
64 lecciones
Sql For Llms And Agents
Learn the engineering behind having an LLM or agent generate and execute SQL safely and reliably against your database: text-to-SQL. This guide covers how to give the model the schema as context (serializing `CREATE TABLE`, sample rows, relationships, and the token budget), how to prompt for correct SQL (few-shot, fixing the dialect, constraint instructions), how to validate and execute generated SQL before trusting it (is it a `SELECT`? does it reference real tables?), security guardrails (read-only, blocking destructive statements, row limits, anti-injection, least privilege), the SQL agent loop (question → SQL → validate → run → correct → answer, with the `run_sql` tool), and how to evaluate a text-to-SQL assistant with execution accuracy. Everything is built on top of the Reservo database with sqlite3; the LLM call is shown as a realistic example using the Claude API. It closes with a capstone project: a safe, measurable, end-to-end SQL assistant for Reservo.
64 lecciones
SQL Patterns for Production APIs Guide
Master the SQL patterns every production multi-tenant API needs: cursor pagination (17x faster than OFFSET on deep pages), correct soft deletes, audit logs, Row-Level Security multi-tenancy, zero-downtime migrations, optimistic locking, schema versioning, and bulk operations with COPY — fully integrated with FastAPI and SQLAlchemy 2.0 async.
64 lecciones
Database Performance & Query Tuning Guide
Master PostgreSQL performance tuning for FastAPI: deep EXPLAIN ANALYZE reading, advanced indexing (composite, covering, partial, expression, GIN), eliminating the N+1 problem in SQLAlchemy, query profiling with `pg_stat_statements` and `auto_explain`, PgBouncer pooling, autovacuum tuning, and refactoring scaling anti-patterns.
64 lecciones
Advanced PostgreSQL for Backend Guide
Master PostgreSQL's advanced features for production backend apps: deep JSONB with operators and GIN indexes, full-text search in Spanish as an Elasticsearch replacement, native partitioning for massive tables, materialized views for in-DB analytics, advisory locks as a Redis replacement, savepoints for nested transactions, useful extensions (`pg_trgm`, `citext`, `uuid-ossp`, `hstore`), and recursive CTEs for hierarchies and graphs.
64 lecciones
Database Migrations And Cicd
Learn to change a production database's schema and data without breaking it: the migration as a versioned, ordered, repeatable, and reversible change. It covers `ALTER TABLE` and the table-rebuild pattern, data migrations with backfills, the expand/contract pattern for zero downtime, and database CI/CD — applying migrations, running quality checks and tests in a pipeline, with quality gates and rollback. You evolve Reservo's database through a real series of migrations and come out knowing how to build and operate a production migration system.
64 lecciones
Technical English and Employability
Learn to work and apply for jobs in English: read documentation without translating, write PRs, bug reports, and design documents in plain English, hold your own in a standup and a demo out loud, and run a job search with market judgment. The seven modules start from your actual target — the role, the market, and the English gap that separates you from it — and move through the fundamentals of reading and listening to technical English, written async communication (chat, issues, PRs, commits), writing technical documents in plain language (design docs, ADRs, READMEs, postmortems), spoken technical English (standups, meetings, pair programming, demos), your professional materials (an ATS-ready résumé, LinkedIn, portfolio), and the full hiring process. The final project is the Employability Kit: a cumulative, interview-defensible dossier with your target-role brief, a portfolio with a design doc and ADR, an async communication package, a tailored résumé, and three unscripted English recordings — a pitch, a demo, and a mock interview.
56 lecciones