Building Database Backup and Restore Strategies

Practical training in database backup and restore, grounded in real cases and applied to your own operation.

📍 Cairo🗓️ 5 training days📚 4 modules🎓 Accredited certificate
5intensive training days
4scientific modules
8training sessions
32detailed points

Course Overview

The documentation for database backup and restore is accurate only until the next release. Systems supporting backup and restore fail in ways that are obvious afterwards and invisible before. The programme takes participants through this part of technology and systems delivery end to end, from framing the problem to closing it out. Comparative studies of database backup and restore across sectors find the same handful of failure points recurring. It is written for people who have to make the wider technology and systems delivery agenda work with the resources they already have. Sessions alternate between guided analysis of backup and restore and supervised application. The programme builds the judgement to know which parts of database backup and restore to standardise and which to leave flexible. Teams frequently over-invest in documenting backup and restore and under-invest in testing it. Participants leave with a first-ninety-days plan for this part of technology and systems delivery rather than a set of notes.

Expected Learning Outcomes

01

Adapt recognised practice on database backup and restore to local constraints without hollowing it out.

02

Design backup and recovery for backup and restore and prove it by restoring.

03

Build a concise technical standard for database backup and restore that colleagues can follow without further explanation.

04

Measure delivery and reliability of backup and restore with indicators teams trust.

05

Handle the trade-offs in database backup and restore between speed, cost and assurance explicitly rather than implicitly.

06

Apply data protection and retention requirements within backup and restore.

07

Assess and manage third-party and cloud dependencies in database backup and restore.

Who Should Attend

01

Members of committees that take decisions affecting database backup and restore.

02

Infrastructure and platform engineers operating backup and restore.

03

Solution architects designing database backup and restore.

04

Project managers delivering changes to backup and restore.

05

Quality staff verifying that database backup and restore performs as designed.

06

IT governance and audit staff reviewing backup and restore.

Course Modules

01

Database backup and restore: monitoring, alerting and observability

2 sessions · 8 points

Session 1Retiring the legacy part of database backup and restore

  • Define incident severity levels for database backup and restore and the response each triggers.
  • Run a load test on backup and restore at expected peak plus a margin.
  • Establish who is informed, consulted and accountable in database backup and restore.
  • Identify the single points of failure in backup and restore.

Session 2What has to be agreed before work on backup and restore starts

  • Test the failover for database backup and restore rather than assuming it works.
  • Name a single owner for each element of backup and restore.
  • Check that database backup and restore still works when volumes rise unexpectedly.
  • Rank the weaknesses in backup and restore by consequence rather than by ease of fixing.
02

Backup and restore: requirements, targets and service levels

2 sessions · 8 points

Session 1Monitoring backup and restore from the user's point of view

  • Remove steps in database backup and restore that add effort without adding assurance.
  • Confirm every release of backup and restore can be rolled back within a defined time.
  • Review whether database backup and restore is aligned with the objectives of the technical platform.
  • Measure current load on backup and restore and project it forward twelve months.

Session 2Designing backup and restore around how it will fail

  • Confirm the support model and escalation path for database backup and restore.
  • Set delivery and reliability indicators for backup and restore the team trusts.
  • Define the trigger that would require database backup and restore to be redesigned.
  • Confirm that contractual obligations around backup and restore are understood.
03

Backup and restore: architecture and designing for failure

2 sessions · 8 points

Session 1Building the method for backup and restore step by step

  • Check that records of database backup and restore answer the questions likely to be asked.
  • Set out the decisions in backup and restore that require sign-off and by whom.
  • Compare the cost of database backup and restore with the cost of its absence.
  • Inventory third-party dependencies inside backup and restore and their update status.

Session 2Testing database backup and restore before relying on it

  • Review access rights on database backup and restore and remove what is no longer needed.
  • Assess the exit route from any cloud or vendor dependency in backup and restore.
  • State the availability and recovery objectives for database backup and restore as numbers.
  • Review logging on backup and restore for coverage and retention.
04

Backup and restore: capacity, performance and load

2 sessions · 8 points

Session 1Setting availability and recovery targets for backup and restore honestly

  • Confirm that those complying with database backup and restore understand why it exists.
  • Record the technical debt in backup and restore and schedule repayment.
  • Build the internal briefing that explains database backup and restore to those affected.
  • Arrange the handover of backup and restore so capability survives staff changes.

Session 2Sizing capacity for backup and restore on measured growth

  • Collect evidence on the present handling of database backup and restore before proposing changes.
  • Configure alerting on backup and restore that reflects what users experience.
  • Map the handovers in database backup and restore between functions and secure them.
  • Apply change control to backup and restore including emergency changes.

Choose the package that suits you

Silver Package

At least 3 people

USD1,250
  • Workshop or Program Participation
  • Airport Transfers
  • Customized Badge
  • Expert Mentorship (Private Sessions)
  • Supervision & Secretarial Services
  • Accredited Certificate of Participation
  • Complete Training Kit
  • Coffee Break
  • Closing Ceremony

Gold Package

At least 3 people

USD1,850
  • 5-night stay in a 5-star hotel
  • Workshop or Program Participation
  • Airport Transfers
  • Customized Badge
  • Expert Mentorship (Private Sessions)
  • Supervision & Secretarial Services
  • Accredited Certificate of Participation
  • Complete Training Kit
  • Coffee Break
  • Closing Ceremony

Complete your registration

We will contact you within one business day to confirm.