Learn Oracle SQL — From SELECT to Advanced Analytics

Oracle SQL is the de-facto standard for enterprise databases. This free interactive tutorial covers everything from your first SELECT statement to recursive CTEs, window functions, analytic queries, and the patterns you'll meet on the Oracle 1Z0-071 certification exam.

Topics are organised by difficulty, with worked examples on the Oracle HR schema, practice exercises, and quick quizzes. Use the sidebar to jump in anywhere, or follow the chapters in order to build end-to-end. Everything runs in the in-browser SQL Editor — no setup required.

What you'll learn in this Oracle SQL tutorial

• SELECT, filtering, ordering, and aggregates
• INNER, OUTER, and self joins
• Subqueries, CTEs, and recursive CTEs
• Window functions for rankings, running totals, and lag/lead
• DML, transactions, and constraint design
• Index types, EXPLAIN PLAN, and basic tuning