References & Tools
Everything you need to keep learning SQL and PL/SQL for free: run queries instantly in a browser, consult the authoritative references, follow guided courses, and read production-grade SQL written by the community.
A local database is still the best place to practice — every lab example runs as-is against Oracle. The tools below support that path at every level, including a free cloud database when you have no local install.
Playgrounds & Free Cloud Databases
Instant feedback without a local install: write a query, run it, read the output.
| Tool | What it is | Best for |
|---|---|---|
| Oracle Live SQL | Oracle's own free browser SQL and PL/SQL environment, no install required. | Running every demo in this roadmap exactly as written. |
| DB Fiddle | A lightweight, shareable SQL playground across several database engines. | Quick, small experiments and sharing a reproducible query. |
| Oracle Database XE | The free, full-featured Express Edition — install locally, no license cost. | A real local database once you outgrow the playground. |
Official Documentation
The authoritative sources, all free.
| Resource | What it is |
|---|---|
| Oracle Database Documentation | The root of every Oracle manual, including SQL and PL/SQL. |
| Database PL/SQL Language Reference | The formal, complete PL/SQL language specification. |
| Database SQL Language Reference | Every SQL statement and function, with full syntax diagrams. |
| SQL Quick Reference | A compact cheat sheet of statements and functions. |
Free Courses & Tutorials
Guided, hands-on ways to build fluency after the roadmap.
| Course | What it is |
|---|---|
| Oracle Tutorial | Free, example-driven lessons covering SQL and PL/SQL fundamentals. |
| SQLZoo | Interactive SQL exercises with instant feedback, from beginner to advanced. |
| Mode SQL Tutorial | A practical, analytics-focused path through SQL querying. |
| HackerRank — SQL | Ranked SQL challenges from basic queries to advanced joins. |
Open-Source Samples & Challenges
Reading real schemas and real queries is the fastest path past "runnable" toward "production".
| Source | What it is |
|---|---|
| Oracle Sample Schemas | Oracle's own reference schemas (HR, OE, SH) used throughout its official docs. |
| GitHub topic: plsql | Real-world PL/SQL packages, utilities, and frameworks to read. |
| Codewars | Ranked SQL kata with solutions to compare after solving. |
How to Choose & Next Steps
A short ladder that keeps you unblocked:
- Finish every lab example in Oracle Live SQL, then break and fix each one.
- Work through SQLZoo for query drills while keeping the SQL Language Reference open.
- Install Oracle Database XE once you want a real, persistent local database.
- Read the Oracle Sample Schemas to see how a real, normalized schema is designed.
- Graduate to building something real — a reporting package, a data-loading pipeline, or an application's backend package layer.
You have reached the end of the PL/SQL roadmap. The database that once felt like a black box behind the application is now a programming environment you can read, query, and extend directly.