- What You Are Actually Preparing For
- What Oracle Confirms and What It Doesn't
- The Six Curriculum Areas, Topic by Topic
- Sequencing the Six Areas Across Your Prep
- Hands-On SQL Practice That Transfers to the Exam
- Drilling the Data Modeling Concepts
- Registration and Cost Mechanics
- Who Benefits Most From This Credential
- Mistakes That Cost First-Attempt Candidates
- Frequently Asked Questions
- The exam is Oracle's 1Z0-006, Oracle Database Foundations, a different exam from 1Z0-071 (SQL).
- Oracle Academy's preparation course maps to 1Z0-006 and is organized into six lesson groups, from Introduction to Introduction to SQL.
- Oracle Academy does not assume professional hands-on experience, and its 90-hour course is preparation, not a prerequisite.
- The US$95 Foundations Exam Subscription includes one 1Z0-006 attempt within a six-month subscription term.
What You Are Actually Preparing For
Oracle Database Foundations is an entry-level credential issued by Oracle Corporation under exam code 1Z0-006. It sits in Oracle's Foundations tier of certifications, aimed at people who are new to databases rather than at working administrators or developers. If you are still orienting yourself, our explainers on what Database Foundations certification is and what Database Foundations stands for cover the basics. This guide assumes you have decided to sit the exam and want a plan.
The first thing to get right is the exam identity. Several credentials in the industry carry similar names, and Oracle itself has other database exams, including the SQL-focused 1Z0-071. Oracle Academy explicitly maps its Database Foundations preparation course to 1Z0-006, so that course description is the most reliable anchor for what to study. Material written for a different vendor's "database foundations" exam, or for a different Oracle exam, will send you down the wrong path.
What Oracle Confirms and What It Doesn't
Honest preparation starts with knowing where the public information ends. Here is the current picture:
| Item | Status |
|---|---|
| Exam code and name | 1Z0-006, Oracle Database Foundations (listed in the Oracle certification catalog) |
| Preparation curriculum | Oracle Academy Database Foundations course, six lesson groups, mapped to 1Z0-006 |
| Course length | 90 hours; preparation only, not an exam prerequisite or timer |
| Experience assumed | No professional hands-on experience assumed |
| Exam fee route | US$95 Foundations Exam Subscription: one attempt, six-month subscription term |
| Question count, time limit, item format, cut score | Not verifiable from accessible official pages; confirm directly with Oracle |
| English-language appointment availability | Not confirmed by catalog or store presence alone |
That last point deserves emphasis. The catalog links a MyLearn route labelled CHS, and the exam-detail page behind it could not be retrieved. Third-party sites quote confident figures for question counts, durations and passing scores, but they conflict with each other, so this guide does not repeat them. Before you commit, open Oracle's current exam page and read the numbers there. For more on the scoring question, see our breakdown of the Database Foundations passing score.
The Six Curriculum Areas, Topic by Topic
The six headings below are the lesson-group headings from the Oracle Academy Database Foundations course description (copyright 2020), which remains linked from Oracle's current Database Curriculum page. They are preparation-curriculum headings, not six officially weighted exam domains, so do not assume each carries equal weight on the exam. For a deeper walk through each, see our complete guide to the six content areas.
Domain 1: Introduction
This is the orientation layer: why organizations store data in databases, what a database management system does, and how relational databases differ from file-based storage.
- Define data, information, database and DBMS, and know how they relate
- Understand the relational model: tables, rows, columns, keys
- Recognize common business scenarios that call for a database
Domain 2: Databases and Data Modeling
Here you learn to turn a business description into a conceptual model. This is where entity relationship thinking begins.
- Identify entities, attributes and unique identifiers from a scenario
- Describe relationships, including cardinality and optionality
- Read and interpret entity relationship diagrams
Domain 3: Refining the Data Model
A first-draft model is rarely correct. This area covers improving it so that data is stored without redundancy or anomalies.
- Resolve many-to-many relationships with intersection entities
- Apply normalization concepts and recognize the problems they prevent
- Handle supertypes, subtypes, hierarchies and recursive relationships
Domain 4: Oracle SQL Developer Data Modeler
This is the tool-specific area. Oracle SQL Developer Data Modeler is Oracle's modeling tool, and the curriculum expects you to know what it is used for and how models move through it.
- Understand the tool's role in building logical and relational models
- Know how logical designs are generated into relational designs
- Be comfortable with the vocabulary of its design workflow
Domain 5: Mapping to the Physical Model
This area connects the logical design to something a database can actually implement.
- Translate entities, attributes and relationships into tables, columns and keys
- Understand primary keys, foreign keys and constraints as the enforcement mechanism
- Recognize how design choices affect the resulting tables
Domain 6: Introduction to SQL
The final lesson group introduces the language used to retrieve and manipulate relational data.
- Write basic SELECT statements with filtering and sorting
- Understand the main categories of SQL statements at an introductory level
- Read simple queries and predict their results
Notice the shape of this curriculum: four of the six headings are about design and modeling, and only the last is about the SQL language. Candidates who arrive having done a lot of SQL but little modeling are often surprised by this balance. Our guide to how hard the Database Foundations exam is discusses where different backgrounds tend to struggle.
Sequencing the Six Areas Across Your Prep
The curriculum is cumulative: you cannot map a model you cannot draw, and you cannot refine one you have not built. Study in lesson-group order, but allocate time unevenly. The modeling areas are conceptual and benefit from repetition on fresh scenarios, while SQL benefits from typing queries daily. A six-week arrangement that respects this looks like the following. Adjust the length to your own schedule.
Introduction, then start Data Modeling
- Cover relational vocabulary until you can explain each term without notes
- Begin identifying entities and attributes from short business descriptions
Databases and Data Modeling
- Practice relationships with cardinality and optionality on new scenarios daily
- Read entity relationship diagrams aloud as plain sentences
Refining the Data Model
- Work through intersection entities and normalization examples
- Take a messy single-table dataset and restructure it step by step
Oracle SQL Developer Data Modeler and Physical Mapping
- Learn the tool's workflow and terminology, ideally by building a small model in it
- Map your Week 2 and 3 models to tables, keys and constraints
Introduction to SQL
- Run SELECT queries daily against a sample schema
- Predict output on paper before executing each query
Integration and practice exams
- Take timed mixed-topic practice sets and log every miss by lesson group
- Revisit your weakest group before the exam date
The reason modeling gets the front half is that its errors compound: a shaky grasp of cardinality in Week 2 undermines normalization in Week 3 and mapping in Week 4. Scheduling SQL last also lets you query a schema you designed yourself, which makes the syntax feel purposeful rather than abstract.
Hands-On SQL Practice That Transfers to the Exam
Oracle Academy does not assume prior professional experience, but it is built around doing things, and you should treat hands-on practice as part of the preparation rather than an optional extra. You do not need an expensive setup. A free Oracle database environment or a hosted SQL practice sandbox is enough for the introductory level this exam targets.
What to practice
- SELECT fundamentals: choosing columns, filtering rows, sorting results and combining conditions
- Reading before running: look at a query and state in words what it returns, then execute it to check yourself
- Table awareness: inspect a table's columns and keys, then write queries that respect them
- Error reading: deliberately mistype a keyword or column name and learn what the error looks like
Because Introduction to SQL is the last lesson group in the curriculum, expect the SQL content to be introductory rather than advanced. Do not spend your hours on analytic functions or complex joins that belong to a higher-level SQL exam. If you want to go further into SQL itself, that is the territory of Oracle's separate SQL certification, not 1Z0-006.
Drilling the Data Modeling Concepts
For many candidates the modeling half is the real challenge, because it rewards judgment rather than memorization. The most effective drill is to take a one-paragraph business description, such as a library, a clinic or an online shop, and produce a model from scratch. Then critique your own work.
Common modeling traps
- Leaving a many-to-many relationship unresolved instead of introducing an intersection entity
- Storing a repeating group in a single attribute instead of separating it into its own entity
- Confusing an attribute's optionality (may be empty) with a relationship's optionality (may have no match)
- Choosing an identifier that is not actually unique across all instances
When you reach the Oracle SQL Developer Data Modeler area, do not skip the physical mapping step. Questions in this part of the curriculum tend to test whether you understand what the tool is doing on your behalf: turning entities into tables, attributes into columns, and identifiers into primary keys. Our Database Foundations cheat sheet condenses these mappings into a one-page review you can use in the final days.
Registration and Cost Mechanics
Oracle's US store lists 1Z0-006 explicitly within its Foundations Exam Subscription, priced at US$95. The subscription provides one exam attempt and carries a six-month subscription term. Two clarifications matter. First, the six-month term is how long your subscription remains usable; it is not the validity period of the certification once earned. Second, Oracle is identified as the delivery provider for the subscription.
Practically, that means you should buy the subscription when you are close to ready, not on day one of studying. With one attempt included, a retake would be a separate purchase decision, so rehearse under realistic conditions first. Prices and terms can change, so verify them on Oracle's store at purchase time. For the broader picture, including what else you might budget for, see our Database Foundations certification cost breakdown.
Remember the unresolved detail from earlier: catalog and store presence does not by itself confirm that an English-language appointment is available in your region. Check this before you plan around a particular test date. Our guide to Database Foundations exam dates and scheduling covers how to approach that planning, and the requirements and eligibility guide confirms what, if anything, you need to qualify.
Key Takeaway
Do not treat the 90-hour Oracle Academy course as a gate. It is preparation, not a prerequisite and not an exam timer. Self-studiers can use its six lesson-group headings as a syllabus even without enrolling in a class.
Who Benefits Most From This Credential
Oracle Database Foundations suits people at the start of a data path: students, career changers, business analysts moving toward data work, and junior support staff who touch databases without owning them. It signals vocabulary and design literacy rather than administrative skill. Employers hiring for junior data, reporting, QA or support roles may value it as evidence that a candidate speaks the same language as the database team, though it is an entry credential and not a substitute for experience.
Be realistic about outcomes. We do not quote earnings figures here because no verified salary data attaches specifically to this exam. If return on investment is your main question, read our ROI analysis of the certification and our overview of Database Foundations jobs, which treat the credential as one input among several rather than a guarantee.
Mistakes That Cost First-Attempt Candidates
- Studying the wrong exam. Using 1Z0-071 SQL material, or another vendor's foundations content, leaves the four modeling areas uncovered.
- Over-investing in SQL depth. Only one of the six lesson groups is SQL, and it is introductory.
- Skipping the tool. Candidates who never open Oracle SQL Developer Data Modeler find its terminology unfamiliar on exam day.
- Trusting third-party exam statistics. Conflicting figures for question count and cut score circulate online; rely on Oracle's own exam page. Our article on the pass rate question explains why such numbers deserve skepticism.
- Taking practice tests too late. Start timed practice by Week 5 so you can still repair weak areas.
When you are ready to test yourself against realistic scenarios, our Database Foundations practice tests let you drill the modeling and SQL areas together, and the same practice test site is a good place to track which lesson groups keep costing you points. For a broader strategic view, return to this guide's companion pieces, starting with the full study guide.
Frequently Asked Questions
The exam is 1Z0-006, Oracle Database Foundations. It should not be confused with 1Z0-071, which is a separate Oracle SQL exam, or with any Oracle AI Database Foundations credential.
No. Oracle Academy states that professional hands-on experience is not assumed, and its 90-hour course is preparation rather than a mandatory prerequisite. You can use its six lesson-group headings as a self-study syllabus.
The US Oracle Store lists 1Z0-006 in its US$95 Foundations Exam Subscription, which includes one exam attempt and a six-month subscription term. That term is not the certification's validity period. Verify current pricing at checkout.
Those details could not be verified from accessible official pages, and third-party figures conflict, so we do not state them. Check Oracle's current exam details page for the question count, time limit, format and cut score before you test.
No. They are the lesson-group headings from the Oracle Academy preparation course, which maps to the exam. They are unweighted curriculum headings, not an official exam blueprint, so study all six rather than gambling on a favorite.