100 % eligible with education voucher
100% Promotion possible.

SQL & Relational Databases

Guide to effective SQL queries for relational databases

Certificate of completion
Advanced
Full time/part time
German, English
1.990,00
Course description

With the SQL & Relational Databases training you build up practical expert knowledge for SQL and relational databases. We'll break down common SQL practices and teach you how to get the most out of relational databases with the latest best practices.

In this training you will learn
Database Basics
Database design
SQL integration
  • Use SQL to quickly create hands-on data summaries to write and execute basic and advanced SQL queries
  • Select the correct SQL query technique according to the situation and generate optimized queries
  • Key functions to organize, filter and categorize information in a relational database
  • Selected practical projects and programming exercises in the Jupyter Notebook
  • Advanced knowledge of views, CTEs, subqueries and window functions

Target group

The advanced training is designed for anyone who wants to learn SQL quickly and practically, apply the expertise and thus improve their IT skills. The course is also suitable for people who want to pursue a career in the IT or tech industry or become Data Scientist or Business Intelligence Consultants.

Requirements for participation

No prior or programming knowledge is required for the training.

Learn more about our training
Introduction to BI and Data Analytics

Modules

1
Introduction to relational databases
toggle

The first chapter introduces you to the topic of databases. You will learn what databases are, where they are used, and why. You will understand how relational databases are constructed and familiarize yourself with their advantages and disadvantages. You will delve deeper into ER diagrams (Entity Relationship Model) and learn how to read them. You will build your knowledge around the most important SQL terms and locate SQL as the language to communicate with relational databases. You will get an overview of how this interaction works and what SQL can do.

2
Deepening SQL
toggle

In the second chapter, you will learn how to write SQL queries and read relational databases to extract company-relevant information. You will distinguish between data formats and learn about Boolean logic and filter tables with Boolean operators. In the first practical project, you will apply the previous learning content and build a toolkit to filter, group, sort, and join data.

3
Database design specialization
toggle

In the third chapter, you will focus on advanced SQL concepts and techniques and how to use them to overcome limitations of basic SQL queries. This includes 4 concepts for reusing query results: subqueries, views, Common Table Expressions (CTEs), and table creation. In multiple use cases, you will learn advanced filtering and joining methods using nested SQL queries. Additionally, you will learn how to accelerate your queries (indexes) and apply all the learning content taught so far in the second practical project.

4
SQL in practice
toggle

The final chapter focuses on the practical project. You will analyze a completely new database independently - from the first exploration to the last query. For this, we teach you two more important concepts that often come up in everyday work with SQL: you will learn how to optimally use arithmetic with SQL and how to calculate with SELECT. You also build up in-depth knowledge of analytical functions to create ranking lists or calculate running totals over longer periods of time. To do so, you determine statistical parameters such as correlations, standard deviations, and medians, create window functions, and learn to control various SQL dialects.
FAQ
quotation_marks
testemonial_picture_
The StackFuel Data Lab offers me real added value. Here you can feel the practical relevance particularly well. The tasks were always clearly described and presented. So I always knew what I had to do. The training itself was a great experience!
Alexander Gross
Data Analyst at AIC Portaltechnik
quotation_marks_flipped
quotation_marks
testemonial_picture_
The greatest added value for me is the practical relevance. Thanks to StackFuel, I can quickly implement what I've learned and adapt it for myself. That is the real learning success behind the online trainings.
Lutz Schneider
Strategic IT Buyer at Axel Springer SE
quotation_marks_flipped
quotation_marks
testemonial_picture_
The content of StackFuel's online training was very practical. There were many good examples and projects. I found that very interesting and instructive. Since the training, my everyday professional life has changed significantly: I am now a data analytics specialist in my department.
Jaroslaw Wojciech Sulak
Specialist for data analysis at IAV GmbH
quotation_marks_flipped
quotation_marks
testemonial_picture_
The user-friendly and flexible Python programming training has completely changed my view of complex data structures. Thanks to the sustainable and well thought-out learning concept as well as the seamless application of the learning content in the development environment, I can now implement the newly learned knowledge in my everyday job in test automation in greater depth and process data more easily and efficiently since then.
Jenny Lindenau
Technical Manager Test Management at Bank Deutsches Kraftfahrzeuggewerbe GmbH
quotation_marks_flipped

Let's start with a consultation.

Our consultants will be happy to help you and answer all your questions. Free of charge and without obligation. We look forward to meeting you.
1.990,00*
(incl. VAT)
0 € with education voucher