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.