training training
This training is held in German.
Would you like to query data from an SQL database such as MS SQL Server, Oracle, DB2 and are looking for a comprehensible introduction with practice-oriented exercises? At the beginning of the seminar you will learn why a database splits data into different tables using Microsoft SQL Server. In the main part, you will query, sort and group individual tables and then several tables. Finally, you will also perform more complex calculations such as "What turnover does my company generate in which branch?".
Contents
Database design
- Why does a relational database divide the data into different tables?
- How does the entity-relationship model, for example, help me to split up the data?
- Why do I need a primary and foreign key in a relational database?
Query data with SQL statements
- Query data in 1 table via "SELECT".
- Do not query all rows of the table using the "WHERE" condition including the various selection criteria such as "LIKE" with the placeholders "%" and "_" as well as "IS NULL", etc.
- Sort the query result with "ORDER BY".
- Summarize data with "GROUP BY" or display it individually using "DISTINCT" and understand the difference between the two variants.
- "SELECT" over several tables with the help of "INNER JOIN", "LEFT - RIGHT (OUTER) JOIN", "FULL (OUTER) JOIN", "CROSS JOIN".
- Functions and calculations with the aggregate functions such as "SUM()", "COUNT()".
- Outlook on SQL subqueries/ SQL subselects...
Learning environment
Once you have registered, you will find useful information, downloads and extra services relating to this training course in your online learning environment.
Your benefit
- In this course you will learn the most important SQL statements according to SQL Standard 92 using Microsoft SQL Server as an example, so that you can transfer what you have learned to other database systems such as Oracle or DB2.
- You will acquire in-depth knowledge of data retrieval using the SELECT command. DDL and DCL commands are not part of the course.
- You will get to know and understand the join types, which are somewhat more demanding at the beginning, by means of many different examples.
- Although this SQL training course also covers the theoretical basics, the focus of the seminar is on practical relevance and understanding the subject matter.
- The aim of the SQL training course is to enable you to apply what you have learned directly in your day-to-day work after completing the course.
Methods
Presentation, practical examples and exercises on the PC, sample solutions, tips and tricks.
The training is basically database-independent, Microsoft SQL Server is used for the exercises.
Recommended for
controllers and Employees from other departments who want to get to grips with database queries and understand SQL as a query language. No prior knowledge is required.
Further recommendations for "SQL queries and SQL commands in controlling practice"
Contents
Database design
- Why does a relational database divide the data into different tables?
- How does the entity-relationship model, for example, help me to split up the data?
- Why do I need a primary and foreign key in a relational database?
Query data with SQL statements
- Query data in 1 table via "SELECT".
- Do not query all rows of the table using the "WHERE" condition including the various selection criteria such as "LIKE" with the placeholders "%" and "_" as well as "IS NULL", etc.
- Sort the query result with "ORDER BY".
- Summarize data with "GROUP BY" or display it individually using "DISTINCT" and understand the difference between the two variants.
- "SELECT" over several tables with the help of "INNER JOIN", "LEFT - RIGHT (OUTER) JOIN", "FULL (OUTER) JOIN", "CROSS JOIN".
- Functions and calculations with the aggregate functions such as "SUM()", "COUNT()".
- Outlook on SQL subqueries/ SQL subselects...
Learning environment
Once you have registered, you will find useful information, downloads and extra services relating to this training course in your online learning environment.
Your benefit
- In this course you will learn the most important SQL statements according to SQL Standard 92 using Microsoft SQL Server as an example, so that you can transfer what you have learned to other database systems such as Oracle or DB2.
- You will acquire in-depth knowledge of data retrieval using the SELECT command. DDL and DCL commands are not part of the course.
- You will get to know and understand the join types, which are somewhat more demanding at the beginning, by means of many different examples.
- Although this SQL training course also covers the theoretical basics, the focus of the seminar is on practical relevance and understanding the subject matter.
- The aim of the SQL training course is to enable you to apply what you have learned directly in your day-to-day work after completing the course.
Have you booked a live online event?
Please note the following:
The training is carried out in a virtual training environment.
To use this central remote desktop farm (Microsoft 365 training environment), the remote desktop client (part of Windows (mstsc.exe)) as well as unlimited access to the Internet via the IP protocol https (TCP 443) and DNS resolution of external DNS names are required. Your IT department can answer questions about these technical requirements. If you are unable to access the server farm, you will unfortunately not be able to take part in the live training training.
Of course, you also need a laptop/computer and a stable internet connection.
It would also be very helpful to use two screens or two devices to recreate the face-to-face seminar environment: One screen or tablet would show the video image of the:der trainer analogous to the screen in the face-to-face seminar and on the other screen/laptop you can use your computer to implement or practice what has been shown. If necessary, a single large screen would also help to split 2 programs on the right and left half of a screen.
Methods
Presentation, practical examples and exercises on the PC, sample solutions, tips and tricks.
The training is basically database-independent, Microsoft SQL Server is used for the exercises.
Technical information (live online event)
- We provide you with a virtual training environment so that you have access to the programs you need during training .
- Please note that in order to use the virtual training environment, you will receive a so-called RDP file (Remote Desktop Protocol) from us, which you must open on your computer. Please speak to your IT department in advance to find out whether this is possible.
- If the technical requirements are not possible, you can also have your own SQL Server training environment set up by the IT department and use it during the seminar.
- By default, the Remote Desktop Client is only available on Windows Professional and not on Windows Home.
The following third-party tool can be used in the event:
Recommended for
controllers and Employees from other departments who want to get to grips with database queries and understand SQL as a query language. No prior knowledge is required.
Further recommendations for "SQL queries and SQL commands in controlling practice"
Seminar evaluation for "SQL queries and SQL commands in controlling practice"
4.6 from 5
with 87 ratings
training content:
4.6
Content comprehensibility:
4.7
Practical relevance:
4.2
Trainer expertise:
4.8
Participant orientation:
4.8
Method variety:
4.6
On-site training together
Booking number
40989
40989
€ 1.490,-
plus VAT
2 days
in 2 locations
2 Events
German
Joint online training
Start dates and details
02.06.2025
Live-Online
Booking number:
33595
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Course
zoom
Days & Times
2 days
Limited number of participants
Monday, 02.06.2025
09:00 am - 5:00 pm
Tuesday, 03.06.2025
09:00 am - 5:00 pm
Transfer coaching bookable
2 hours of transfer coaching - live and online with your trainer ensures that you can put what you have learnt into practice in your day-to-day work.
If you book at the same time as your training, you save 10 % on the price of the transfer coaching of € 390,- excl.
01.09.2025
Munich
Booking number:
40989
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Days & Times
2 days
Limited number of participants
Monday, 01.09.2025
09:00 am - 5:00 pm
Tuesday, 02.09.2025
08:00 am - 4:00 pm
Fee includes
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
Transfer coaching bookable
2 hours of transfer coaching - live and online with your trainer ensures that you can put what you have learnt into practice in your day-to-day work.
If you book at the same time as your training, you save 10 % on the price of the transfer coaching of € 390,- excl.
12.11.2025
Live-Online
Booking number:
33595
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Course
zoom
Days & Times
2 days
Limited number of participants
Wednesday, 12.11.2025
09:00 am - 5:00 pm
Thursday, 13.11.2025
09:00 am - 5:00 pm
Transfer coaching bookable
2 hours of transfer coaching - live and online with your trainer ensures that you can put what you have learnt into practice in your day-to-day work.
If you book at the same time as your training, you save 10 % on the price of the transfer coaching of € 390,- excl.
16.03.2026
Frankfurt a. M.
Booking number:
40989
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Days & Times
2 days
Limited number of participants
Monday, 16.03.2026
09:00 am - 5:00 pm
Tuesday, 17.03.2026
08:00 am - 4:00 pm
Fee includes
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
Transfer coaching bookable
2 hours of transfer coaching - live and online with your trainer ensures that you can put what you have learnt into practice in your day-to-day work.
If you book at the same time as your training, you save 10 % on the price of the transfer coaching of € 390,- excl.
Training is guaranteed to take placeThe next booking ensures this course will take place
Booking number:
40989
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Details
2 days
Limited number of participants
Fee includes
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
Transfer coaching bookable
2 hours of transfer coaching - live and online with your trainer ensures that you can put what you have learnt into practice in your day-to-day work.
If you book at the same time as your training, you save 10 % on the price of the transfer coaching of € 390,- excl.
Booking number:
33595
€ 1.490,- plus VAT.
€ 1,773.10 incl. VAT.
Details
2 days
Limited number of participants
Transfer coaching bookable
2 hours of transfer coaching - live and online with your trainer ensures that you can put what you have learnt into practice in your day-to-day work.
If you book at the same time as your training, you save 10 % on the price of the transfer coaching of € 390,- excl.
No suitable date?
You are welcome to be notified by e-mail as soon as new dates are released.
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.
*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.
Haufe Akademie GmbH & Co. KG
Munzinger Str. 9
79111 Freiburg
Munzinger Str. 9
79111 Freiburg
A brand of
The company
About our offer
- Planning security
- Free seminar places
- Quality standards
- Planning and locations
- Funding opportunities
- Training app
- Business Solutions
Special offers
Contact & Support
