Thorough data analysis is the foundation for reliable, consistent, and actionable business data.
In this training, you will learn how to systematically retrieve, combine, and prepare data from various sources. This process results in robust data models that serve as the foundation for reports, dashboards, and data-driven decisions.
What to ExpecT
- Introduction to relational databases and working with structured data
- SQL queries - from simple analyses to more complex queries
- Joining and combining data from multiple tables and sources
- Best practices for data structure, quality, security, and performance
- Using AI with SQL
- Blended learning
-
32h / 8 sessions
(2 sessions of 4h/week) - EUR 3,250 plus 19% VAT
LEARNING OBJECTIVES
After completing this training, you will be able to
- understand relational databases and use them for analysis;
- use SQL queries to perform targeted analysis of business data;
- logically link data from multiple tables;
- answer complex data-related questions in a clear, structured manner;
- create reusable data queries as a basis for reporting and analysis.
Target group & Prior Knowledge
This training is designed for everyone who regularly works with data and uses it to support decision-making. This includes, in particular, departments such as Controlling, Accounting, and Operations, as well as related business roles that need to analyze, combine, or prepare data from various sources for reports.
No prior technical knowledge is required to participate. A basic interest in working with data is sufficient. Experience with Excel or creating initial reports is helpful but not required.
Training Content at a Glance
Relational Databases and SQL Basics
- Structure of a relational table
- Basic SQL commands and queries
- Conditional queries and sorting
- Simple calculations with SQL
Aggregation, Subqueries and Joins
- Aggregate functions in SQL and conditional queries
- Nested queries
- Correlation in subqueries
- Joining tables
- Nested joins and subqueries
Views and Window Functions
- Using views as stored queries
- Introduction to window functions
Normalization and Security
- Introduction to normalization
- Database security (e.g., user rights and roles)
- Encryption and data protection in relational databases
Program DATES
- 8 Sep 2026 – 1 Oct 2026
- Live Sessions (duration: 4h)
- Tue, 8 Sep 2026, 8:30 – 12:30
- Thu, 10 Sep 2026, 8:30 – 12:30
- Tue, 15 Sep 2026, 8:30 – 12:30
- Thu, 17 Sep 2026, 8:30 – 12:30
- Tue, 22 Sep 2026, 8:30 – 12:30
- Thu, 24 Sep 2026, 8:30 – 12:30
- Tue, 29 Sep 2026, 8:30 – 12:30
- Thu, 1 Oct 2026, 8:30 – 12:30
- Live Sessions (duration: 4h)
Further dates are being planned.
PRICE PER PERSON
- EUR 3,250 excl. VAT