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 training 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 group

    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.

    Requirements for participation

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

      Online course

    • Duration

      4 weeks

    • Structure

      4 chapters + 3 exercise projects

    • Level

      Mid level

    • Languages

      German or English

    • Completion

      Certificate of completion

    That awaits you

    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.

    Modules

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

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

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

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

    Lade Dir jetzt das Curriculum herunter.

    Curruculum_SQL
    Learning environment

    Train online in the browser in our interactive learning platform.

    StackFuel offers you an innovative learning environment with which you can develop your data skills in the most effective way – interactively and with real practical tasks. Learn to program in our data lab and develop algorithms and automations with real data sets from the industry. Convince yourself now and benefit from 80% practice in our training courses.
    Why StackFuel

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

    Whether you are an employee, unemployed or a manager – we will develop you into a data talent with our fundable further training and retraining courses that are suitable for every department and every career level. We ensure your learning success with our dedicated mentoring team and always stay on the ball with you. Our practical tasks and projects make you fit for dealing with the latest technologies and applications.
    100% FOR YOU

    Personalize your learning experience.

    Non-binding trial week
    With our non-binding trial week you get an insight into your desired training. Then you have the choice: either you decide on the training or you look for another one that suits you even better.
    Individual course modules
    With us you can put together the modules of your further training tailored to your needs. Whether business intelligence, data analytics, data science or programming: use your time optimally to build up expert knowledge and develop your skills individually.
    Feedback

    Here's what our graduates say.

    Payment options

    Find your suitable financing.

    With an education voucher, you can have your further education financed 100% by the job center or the employment agency if you are currently registered as unemployed or looking for a job.
    If you are employed, you can have your employer partially or fully finance your further training through the Qualification Opportunities Act – regardless of qualification, age and company size.
    If you are currently enrolled at a university or college in Germany, you can complete our courses at a 50% discount.
    Use our installment plan to spread the cost of your training over several months and maintain your financial flexibility.
    Pay safely and easily after your training by having us issue you an invoice.
    Our FAQ

    The most important questions at a glance.

    The need for data experts is high. Around 4 million data experts will be needed in Europe by 2025. And in 2021 alone, more than 80,000 positions for IT specialists were advertised in Germany. Above all, the demand for data and AI experts continues to increase enormously. But a decision for a data career is so much more than just a secure future decision! As a data expert, you deal with strong, socially relevant topics, and at the same time you are a tech professional and communicative and creative. The job is varied, can be combined with most other jobs and offers an attractive salary. And the most important thing: It can be learned with us without fail!
    Yes, after successfully completing the training, you will receive a certificate of completion from us that you can show when you apply. Data Analysts and Data Scientists are desperately needed in many economic sectors. Even without relevant professional experience, your chances of getting an entry-level job are good. In addition, there are analysts in almost every industry, they have different job titles, but the skills you need are the same as those of a data analyst or data scientist.
    No, the training is flexible in terms of time and designed to be part-time. You can pursue your profession without restrictions and can plan your learning times at the time that suits you best. If you suddenly have more time available, you are welcome to contact us by e-mail and we will activate the learning content for the part-time version in your account. In this variant, you can complete the training in just four weeks. If you notice that you need more time, you can still complete the content in the normal time.

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

    Free Consultation

    Let yourself be free and without obligation advice from us!