Data Analyst | Guided E-Learning

Database Management and Data Analysis with MySQL & SQL

Join us to become a Certified Data Analyst. Study online at your own pace with mentor support, and develop expertise in database management, exploratory data analysis and data analysis with SQL. Kick-start your career with a well-paid, rewarding job.

Agentur der Arbeit 100% free with a Bildungsgutschein from the Arbeitsagentur
Community
Join a community of more than 10K successful graduates
Database Management and Data Analysis with MySQL & SQL

Start

Weekly, every monday

Format

Guided E-Learning with mentor

Duration

Full-time: 4 weeks
Part-time: 8 weeks
On-the-job: 4 months

Scope

Full-time: 30-40 h / week
Part-time: 10-20 h / week
On-the-job: 2-4 h / week

Level of learning

Beginner & Intermediate

Languages

English
German

Certificate

State-recognised AZAV certificate

Start now. Make your move. Step into your dream career

Build your future with a new career in database management. 100% free!

Learn at your own pace with this database management bootcamp fully online and flexible, whenever and wherever it suits you. Design your learning journey and advance at a rhythm that matches your lifestyle.

Acquire in-demand, practical skills in Relational databases, database management, data analysis, business intelligence and MySQL/SQL. Learn 1-on-1 with an experienced mentor, accompanied by your personal study advisor and our career coaches. Make yourself job-ready and secure a future-proof job.

Tools, techniques & methods
MySQL MySQL SQL SQL Database Database Data Analysis Data Analysis Database Management Database Management Data Management Data Management Business Intelligence (BI) Business Intelligence (BI)
Content, skills & learning outcomes

  • Relational databases, database management & data analysis
  • Databases and database management systems: MySQL and SQL
  • Advanced SQL for business intelligence and data analysis

Learn anytime, anywhere

Tailor your professional development to your preferences, schedule and lifestyle. Learn anytime, anywhere and at your own pace.

Personal mentoring via video conference

Book an appointment at any time with your mentor, who will accompany you on your learning and career path and provide you with personal support.

Job-ready practice in real-world projects

Our courses are based on practical, industry-specific scenarios and teach practical skills that can be directly applied in your professional life.

University-level multimedia content

You will benefit from interactive content at university level. You can expect comprehensive articles, videos, quizzes and practical exercises that bring the theory to life.

Interactive live sessions with industry experts

Take part in interactive live workshops with industry experts to dynamically review and deepen your understanding of the learning content covered.

Career services for your new job

With application training, career consultations and our active job placement service, we help you on your way to your new job.

These companies are training their workforce with us and recruiting our students.

Invest in yourself and your career

Secure the best prospects for a job as Data Analyst

Secure a job in one of the fastest-growing professions in the technology industry. Acquire in-depth knowledge in Relational databases, database management, data analysis, business intelligence and MySQL/SQL. Develop exactly the skills you need for a career as a Data Analyst. Secure an attractive, well-paid job with a future in the IT industry.

€ 56.500

200

+8-10%

Top 10

Average annual salary (entry-level salary)
Average monthly job offers
Estimated employment growth by 2030
Fastest-growing jobs

€ 56.500

Average annual salary (entry-level salary)

200

Average monthly job offers

+8-10%

Estimated employment growth by 2030

Top 10

Fastest-growing jobs
Target group

Who are our bootcamps for?

This database management training course is ideal for beginners and advanced learners who want to expand their database management expertise. No prior knowledge of database management is necessary. We start with the basics and then gradually move on to more advanced topics. A basic understanding of database management can make it easier to get started.

Have your database management training course financed with a Bildungsgutschein from the Arbeitsagentur and Jobcenter. If you are registered as a job seeker, you can apply for a Bildungsgutschein for this database management course. We have created an application guide for this purpose. To apply for the Bildungsgutschein, you need a course offer.

Are you an employee of a company and want to build database management skills while working? Are you at risk of unemployment or is your company affected by structural change? Then your employer can take advantage of the Qualifizierungschancengesetz and have up to 100% of the training costs financed and up to 75% of the salary costs reimbursed.

There are many good reasons to become a Data Analyst with XDi. Get started now and register or let us advise you. We are happy to help.

Unemployed & job seekers

You are unemployed or seeking work, eligible for a Bildungsgutschein, and want to use this time to qualify for a new job as a Data Analyst.

Career changers and professionals switching fields

You’re a professional from another industry and want to become a Data Analyst to advance your career, grow, and seize new opportunities.

New employees & career starters

You’ve just started a job in a new work environment and lack the relevant skills to meet the job’s demands and work productively.

Employees at risk of unemployment

You’re an employee at a company affected by structural change, your job is at risk, and you need training to secure your position.

Aspiring Data Analysts

You are a Data Analyst and want to expand your knowledge in database management and advance your career.

Graduates and students

You have recently graduated or are still studying and want to enhance your academic qualifications with practical, industry-relevant skills.

Professionals and specialists

You are a specialist in your field, looking to expand your expertise, earn a certification, or optimally prepare for a certification exam.

Managers and executives

You want to advance your career, your department, or your company by successfully establishing database management within the organization.

Entrepreneurs and business owners

You are an entrepreneur or the owner of an SME and want to make your business more competitive and future-proof by leveraging database management knowledge.

Interested individuals

You are interested in database management and want to learn the practical, real-world application of database management tools for personal or professional purposes.

CURRICULUM

What you will learn in this database management bootcamp

Hands-on education in the skills of the future

In this database management course, you’ll acquire the most important database management skills based on a curriculum designed by industry experts. The database management training includes industry-validated, interactive content at a university level and extensive hands-on experience in real projects. You’ll build a portfolio and complete the program with a capstone project.

1

Introduction to Relational Databases, Database Management & Data Analysis

2

Databases and Database Management Systems: MySQL and SQL

3

Advanced SQL for Business Intelligence and Data Analysis

Summary

This module is an introduction to the world of relational databases – including their structure, purpose and key concepts such as tables, primary keys and foreign keys.
You will also learn how SQL fits into the bigger picture of database management and data analysis – laying the foundation for the practical exercises in the following modules.

Learning Outcomes
  • to understand the basic structures and concepts of relational databases – including tables, primary keys and foreign keys.
  • to explain the role of SQL in the context of database management and data analysis.
  • to recognize the practical benefits of relational databases for data-driven decision making processes in business contexts.
Content
  • Welcome to the world of databases
  • What is a relational database? Core concepts and data structures
  • Introduction to data analysis with SQL and database management
Core Skills
Relational databases SQL Fundamentals of data analysis Business Intelligence Basics MySQL Database management systems
Summary

Get started with MySQL and SQL by learning how to install MySQL Workbench, create databases and tables, and write basic SQL queries.
In this module, you’ll learn how to filter data, join multiple tables and use SQL for basic calculations, grouping and sorting – laying the foundation for real data projects.

Learning Outcomes

You will learn:

  • Set up and operate MySQL Workbench – including creating databases and designing relational tables.
  • Write and execute basic SQL queries to insert, update and retrieve data.
  • Apply SQL clauses such as WHERE, JOIN, GROUP BY and ORDER BY to filter, combine and analyze data across multiple tables.
  • Perform basic data aggregation and arithmetic operations to gain data-based insights.
Content
  • Introduction: The relational database model and SQL
  • Installation and first steps with the MySQL Workbench
  • Getting started: Creating a database and tables
  • Inserting, editing and querying values
  • Further options for using the WHERE clause
  • Using foreign keys in the database
  • Joining queries for multiple tables
  • The JOIN command: Using data from multiple tables
  • Counting entries, summing values and other mathematical operations
  • Grouping and sorting data
Core Skills
Database concepts SQL Relational Database MySQL Workbench Table Design Database Creation Aggregate Functions Arithmetic operations Data grouping Sorting techniques
Summary

Expand your SQL knowledge with advanced query techniques used in business intelligence and data analysis.
In this module, you will learn about conditional logic, wildcards, date and time functions, access rights and transaction control. You will also work with practical BI queries and learn how to import external data from CSV files and use it for analyses.

Learning Outcomes

You will learn:

  • to apply advanced SQL concepts such as HAVING, CASE and wildcards to gain deeper insights from relational databases.
  • to work with date and time functions, virtual tables and views to support dynamic reporting requirements.
  • to manage user access rights and execute transactions with SQL commands such as COMMIT and ROLLBACK to ensure secure data processing.
  • to import external data from CSV files and integrate it into SQL-based analyses – for practical BI use cases.
Content
  • Introduction: More sophisticated SQL commands for BI
  • Defining conditions with the HAVING clause
  • Working with wildcards
  • CASE: Linking actions to conditions
  • Relationships between tables with foreign keys
  • Advanced options for data output
  • Working with date and time specifications
  • Managing database access rights
  • Transactions for more secure data processing
  • Important advanced SQL queries for BI – Part 1
  • Important advanced SQL queries for BI – Part 2
  • Importing CSV files
Core Skills
HAVING clause, WHERE, SELECT Wildcards (placeholder characters) CASE WHEN, END, THEN, ELSE Foreign keys CONCAT, alias, virtual tables, views Database access rights Transactions (ROLLBACK, START TRANSACTION, COMMIT) Window functions Import of CSV files

Introduction to Relational Databases, Database Management & Data Analysis

Summary

This module is an introduction to the world of relational databases – including their structure, purpose and key concepts such as tables, primary keys and foreign keys.
You will also learn how SQL fits into the bigger picture of database management and data analysis – laying the foundation for the practical exercises in the following modules.

Learning Outcomes
  • to understand the basic structures and concepts of relational databases – including tables, primary keys and foreign keys.
  • to explain the role of SQL in the context of database management and data analysis.
  • to recognize the practical benefits of relational databases for data-driven decision making processes in business contexts.
Content
  • Welcome to the world of databases
  • What is a relational database? Core concepts and data structures
  • Introduction to data analysis with SQL and database management
Core Skills
Relational databases SQL Fundamentals of data analysis Business Intelligence Basics MySQL Database management systems

Databases and Database Management Systems: MySQL and SQL

Summary

Get started with MySQL and SQL by learning how to install MySQL Workbench, create databases and tables, and write basic SQL queries.
In this module, you’ll learn how to filter data, join multiple tables and use SQL for basic calculations, grouping and sorting – laying the foundation for real data projects.

Learning Outcomes

You will learn:

  • Set up and operate MySQL Workbench – including creating databases and designing relational tables.
  • Write and execute basic SQL queries to insert, update and retrieve data.
  • Apply SQL clauses such as WHERE, JOIN, GROUP BY and ORDER BY to filter, combine and analyze data across multiple tables.
  • Perform basic data aggregation and arithmetic operations to gain data-based insights.
Content
  • Introduction: The relational database model and SQL
  • Installation and first steps with the MySQL Workbench
  • Getting started: Creating a database and tables
  • Inserting, editing and querying values
  • Further options for using the WHERE clause
  • Using foreign keys in the database
  • Joining queries for multiple tables
  • The JOIN command: Using data from multiple tables
  • Counting entries, summing values and other mathematical operations
  • Grouping and sorting data
Core Skills
Database concepts SQL Relational Database MySQL Workbench Table Design Database Creation Aggregate Functions Arithmetic operations Data grouping Sorting techniques

Advanced SQL for Business Intelligence and Data Analysis

Summary

Expand your SQL knowledge with advanced query techniques used in business intelligence and data analysis.
In this module, you will learn about conditional logic, wildcards, date and time functions, access rights and transaction control. You will also work with practical BI queries and learn how to import external data from CSV files and use it for analyses.

Learning Outcomes

You will learn:

  • to apply advanced SQL concepts such as HAVING, CASE and wildcards to gain deeper insights from relational databases.
  • to work with date and time functions, virtual tables and views to support dynamic reporting requirements.
  • to manage user access rights and execute transactions with SQL commands such as COMMIT and ROLLBACK to ensure secure data processing.
  • to import external data from CSV files and integrate it into SQL-based analyses – for practical BI use cases.
Content
  • Introduction: More sophisticated SQL commands for BI
  • Defining conditions with the HAVING clause
  • Working with wildcards
  • CASE: Linking actions to conditions
  • Relationships between tables with foreign keys
  • Advanced options for data output
  • Working with date and time specifications
  • Managing database access rights
  • Transactions for more secure data processing
  • Important advanced SQL queries for BI – Part 1
  • Important advanced SQL queries for BI – Part 2
  • Importing CSV files
Core Skills
HAVING clause, WHERE, SELECT Wildcards (placeholder characters) CASE WHEN, END, THEN, ELSE Foreign keys CONCAT, alias, virtual tables, views Database access rights Transactions (ROLLBACK, START TRANSACTION, COMMIT) Window functions Import of CSV files
It's your path!

Learn how it suits you

You decide how, when and where you learn. Whether you want to study intensively full-time, flexibly part-time or on the job alongside your work, our courses adapt to your life.

Full-time

Want to immerse yourself fully in database management? Then take part in our full-time intensive course.

  • Qualification in 4 weeks
  • Learn online flexibly
  • 30-40 hours per week

Part-time

Do you have a part-time job, children or other commitments? Then take the database management course part-time.

  • Qualification in 8 weeks
  • Learn online flexibly
  • 10-20 hours per week

While working

Do you have a full-time job and hardly any time to study during the day? Then study alongside your job, in the evenings or at weekends.

  • Qualification in 4 months
  • Study online alongside your job
  • 2-4 hours per week

Your learning journey at a glance

Discover what your learning journey will look like and how to progress step by step toward becoming a Data Analyst.

White_Rocket_Vektor
Your path to a future-proof profession

Student-centered online learning

Learn with and from the best. Get guidance from your personal mentor, career coaches who prepare you for the job market, and study advisors who are always there for you. Plus, connect with fellow students and alumni in our community to share insights on all aspects of your continuing education.

We’ve got your back! With our learner-focused approach, you get the support you need and a motivated team by your side.

One-on-one mentoring

Kickstart your career with support from a seasoned professional to ensure you’re fully prepared.

Support from your study advisor

Your study advisors are here to guide you through every question and every challenge on your journey.

Guidance from
career coaches

Our career coaches are with you from the start, helping you build a successful career.

Your learning community

Learning works best with others. Since learning isn’t a solo journey, you get exclusive access to our community.

Real world practice. Capstone project. Accredited portfolio.

Project based learning with
real-world skills and portfolio

The best way to learn database management is by gaining hands-on experience. Work on real projects and tasks to advance your career as a Data Analyst.

Hands-on experience

Work on a hands-on project during your training and complete tasks just like those you’ll encounter in your future job.

Capstone project that opens doors

Create a capstone project that highlights your learning achievements and the skills you’ve gained in database management.

Industry-approved portfolio

Create an impressive portfolio that showcases your skills and opens doors with hiring managers.

5_Sterne_Bewertung
5,0/5,0

Highly recommended

Kursfinder_Bewertung_5-5
5_Sterne_Bewertung
4,9/5,0

Highest quality

5_Sterne_Bewertung
5,0/5,0

Customer satisfaction

Make the most of this opportunity

Secure excellent earning potential in a lucrative job as a future Data Analyst.

Business Analyst

analyse business processes and support optimisations

Up to   63.000 €

Data Analyst

analyse data and create reports for data-driven decisions

Up to   56.500 €

Data Engineer

build and maintain data infrastructure for analytics and applications

Up to   65.800 €

Data Scientist

develop models, evaluate big data and deliver forecasts

Up to   64.000 €

Machine Learning Engineer

develop and implement machine learning models and algorithms

Up to   66.000 €
Unique offer. Huge benefits.

We support you from day one in finding your dream job

Make the most of our career services to kickstart a successful database management career and build connections with leading employers.

CV & interview training

Take advantage of free job application training, customized to what employers are looking for.

Career coaching

We offer free career consultations with experienced HR managers to provide you with personalized advice.

Study and training guidance

Our study advisors support you with every question and help you overcome every challenge.

Job placement

We work closely with companies to connect students with the best job opportunities.

Do you need help with financing?

Financing made easy

A range of financing options is available for your professional development. Find out more here or consult our customer advisors for individual guidance.

Bildungsgutschein

Continue your professional development free of charge. If you are looking for work or your job is threatened by structural change, then take advantage of the government-funded Bildungsgutschein.

info icon Free

Bildungsgutschein

100% funded by the Arbeitsagentur

0 €

One-time Payment

Pay your tuition fees before the start of the training program. The easiest and most affordable way to further your education.

info icon Best price

One-time payment

Pay in full and save money

2.240 €

Qualifizierungschancengesetz

Use government funding to cover up to 100% of your course fees and 75% of your salary.

info icon Free

Qualifizierungschancengesetz

Secure funding for your training costs and salary support

0,00 €

Bildungsgutschein

Leverage the Government-funded Bildungsgutschein when your business is affected by structural shifts and employees need upskilling to stay employed.

info icon Free

Bildungsgutschein

100% funded by the Employment Agency

0,00 €

One-time Payment

Upskill your employees and let them continue their training in database management alongside work.

info icon Flexible

One-time Payment

Register now and select your payment option.

2.240 €

Team Quota

Make your team strong in database management – explore our special offers for groups.

info icon Group Pricing

Team Quota

Enroll multiple team members and benefit from special rates.

On request

We have helped many enthusiastic people to develop professionally

Thousands of eager learners have successfully completed their training with us – see how we can help you to!

"The training "Certified Data Analyst" was a crucial success factor - I raised my knowledge to a new level in a very short time. The dynamic and focused pace was just right to keep me fully challenged and consistently engaged with the topics. The practice-oriented strategies were particularly valuable, delivering results that could be implemented immediately. The well thought-out questions and ground-breaking impulses not only broadened my thinking, but also highlighted clear areas of action for future success. For me, further training is not a question of if - but when, in order to continue to grow strategically."
Andreas Manietta
"Participating in the "Certified Data Scientist" course was a groundbreaking decision for me. The richness of practical knowledge exceeded my expectations and gave me a deeper understanding of complex data analysis. The challenges in the course not only strengthened my skills but also pushed my motivation to excel. The support from XDi was excellent and I feel well equipped to take on challenging projects in data science. I highly recommend this course to anyone who wants to take their career in this field to the next level!"
Daniel Naesa
"I am glad I decided to take the "Certified Data Scientist" course. The course has provided a tremendous amount of up-to-date knowledge, and has far exceeded my personal expectations. The course is without question challenging, but quickly rewards with a steep and presentable learning curve. I felt optimally supported by XDi at all times."
Denis Sarcevic
"I thoroughly enjoyed the Data Science course, especially the opportunity to apply theoretical knowledge to real-world scenarios. The course was well-structured and provided a solid foundation in data analysis with many practical examples to reinforce learning. I gained valuable insights and skills that I look forward to using in future roles."
Duygu Dogan
"The Data Analyst course brought me great joy! My mentor was always by my side, offering valuable professional advice and support, helping me every step of the way. The course was clearly structured and well-organized, enabling me to gain a comprehensive understanding of the role of a data analyst. The clear course design and the valuable support from my mentor were especially helpful in developing solid knowledge. I am happy to recommend this course to friends and acquaintances!"
Liudmyla Rotar
Analyst Engineer
"The Certified Data Analyst course provided me with comprehensive insights into the tasks of a Data Analyst. I was able to practice my skills through many practical examples and could always reach out to my mentor for questions or issues. The final project was enjoyable, and I had the chance to showcase my skills once again"
Louisa Fiedler
"The Certified Data Analyst training is very well structured and offers a comprehensive first insight into a variety of methods for data analysis and data visualization - from Excel and SQL to Python and Power BI. The focus is on Python/Pandas/Seaborn/Matploplib. The application examples from completely different fields are designed accordingly. I particularly enjoyed analyzing video game and Pokémon statistics, where it almost felt like I was using data to figure out how to become the very best Pokémon trainer. I always felt well looked after by the XDi team and Thomas was always there to mentor me."
Severine Rupp
Competent. Experienced. Empathetic.

Our mentors

Our trainers are industry experts with extensive experience in various companies, industries and countries. You will receive exactly the support you need to learn what you want. You will benefit from individuals with in-depth specialist knowledge and teaching skills.

info icon >10 years of experience info icon Industry experts info icon Extensive expertise info icon Pedagogical competence info icon Real personalities

Sven Ertel works as a freelance data analyst in a wide range of industries and has gained extensive experience in supporting companies, especially their (BI) departments. His expertise includes the design and implementation of reporting systems, data preparation and connection as well as data visualization. Among other things, he has developed global sales monitoring systems for a Bavarian car manufacturer and analyzed and prepared marketing campaign data for a German aviation company.

In his role as a data scientist at the Serviceplan Group, Sven has established a solid, professional foundation in project management for various customer projects. He has also refined and applied his IT skills in various technologies. During this time, he also led training and education on UX/UI-optimized BI reporting, helping to improve the usability and efficiency of BI solutions.

Sven Ertel

Data Scientist, Data Analyst

Sven Ertel

Data Scientist, Data Analyst

Your questions - our answers

Do you still have questions? You can find the answers here. Is your question not answered? Then simply contact us directly.

FAQ_Ansprechpartnerinnen
More XDi training courses that may interest you

Discover more interesting training courses

Business, Data & AI

Certified Data Scientist (KI)

Data Science, Machine Learning und KI mit Python...

Business, Data & AI

Certified Data Analyst

Data analytics, databases, data storytelling and...

Business, Data & AI

Certified Business Intelligence Analyst

Relational database management system, MySQL, SQL,...

Business, Data & AI

Business Intelligence with Power BI & Tableau

Business Intelligence (BI), Power BI, Tableau, data...

Certified and accredited

Government-approved and 100% eligible for funding. We are AZAV and ZFU certified. Our e-learning courses can be 100% financed with a Bildungsgutschein from the Arbeitsagentur.

Certqua_Siegel
ZFU_Siegel

Certified and accredited

Government-approved and 100% eligible for funding. We are AZAV and ZFU certified. Our e-learning courses can be 100% financed with a Bildungsgutschein from the Arbeitsagentur.

Certqua_Siegel
ZFU_Siegel

Get in touch with us

Send us a message. We will get back to you within 24 hours.

Your concern

Choose a salutation*
  • Ms.
  • Mr.
  • Ms. Dr.
  • Mr. Dr.
  • Ms. Prof.
  • Mr. Prof.
How did you learn about us? How did you learn about us?
  • mein Now / KURSNET
  • Arbeitsagentur
  • Jobcenter
  • Private educational consultants
  • Trade fair / event
  • Google
  • Kursfinder
  • LinkedIn
  • Facebook
  • Instagram
  • Bing
  • Artificial intelligence
  • X
  • YouTube
  • Newsletter
  • Personal recommendation
  • HR-Manager / HR-Department
  • Other
*Mandatory fields

Your direct contact to us

We look forward to hearing from you and will get back to you soon.
  • Do you want to further your education and get started?
  • Would you like to find out more about us?
  • Do you have questions and need advice?

Any questions?

We are happy to help. You can reach us Monday to Friday from 8:00 to 17:00.
Valentina Caronia

Valentina Caronia

Account manager & Community manager