Oracle 1Z0-071 Study Resources: Free SQL Practice That Fits
Oracle SQL is the rare certification where the best lab is free and browser-based. Here is the full resource shelf for 1Z0-071 and the order to use it in.
- $245Exam fee
- 55-75 hTotal prep
- $0Lab cost
- Docs + Live SQLFree spine
- Fee onlyCheapest path
Table of Contents
What actually exists
1Z0-071 is 63 questions in 120 minutes with a 63% pass mark, at $245. It is a syntax exam: Oracle publishes 16 topic groups with no percentage weightings, and the questions turn on precise behaviour — what a join returns when a row has no match, how implicit conversion resolves, which DDL statements commit. That makes it unusually resource-friendly, because the two things you need most are the official SQL reference and somewhere to run statements, and both are free.
- Official documentationWell servedThe Oracle Database SQL Language Reference is the document the exam is written from. Free, exhaustive, and the tiebreaker whenever two study sources disagree.
- Free practice environmentWell servedOracle Live SQL runs statements in a browser with no install, and Oracle Database Express Edition is free to install locally. No excuse exists for studying this exam without running queries.
- Official trainingWell servedOracle University sells SQL learning paths and MyLearn carries free introductory content. Complete but priced for corporate buyers.
- BooksThinThe Oracle Press exam guide for 1Z0-071 is the reference candidates keep recommending. The shelf beyond it is thin and ages quickly.
- Video coursesWell servedSQL is the most-taught subject in tech. Plenty of good marketplace courses — just confirm they teach Oracle SQL specifically, not generic ANSI or T-SQL.
- Question banksWell servedWell served, and important here: the exam's difficulty is in edge-case behaviour, which volume drilling surfaces far faster than reading does.
- CommunityWell servedOracle forums, Stack Overflow and Ask TOM answer nearly any SQL behaviour question you can think of, usually with a runnable example.
The distinctive thing about this exam is that the free tier is genuinely sufficient. Docs plus Live SQL plus question volume passes it. Paid resources buy speed and structure, not access.
The stack, in build order
Build in this order. The unusual rule for 1Z0-071 is that reading time should be the smallest layer: every hour you spend running statements is worth two spent reading about them.
- 1Topic list, mappedOracle's 16 topic groups have no published weights, so map them yourself: mark each as confident, shaky, or unseen, and let that ordering drive the plan.
- 2A working sandboxLive SQL in the browser for quick checks, or Express Edition locally with the sample schemas for longer sessions. Set this up before you study anything.
- 3Core SQL course or bookOne structured pass over SELECT, restriction and sorting, single-row and group functions, joins, subqueries, DML, DDL and views.
- 4Run every exampleType each statement rather than reading it, then break it deliberately: null in the join column, a group function without a GROUP BY, an implicit conversion. The error messages are the lesson.
- 5Question bank to volumeSeveral hundred questions with explanations. This exam's traps are behavioural edge cases, and volume is the only efficient way to meet enough of them.
- 6Edge-case reviewNulls, implicit conversion, DDL that commits, the difference between the join types, and set operators. Revisit these last because they generate the most wrong answers.
Total: roughly 55-75 hours from a standing start, 25-35 for a developer who already writes SQL daily and mainly needs Oracle-specific behaviour and exam phrasing.
Every resource, ranked
Ranked for a self-funded candidate. Note how much of the top of this list is free — that is unusual and it is the defining feature of this exam.
| Resource | Type | Cost | Hours | Verdict |
|---|---|---|---|---|
| Oracle SQL Language Reference (docs) | official | $0 | Reference | The authority. When a course and a practice test disagree, the docs settle it. |
| Oracle Live SQL | free | $0 | Ongoing | Browser sandbox with sample schemas and no install. The single most useful free resource for this exam. |
| Oracle Database Express Edition | free | $0 | 1 setup | Free local database when you want a persistent environment and full DDL freedom. |
| Oracle Press 1Z0-071 exam guide | paid | $40-$60 | 20-25 | The one book candidates consistently name. Written to the exam rather than to general SQL learners. |
| Oracle University / MyLearn SQL path | official | Free tier to $$$ | 20-30 | Official and thorough. Free introductory content is worth taking; the paid tiers are priced for employers. |
| ExamCert 1Z0-071 question bank | paid | Free tier, then $5.99 | 12-15 | Volume plus explanations against the 16 topic groups. Free sets first. |
| Ask TOM, Stack Overflow, Oracle forums | community | $0 | As needed | Best place to resolve a specific behaviour question, usually with a runnable demonstration. |
Three budgets, three plans
Three routes. This is one of the few exams where the free path is not a compromise — it is a legitimate first choice.
Docs and sandbox
Exam fee only7-9 weeks
- SQL Language Reference plus Live SQL
- Free introductory MyLearn content
- Free question sets for calibration
- Slower, but nothing important is missing
Book plus drilling
Fee + about $555-7 weeks
- Oracle Press exam guide as the spine
- Live SQL for every example
- Paid question bank for edge-case volume
- Best value for most candidates
Course-led
Fee + $200-$5004-5 weeks
- Oracle University SQL path or a strong marketplace course
- Structured, instructor-paced
- Worth it if you are new to SQL entirely or an employer is funding it
Which resource covers which exam area
Oracle publishes topic groups without percentages for this exam, so any weighted pie chart you find elsewhere was invented. The grouping below reflects where questions actually cluster.
- Retrieving, restricting, sortingCoreAny SQL course plus sandbox practice. Foundational and heavily represented.
- Single-row, conversion, group functionsCoreDocs plus deliberate practice. Conversion and null-handling behaviour is a favourite trap.
- Joins and subqueriesCoreBook chapters plus question volume. Outer join semantics and correlated subqueries carry a lot of marks.
- DML, DDL, transaction controlCoreLive SQL, hands-on. Which statements issue an implicit commit is exam-favourite material.
- Views, schema objects, data dictionarySupportingDocs and book. Sequences, synonyms, indexes and privileges — less glamorous, reliably examined.
The gap rows are behavioural rather than syntactic: they are things you learn by running a statement and being surprised, not by reading a bullet. Budget sandbox time for them specifically.
What to skip
SQL's popularity means most of the noise around this exam comes from material that teaches the wrong dialect.
Do not spend money on these
- Generic SQL courses. T-SQL and PostgreSQL courses teach transferable concepts and the wrong specifics. 1Z0-071 tests Oracle behaviour, including Oracle-only functions and conversion rules.
- Material written for retired exam codes. The old 12c SQL Fundamentals listing is where the widely-quoted 78-question figure comes from; the current exam is 63 questions.
- Dumps. Oracle takes certification integrity seriously, and this exam is genuinely passable in 55-75 honest hours.
- PL/SQL depth. This is the SQL exam. Procedural programming belongs to a different certification and studying it now is time you are not spending on joins.
- Paid lab environments. Live SQL and Express Edition are free and sufficient. Nobody needs to rent an Oracle instance to pass this.
The layer nobody budgets for is question volume
SQL edge cases are learned by getting them wrong somewhere cheap. Drill a few hundred 1Z0-071 questions with explanations attached, and the traps stop being traps. Free question sets first, then $5.99 unlocks the full bank.
Free practice testOracle 1Z0-071 exam pageFAQ
Can I pass 1Z0-071 with free resources only?
Yes, more comfortably than on most certifications. The Oracle SQL Language Reference is free, Live SQL gives you a browser-based database with sample schemas, and Express Edition is free to install. Paid resources buy structure and question volume, not access to anything essential.
What is the best book for 1Z0-071?
The Oracle Press exam guide written for 1Z0-071 is the title candidates most consistently recommend, because it is organised around the exam topics rather than around teaching SQL generally. Confirm the edition targets 1Z0-071 and not the retired 12c SQL Fundamentals exam.
How many hours does 1Z0-071 take?
Fifty-five to seventy-five hours from a standing start. A developer who writes SQL daily can be ready in twenty-five to thirty-five, since the work is learning Oracle-specific behaviour and exam phrasing rather than learning SQL.
Do I need to install Oracle Database to study?
No. Oracle Live SQL runs statements in the browser against sample schemas with nothing to install, which covers most study needs. Install Express Edition only if you want a persistent environment for longer DDL and transaction practice.
Sources
Fees, objectives and course catalogues on this page come from Oracle and the publishers themselves:
Checked September 9, 2026. Training catalogues, book editions and exam fees change without notice — confirm with Oracle before you spend anything.