| Module | Title | Key Free Tools | Time (Hours) | | :--- | :--- | :--- | :--- | | 0 | Zero-Cost Setup | Oracle Live SQL (browser), Oracle Cloud Free VM | 1 | | 1 | SQL Foundations | SELECT, WHERE, functions, aggregation | 6 | | 2 | Joins & Subqueries | INNER, LEFT, RIGHT, FULL, correlated subqueries | 5 | | 3 | DDL & DCL | CREATE, ALTER, GRANT, constraints (PK, FK, CHECK) | 4 | | 4 | Oracle Architecture | Tablespaces, schemas, sessions, transactions | 3 | | 5 | PL/SQL Programming | Cursors, loops, procedures, functions, packages | 8 | | 6 | Performance & Tuning | Indexes (B-tree, bitmap), execution plans, hints | 4 |
Total Self-Paced Duration: ~31 hours (recommended 4 hours/week → 8 weeks).
Oracle ofrece una plataforma llamada Live SQL. No necesitas instalar nada en tu ordenador. Solo necesitas un navegador y crear una cuenta gratuita (Oracle Account).
Para complementar tu aprendizaje, te recomiendo buscar estos recursos gratuitos: curso base de datos oracle gratis
A structured approach for a complete beginner:
| 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 |
Oracle University no solo vende cursos caros (como el famoso "Oracle University DBA"). También tiene una sección de "Free Events" o "Free Courses". | Module | Title | Key Free Tools
Given the query includes "curso base de datos oracle gratis" (Spanish), the following Spanish-friendly options are recommended:
| Platform | Course Name (Spanish) | Language | Format | |----------|----------------------|----------|--------| | YouTube | "Curso Oracle SQL desde cero" — Píldoras Informáticas | Spanish | Video series (20+ hours) | | YouTube | "Oracle Database para principiantes" — Codigo369 | Spanish | Video tutorials | | edX | "Databases: Relational Databases and SQL" (Stanford) | English, Spanish subtitles | Self-paced | | Coursera | "SQL for Data Science" (UC Davis) | English / subtitles | Free audit mode | | W3Schools | "Oracle SQL Tutorial" | English + auto-translate | Text + interactive |
This paper proposes the creation of "Oracle Database Fundamentals," a 100% free, self-paced course designed to lower the barrier to entry for enterprise database skills. Unlike vendor-locked paid courses, this program leverages Oracle’s free tiers (Oracle Live SQL, Oracle Cloud Free Tier, and Oracle Database 23c Free) to teach SQL, PL/SQL, and database architecture. A structured approach for a complete beginner: |
The course targets the critical gap between academic database theory (MySQL/Postgres) and real-world demand for Oracle skills in banking, healthcare, and government sectors.
Oracle ofrece acceso gratuito a varios cursos en su plataforma Oracle University:
🔗 Acceso: Crea una cuenta Oracle (gratis) y busca “Free Courses”.
