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 weeks)
    4 chapters + 3 exercise projects
    Mid level
    German
    Certificate of completion
    €1,790.00 incl. VAT
    21.03.2022
    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

    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.

    Start Dates

    12.12.2022
    Dauer: 4 weeks

    Download the­ curriculum now.

    Curriculum_DS
    Curriculum_DS
    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.  

    Künstliche Intelligenz in Unternehmen: AI Literacy hilft Dir dabei, den Einsatz von KI in Unternehmen besser zu verstehen und Du bekommst die nötigen Kernkompetenzen, um bestehende und neue KI-Anwendungen anhand verschiedener Szenarien aus dem Business-Alltag sicher zu verstehen, für Dein Unternehmen erfolgreich zu übertragen und mit ihnen zu interagieren.
    Feedback
    What our ­graduates say. 

    Check out out other courses.

    BI Analyst – Focus Power BI
    Qualification for the Job Role of a Business Intelligence Analyst
    Type:
    Online course
    Duration:
    72 hours (4 months)
    Analytics & Reporting – Focus Power BI
    Guide to Effective Dashboards in Power BI
    Type:
    Online course
    Duration:
    32 hours (4 weeks)
    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.