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.

Modules

1
Relational databases
toggle

In the first chapter you get into the topic Databases one. You learn what databases are and where they are used for what reason. You understand how relational databases are built and know their Advantages and disadvantages. You dive deeper into ER diagrams (Entity Relationship Model) and learn to read them. You build your knowledge around the most important SQL terms and locate SQL as the language to communicate with relational databases. You get an overview of how these Interaction works and what SQL can do.

2
Basic SQL
toggle

In the second chapter you will learn independently SQL queries and to read relational databases in order to extract company-relevant information. Thereby you distinguish Data formats from each other, learn the Boolean logic and filter tables with Boolean operators. In the first Practice project apply previous learning and build a toolkit to filter, group, sort, and connect data (Join).

3
Advanced SQL
toggle

In the third chapter you will concentrate on advanced SQL concepts and techniques and how to use them to overcome limitations of basic SQL queries. This includes four concepts for reusing query results: Subqueries, Views, Common Table Expressions (CTEs) as well as the Table creation. In several use cases you will learn advanced filtering and joining methods using nested SQL queries. You'll also learn how to speed up your queries (Indexes) and apply in the second Practice project all the learning content taught so far.

4
SQL in practice
toggle

OPTION 1: FOCUS ON ANALYTICS
In the last chapter the Final project in focus. You will analyze a completely new database independently - from the first exploration to the last query. For this purpose, we teach you two other important concepts that often come up in everyday work with SQL: You learn how to work with Common Table Expressions (CTEs) maintain an overview even with complex queries. You will also build up in-depth knowledge of analytical functions in order to Rankings create or running sums over longer periods of time. In addition, you will get an overview of how you can use SQL in practice after the training and which tools are available to you for this purpose.

OPTION 2: FOCUS ON BACKEND
You will work with a completely new database and independently apply all the content you have learned. In addition, the chapter teaches you where SQL appears in everyday work: You will learn how to use databases with Web applications interact and what role SQL plays in the Web development plays. You also build in-depth knowledge about the Performance optimization of SQL queries. In addition, you will get an overview of how you can use SQL in practice after the training and which tools are available to you for this purpose.

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