Further training

SQL and relational databases

Simple and complex query techniques with the most important database language - the online training with certificate of completion

This continuing education is held in German.
Enter the world of data with this comprehensive online training course on the most important database technology. Knowledge of SQL is an important prerequisite for preparing and performing professional data analysis. This course takes you from the basics of relational databases and SQL query creation to advanced techniques such as database design and optimization. This online training has been designed to allow you to learn flexibly. In the Data Lab, you can work through the content at your own pace. You can expect videos, interactive graphics, text as well as instructions and datasets for practical exercises that you can carry out yourself using databases provided online. Your learning coaches are available to answer any questions you may have.

Contents

1. introduction to relational databases

  • Introduction to the topic of databases
  • Structure of relational databases
  • Writing SQL queries and reading relational databases
  • Extract company-relevant information
  • Filter data with Boolean logic

2. deepening in SQL

  • Grouping and sorting data
  • Connecting queries with different joins
  • Use subqueries and extended filter options

3. specialization in database design

  • Structures of relational databases
  • Database design and normalization rules
  • Create or change tables and data
  • Practical project: Designing and implementing a database

4. advanced use

  • You have two options for the fourth chapter. Select the topic that best suits your area of work.
  • SQL with a focus on analytics: You analyze a database independently - from the first exploration to the last query. 
  • SQL with a focus on the backend: You will work with a completely new database and apply all the content you have learned independently. You will also learn where SQL is used in everyday work.

Learning environment

This online course offers you a particularly practice-oriented learning concept with comprehensive self-study units and a team of mentors who are available to you at all times. A new chapter will be activated for you every week. With a time budget of around 8 hours per week, you are sure to reach your goal in 4 weeks. This is how you learn in the course:

Data Lab: In the learning environment of the course, you can expect videos, interactive graphics, text and, above all, many practical exercises with comprehensive datasets. You can run these directly in the browser or import them into Power BI.

Mentor team: Your learning coaches are available to answer any questions you may have. They are experienced data analysts who will be happy to help you - via chat, audio or video call.

Webinars: Once a week, you have the opportunity to take part in webinars and immerse yourself in selected special topics of data analysis.

Career coaching: What professional goals are you pursuing with your further training and how can you achieve them? A team of mentors is available to help you achieve your career goals.

Certificate: After the final project, you will receive your official certificate of participation in this training course.

This online training is provided by our partner StackFuel GmbH. StackFuel specializes in training courses on data literacy, data science and AI.

Your benefit

In this practice-oriented training course, you will learn how to set up and configure databases and structure data independently.

You will learn how to create data overviews quickly and practically with SQL in order to write and execute basic and advanced SQL queries.

You will learn all about key functions for organizing, filtering and categorizing information in a relational database.

You will learn to understand and implement good database design - including normalization rules and the most common schemas.

You will gain advanced specialist knowledge of views, CTEs, subqueries and window functions.

You will learn how databases interact with web applications and what role SQL plays in web development.

You not only learn theory, but also apply the methods and techniques in many practical exercises and consolidate your knowledge quickly and sustainably.

The technical barriers to entry are minimized through the use of Jupyter notebooks, with which you can carry out the exercises directly in the browser.

 

Recommended for

This course is aimed at anyone who wants to learn SQL quickly and practically, apply their specialist knowledge and thus improve their IT skills. The course also provides important basic knowledge for a career in the IT or tech industry or for a career as a data scientist or business intelligence consultant.

This course is suitable for career changers and offers the ideal introduction to database technologies. No prior knowledge or programming skills are required.

Further recommendations for "SQL and relational databases"

Digital learning for individuals
Booking number
34205
€ 2.250,- plus VAT
27 days (32h ...
Online
7 Events
German
Start dates

Future Jobs Classes

Qualification for the jobs of the future such as data analyst.

In cooperation with

Start dates and details

  Select time period
0 events
02.06.2025
Booking number: 34205
€ 2.250,- plus VAT.
€ 2,677.50 incl. VAT.
Details
27 days (32h learning time)
30.06.2025
Booking number: 34205
€ 2.250,- plus VAT.
€ 2,677.50 incl. VAT.
Details
27 days (32h learning time)
28.07.2025
Booking number: 34205
€ 2.250,- plus VAT.
€ 2,677.50 incl. VAT.
Details
27 days (32h learning time)
25.08.2025
Booking number: 34205
€ 2.250,- plus VAT.
€ 2,677.50 incl. VAT.
Details
27 days (32h learning time)
22.09.2025
Booking number: 34205
€ 2.250,- plus VAT.
€ 2,677.50 incl. VAT.
Details
27 days (32h learning time)
20.10.2025
Booking number: 34205
€ 2.250,- plus VAT.
€ 2,677.50 incl. VAT.
Details
27 days (32h learning time)
17.11.2025
Booking number: 34205
€ 2.250,- plus VAT.
€ 2,677.50 incl. VAT.
Details
27 days (32h learning time)
Sufficient places are still free.
Don't wait too long to book.
Fully booked.
Training is guaranteed to take place
Booking number: 34205
€ 2.250,- plus VAT.
€ 2,677.50 incl. VAT.
Details
27 days (32h learning time)
Booking number: 34205
€ 2.250,- plus VAT.
€ 2,677.50 incl. VAT.
Details
27 days (32h learning time)
Please note: We use third-party tools for selected events. Personal data of the participant will be passed on to them for the implementation of the training offer. You can find more information in our privacy policy.

About us – The Haufe Akademie

Your optimizer, innovator and companion since 1978 -
Your professional partner for professional development and seminars, training courses and topical conferences.

Whether on site, live online or in-house - our customised solutions, our claim to the highest level of consulting expertise and training tailored to your needs simplify the acquisition of skills for the working world of the future and sustainably facilitate professional development.

A wide range of seminars, individual coaching and our flexible formats support HR managers and decision-makers in shaping the future and developing employees, in-house teams and companies.

Experience the benefits of online training from the comfort of your own home. Our online formats meet the highest quality standards and are in no way inferior to face-to-face events in terms of practical relevance. Learn together live online in interactive groups or digitally at a time of your choice.

2,500+ further training
600,000+ apprentices per year
Over 95% positive reviews
2,500 trainers and coaches
17,500+ training courses held per year
Call us or send an email

Do you have any questions?

We are there for you Mon - Fri 8 a.m. - 5:00 p.m.

Stephanie Göpfert

Head of Customer Service

*Mandatory fields
FAQs

Questions & Answers

In our Questions & Answers (FAQ) section, you will find all the answers and the most frequently asked questions about your selected topic.