SQL & Relational Databases.

Chapter 1: Introduction to Relational Databases

In the first chapter, you'll get started with the topic of databases. You'll learn what databases are, where they're used, and why. You’ll understand how relational databases are structured and learn about their advantages and disadvantages.

You’ll learn to write SQL queries to read relational databases and extract business-relevant information. In the first hands-on project, you’ll apply what you’ve learned so far and filter the data using Boolean logic.

Chapter 2: Advanced SQL

In the second chapter, you’ll refine both your theoretical and practical knowledge. You’ll learn to use your queries to group, sort, and combine data using various joins. You’ll also learn about subqueries, which open up new filtering possibilities. In the second hands-on project, you’ll have the chance to reinforce everything you’ve learned.

Chapter 3: Advanced Database Design

In the third chapter, you’ll focus on the structure of relational databases. To better understand their structure, you’ll dive into database design yourself and learn about the normalization rules.

So you can put your knowledge into practice, you’ll learn how to create or modify tables and data. In the third interim project, you’ll design a database yourself and implement your design in practice.

Chapter 4: SQL in Practice

In a final project, you’ll independently analyze an unknown database—from exploration to complex queries—and solidify all the SQL techniques you’ve learned. You’ll also gain an overview of how to use SQL in practice after the training and which tools are available to you for this purpose.

Option 1: Focus on Analytics
You’ll learn how to use Common Table Expressions (CTEs) to maintain an overview even with complex queries. You’ll also build in-depth knowledge of analytical functions to create rankings or calculate running totals over extended periods.

Option 2: Focus on Backend (Python Programmer Training Program)
You’ll learn how databases interact with web applications and what role SQL plays in web development. You’ll also gain in-depth knowledge about optimizing the performance of SQL queries.