4 chapters + 3 exercise projects
German or English
Certificate of completion
The first chapter introduces you to the topic of databases. You
will learn what databases are and where they are used and why.
You will understand how relational databases are built and
learn about their advantages and disadvantages. You will take a
deeper look at ER diagrams (Entity Relationship) and learn how
to read them. You will learn the most important SQL vocabularly
and get to know SQL as the primary language to communicate
with relational databases. This chapter also provides an overview
of how this interaction works and what SQL can do.
In the second chapter, you will learn how to write SQL queries and read
relational databases in order to extract company-relevant information. In
doing so, you will distinguish between data formats, learn about Boolean
logic and filter tables with Boolean operators. In the first hands-on project
you will apply what you have learned so far and build a toolkit to filter,
group, sort and join data.
In the third chapter, you‘ll focus on advanced SQL concepts and
techniques and how to use them to overcome the limitations of
basic SQL queries. This includes 4 concepts to reuse query results:
subqueries, views, common table expressions (CTEs), and creating
tables. In several use cases, you‘ll learn how to use advanced filtering
and joining methods using nested SQL queries. You will also learn
how to accelerate your queries (indexes) and apply everything you
have learned so far in the second hands-on project.
The last chapter focuses on the final project. You will analyze a
completely new database on your own – from the initial exploration
to the very last query. For this, we’ll teach you two more important
concepts that regularly come up in everyday work with SQL: You
will learn how to optimally apply arithmetic with SQL and how
to calculate with using SELECT. You will also build up in-depth
knowledge of analytical functions to create ranked lists or calculate
running totals over longer periods of time. To do this, you will
determine statistical parameters such as correlations, standard
deviation and median, create window functions and learn to control
various SQL dialects.
Yes, our online training courses should offer you the greatest possible flexibility. Basically, we recommend planning six to eight hours a week for studying. When you want to schedule this time is up to you and is not prescribed by us. In our career paths, the Data Analyst and Data Scientist course, we offer you live webinars where you can ask our mentors questions, but you don’t have to attend if it doesn’t fit into your schedule.
(Participants in our funded training courses are an exception. They have to attend a fixed number of hours per week and are obliged to take part in the live webinars.)