| Risk | Probability | Mitigation | | :--- | :--- | :--- | | Oracle changes Live SQL terms | Low | Mirror all scripts for local Docker install (Oracle Free) | | Low student retention | Medium | Gamify with badges (GitHub Actions auto-grading) | | Outdated content (Oracle 24c release) | Medium | Annual review + version tagging in videos | | Competition from MySQL free courses | High | Emphasize enterprise career value (higher salary data) |
| Week | Focus | Resources | |------|-------|------------| | 1 | Database concepts & installation (Oracle XE) | Download Oracle Database 23ai Express Edition (free) | | 2–3 | Basic SQL (SELECT, WHERE, JOINs) | LiveSQL + Dev Gym "SQL Basics" class | | 4 | DDL & DML (CREATE, INSERT, UPDATE, DELETE) | Oracle University free SQL course | | 5 | Functions & grouping (GROUP BY, aggregate functions) | YouTube (Píldoras Informáticas) | | 6 | Subqueries & views | Dev Gym workouts | | 7 | Introduction to PL/SQL (blocks, variables, loops) | Oracle LiveSQL PL/SQL tutorials | | 8–10 | Mini project (e.g., library or sales database) | Oracle Cloud Free Tier + APEX | curso base de datos oracle gratis
: Una plataforma interactiva con cientos de cuestionarios y clases de SQL gratuitas, ideal para practicar de forma autodidacta. 2. Recursos Académicos y de Desarrollo | Risk | Probability | Mitigation | |
Existen cursos completos y actualizados (2023-2024) que cubren desde la instalación hasta la gestión avanzada: Curso gratuito de Oracle SQL - Udemy puedes instalar versiones gratuitas del software:
Para aplicar lo aprendido, puedes instalar versiones gratuitas del software: