Conviértete en experto en bases de datos: planes de ejecución, tuning, particionamiento, sharding, full-text search, replicación, alta disponibilidad, seguridad y SQL moderno (SQL/PGQ, pgvector). 6 cursos · 72 módulos interactivos.
EXPLAIN ANALYZE, costos, join strategies, parallel query, JIT, work_mem, connection pooling, bloat.
RANGE/LIST/HASH, sub-partitioning, MERGE/SPLIT, postgres_fdw, Citus, Vitess, shard key design.
tsvector/tsquery, GIN, pg_trgm, fuzzystrmatch, unaccent, ranking, diccionarios, búsqueda híbrida.
WAL, streaming/logical replication, failover, pg_rewind, pgBackRest, PITR, CDC con Debezium.
GRANT/REVOKE, RLS, SSL/TLS, SCRAM, pg_hba.conf, pg_tde, pgaudit, SQL injection prevention.
MERGE, GENERATED, FILTER, GROUPING SETS, CUBE, PIVOT, SQL/PGQ, pgvector, DuckDB, LATERAL, temporal tables.