Module

SQL & Relational Databases.

Guide to effective SQL queries for relational databases

Module description

Part time

German, English

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 module 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

Table of contents

1
Introduction to relational databases

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

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

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

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.

You want this module detached from the entire training program and without an education voucher complete? We offer flexible payment and financing options for self-paying participants. Please contact directly to our consulting team for more information.

Do you still have Questions?

Find your training program with us and start your data career! Book a non-binding consultation now.

+6,000 Graduates

91 % Completion rate

AZAV-certified

FAQ

What sets StackFuel apart from other training providers?

Our training courses are developed and produced by our own team of data scientists and subject matter experts, who provide you as a participant with personal mentoring during the course. We not only focus on realistic and practical content, but also ensure that all your questions are answered in a personal exchange and thus guarantee your learning success.

Thanks to our "learning-by-doing" principle, you will learn in our interactive learning environment with realistic data sets and real business cases from the industry, preparing you perfectly for a successful career start in a data job.

Why is StackFuel the right choice for me?

With StackFuel, you can rely on a market leader with Germany's most innovative learning platform to develop your data skills in a practical way. In certified training programs, you learn online, flexibly and with 80 % of practical content.

This will enable you to make a lateral entry as a data analyst or data scientist and learn how to use data and the basics of artificial intelligence professionally. Your new data career starts with your online training at StackFuel.

How can data skills help me to start a new career?

Data has become an integral part of our (professional) lives. In almost all areas, data helps you to better understand facts and make more precise decisions. Data skills are the key to being able to use and interpret data correctly. Even though you may not realize it, you work with, interact with and generate data every day.

This data is becoming increasingly important for companies and is the basis for decisions and business models, which makes data professionals incredibly important for companies.

SQL & Relational Databases.

1
Introduction to relational databases

2
Deepening SQL

3
Database design specialization

4
SQL in practice

Do you still have Questions?

FAQ

Profit promotion program

Sponsored by

Member with

On German servers from:

SQL & Relational Databases.

1Introduction to relational databases

2Deepening SQL

3Database design specialization

4SQL in practice

Do you still have Questions?

FAQ

Profit promotion program

Sponsored by

Member with

On German servers from:

1
Introduction to relational databases

2
Deepening SQL

3
Database design specialization

4
SQL in practice