Effective SQL Queries for Relational Databases

SQL & Relational Databases

Course description

With the SQL & Relational Databases course, you will gain practical expert knowledge of SQL and relational databases. We will break down common SQL practices and teach you how to get the most out of relational databases with the latest best practices.

In this  course you will learn:  

Use SQL to quickly get a practical overview of the data in order to write and carry out basic and advanced SQL queries

Select the correct SQL query technique for each specific situation and generate optimized queries

Key functions for organizing, filtering, and categorizing information in a relational database

Elected practical projects and programming exercises in Jupyter Notebooks

Advanced knowledge of views, CTEs, subqueries and window functions

Target Audience  

The mid level course is designed for anyone who wants to learn SQL quickly and in a hands-on manner, apply the knowledge 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.

Prerequisites for participation 

No prior knowledge or programming skills are required for the course.

Online course

32 hours

4 chapters + 3 exercise projects

Mid level

German

Certificate of completion

Every 1-2 months

€1,990.00 incl. VAT

What to Expect

Course Overview

Feature 1

From data literacy courses for beginners with no prior knowledge to retraining in data science and AI for domain experts - we cover all career levels.

Feature 2

Learning by doing is very important to us - we focus 90% on interactive formats, real business cases and coding challenges.

Feature 3

We guarantee your learning success - with weekly webinars, support via email, telephone or forum and standardised off- and onboarding.

Feature 1

From data literacy courses for beginners with no prior knowledge to retraining in data science and AI for domain experts - we cover all career levels.

Feature 2

Learning by doing is very important to us - we focus 90% on interactive formats, real business cases and coding challenges.

Feature 3

We guarantee your learning success - with weekly webinars, support via email, telephone or forum and standardised off- and onboarding.

Modules

Chapter 1: Relational Databases

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.

Chapter 2: Basic SQL

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.

Chapter 3: Advanced SQL

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.

Chapter 4:Analytical Functions and Final 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.

Download the curriculum now.

Title

First name

Last name

Email address

Phone

Organization

Checkbox

By submitting this form, I have acknowledged the privacy policy and terms and conditions. I agree to StackFuel sending me emails with offers and news.

LEARNING ENVIRONMENT

Train online in your browser in our interactive learning platform.   

StackFuel provides an innovative learning environment to develop your data skills in the most effective way – interactively and with real-world exercises. Learn to code in our Data Lab and develop algorithms and automate things with real industry datasets. Learn more now and benefit from 80% practical content in our courses. 

WHY STACKFUEL 

We are your strategic learning partner - including mentoring & support.   

Whether you are an employee, a manager, or looking for a job – we will help you become a data expert with our certified and fundable upskilling and reskilling courses, which are suitable for every specialist department and every career level. We’ll ensure you learn successfully with our dedicated mentoring team to keep an eye on your progress. Our practical tasks and projects will prepare you for dealing with the latest technologies and applications.  

Feedback

What our graduates say. 

The Data Lab really offers added value, you notice instantly how the practical exercises are relevant to your work. The tasks were always clearly described and presented. So I always knew what to do. The course itself was a great experience!

Alexander GroßData Analyst at AIC Portaltechnik

The greatest added value for me is the content’s practical relevance. Thanks to StackFuel, I can quickly implement what I've learned and adapt it for my situation. That's the real learning success behind the online courses.

Lutz SchneiderStrategic IT Buyer at Axel Springer SE

The online StackFuel course content was very hands on. There were a great deal of good examples and projects. I found it very interesting and instructive. My professional life has changed significantly since the course - I am now a data analysis specialist in my department.

Jaroslaw Wojciech SulakSpecialist for data analysis at IAV GmbH

The flexible and user-friendly course 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 course content in the coding environment, I can now put the skills I learned into practice in my day-to-day work in test automation and process data more easily and efficiently.

Jenny LindenauTechnical Manager Test Management at Bank Deutsches Kraftfahrzeuggewerbe GmbH

Check out out other courses.

BI Analyst – Focus Power BI

Qualification for the Job Role of a Business Intelligence Analyst

Type:

Online course

Duration:

Part-time: 4 months
Full-time: 8 weeks

Analytics & Reporting – Focus Power BI

Guide to Effective Dashboards in Power BI

Type:

Online course

Duration:

32 hours

Python – Focus Object-Oriented Programming

Design Principles for Software Development with Object-Oriented Programming

Type:

Online course

Duration:

32 hours

Check out our learning platform now!

Find out why more and more leading companies are using StackFuel to train their employees online. In our a call with us, you’ll learn how your company can build data skills and make your workforce transformation a smooth success.

Title

First name

Last name

Email address

Phone

Organization

Checkbox

By submitting this form, I acknowledge the privacy policy and terms and conditions. I agree to StackFuel sending me emails with offers and news.

StackFuel GmbH Nostitzstraße 20
10961 Berlin
Germany info@stackfuel.com 030 / 544 533 499

Name	Borlabs Cookie
Provider	Eigentümer dieser Website, Imprint
Purpose	Speichert die Einstellungen der Besucher, die in der Cookie Box von Borlabs Cookie ausgewählt wurden.
Cookie Name	borlabs-cookie
Cookie Expiry	1 Jahr

Name	StackFuel Popup
Provider	stackfuel.com
Purpose	Saving the settings for the screen popup
Privacy Policy	https://stackfuel.com/legal/datenschutz/
Host(s)	stackfuel.com
Cookie Name	PopUp
Cookie Expiry	100

Accept	Google Analytics
Name	Google Analytics
Provider	Google Ireland Limited, Gordon House, Barrow Street, Dublin 4, Ireland
Purpose	Cookie from Google for website analytics. Generates statistical data about how the visitor uses the website.
Privacy Policy	https://policies.google.com/privacy?hl=de
Cookie Name	_ga,_gat,_gid
Cookie Expiry	2 Jahre

Accept	Google Tag Manager
Name	Google Tag Manager
Provider	Google Ireland Limited, Gordon House, Barrow Street, Dublin 4, Ireland
Purpose	Cookie from Google for website analytics. Generates statistical data about how the visitor uses the website.
Privacy Policy	https://policies.google.com/privacy?hl=de
Cookie Name	_ga,_gat,_gid
Cookie Expiry	2 Jahre

Accept	LinkedIn
Name	LinkedIn
Provider	https://linkedin.com
Host(s)	linkedin.com
Cookie Name	LinkedIn
Cookie Expiry	2 Jahre

SQL & Relational Databases

Course description

In this  course you will learn:

Target Audience