Professional training – Databases
Database Backup & High Availability
Hands-on Database Backup & High Availability course: you work on Defining RTO and RPO, Full, differential and log backups and Point-in-time recovery and take away knowledge you can apply right away.
- Duration
- 6 hours, one session
- Level
- Expert
- Format
- Online or on-site
- Language
- German or English
- Certificate
- Certificate of attendance
Overview
In “Database Backup & High Availability” we combine fundamentals and practice: you get to know Defining RTO and RPO, Full, differential and log backups and Point-in-time recovery, apply what you learn in exercises and receive templates and checklists for your own use.
Databases hold the data that business processes depend on. Whether relational systems such as SQL Server and PostgreSQL or NoSQL solutions such as MongoDB, Redis and Neo4j, those who design them cleanly, query them efficiently and run them reliably avoid costly outages and bottlenecks. Our courses give developers, analysts and administrators exactly the knowledge they need in daily work. Each course lasts one day, takes place online or on site, and is built around exercises in a provided database environment with realistic sample data, so you can apply what you learn immediately.
The course is delivered live – either online in a virtual classroom or on-site in our training rooms in Munich, Salzburg, Berlin, Augsburg, Hanover, Bremen, Stuttgart and Kaiserslautern. We can also run it exclusively for your team.
Focus areas of the course
Who is this course for?
- Database administrators and system engineers
- Software developers and backend teams
- Data analysts and BI staff
- IT architects and technical project leads
What you will be able to do
- You know the key topics of Database Backup & High Availability – Defining RTO and RPO, Full, differential and log backups, Point-in-time recovery, Replication: synchronous vs. asynchronous, Failover concepts and Restore tests and documentation – and can apply them in practice.
- You explain the concepts of Database Backup & High Availability and choose suitable structures.
- You write queries and changes confidently and traceably.
- You identify performance problems and derive targeted measures.
- You protect data and plan backup and recovery for Database Backup & High Availability.
Course outline
Module 1 Fundamentals and architecture of Database Backup & High Availability
- Positioning Database Backup & High Availability and typical use cases
- Data model, storage and architectural building blocks
- Installation, tools and first connection
- Differences from related database systems
Module 2 Focus areas: Database Backup & High Availability
- Defining RTO and RPO
- Full, differential and log backups
- Point-in-time recovery
- Replication: synchronous vs. asynchronous
- Failover concepts
- Restore tests and documentation
Module 3 Hands-on: creating, querying and changing data
- Defining structures and data types sensibly
- Writing queries and verifying results
- Changing data, transactions and consistency
- Recognizing and avoiding typical sources of error
Module 4 Performance, security and operations
- Reading and evaluating indexes and execution plans
- Assigning users, roles and permissions
- Backup, restore and high availability
- Monitoring and everyday maintenance tasks
Module 5 Use in projects and transfer
- Making design decisions for your own project
- Connecting applications and interfaces
- Do's and don'ts from project practice with Database Backup & High Availability
- Further topics and learning paths
Module 6 Transfer to your daily work
- Exercise based on a realistic case
- Typical mistakes and how to avoid them
- Checklist and templates to take away
- Open questions, outlook and resources for further learning
Prerequisites
General IT understanding is enough for introductory courses. For advanced and administration courses we expect SQL basics or experience with the respective system. Solid hands-on experience with the topic is expected.
Technical requirements
Laptop with a current browser; we provide the database environment with sample data and client tools.
Dates & locations
For every location we suggest a date roughly four weeks ahead. Your preferred date is always possible.
- Munich Tue, 15 December 2026 6 hrs Request
- Salzburg Mon, 14 December 2026 6 hrs Request
- Berlin Wed, 16 December 2026 6 hrs Request
- Augsburg Wed, 16 December 2026 6 hrs Request
- Hanover Fri, 11 December 2026 6 hrs Request
- Bremen Tue, 15 December 2026 6 hrs Request
- Stuttgart Tue, 15 December 2026 6 hrs Request
- Kaiserslautern Tue, 15 December 2026 6 hrs Request
- Online Mon, 14 December 2026 6 hrs Request
Frequently asked questions
Do we work with real data in Database Backup & High Availability?
We use realistic, fully synthetic sample data, so you can practice close to real life without data protection risks. For group bookings we can add case studies from your industry, without needing any access to your production data.
Which role is Database Backup & High Availability suited for?
Depending on its focus, for developers, administrators or analysts. The focus topics show whether the course leans towards queries and design or towards operations and security. If you are unsure, we advise you beforehand on the right starting level.
How much does “Database Backup & High Availability” cost?
The course costs a flat €949 plus VAT per participant – whether online or on-site. This includes 6 hours of live training with a trainer, course materials, a lab environment and a certificate of attendance.
Can I suggest my own date?
Yes. For every location we suggest a date roughly four weeks ahead. In the request form you can always describe your preferred date or period in free text – we check availability and get back to you within one working day.
Is the course online or on-site?
Both are possible: live online in a virtual classroom or on-site in Munich, Salzburg, Berlin, Augsburg, Hanover, Bremen, Stuttgart and Kaiserslautern. We can also run the course exclusively for your team.
Can the course be tailored to our team?
Yes. Tailor-made courses cost approx. €4,500 more, depending on the topic and by arrangement. We agree content, examples and exercises with you in advance.