Stepwise-Lab

Exam 1Z0-071: a 30-day study plan

Four weeks of 30 to 45 minutes a day: the exam's topics over the first three weeks, the fourth for mock exams and your weak spots.

Each day: read one topic's section, answer its questions, run one exercise on the database; the flashcards of earlier topics come back on their own.

Week 1

  1. Basic SELECT
  2. Restricting and sorting
  3. Single-row functions
  4. Conversion and conditional
  5. Aggregation

Week 2

  1. Joins
  2. Subqueries
  3. Set operators
  4. DML and transactions
  5. Tables and constraints

Week 3

  1. Views, sequences, indexes
  2. Data dictionary
  3. User access control
  4. Time zones and intervals

Week 4: mock exams and weak spots

A full mock exam on days 22, 25 and 28, on questions you have not seen; between them, your open mistakes and the weakest objectives.

Book the exam when three full mock exams, at least three days apart, reach 80% on questions new to you, and when you are sure you are right at least nine times in ten.

With the app

Set your exam date and Today spreads this plan over the days you have, with one session a day.