Course Plan
EDK
RegistrationTop ratings
Get free trial access now Try first, then study!
4.92/5.0 (from 386 Trusted Shops Reviews )
4.9/5.0
- Google reviews
MariaDB and MySQL Administrator
starting at €1.490,- | face-to-face course
» Our Course Packages
Flexible learning - our possible learning options for the course:
Course Fee: from €
1.490,-
Including Exam Fees and Study Materials
Installment Plans Available
No Interest, No Fees
No Interest, No Fees
Information Event
Entry possible at any time
Course Upgrades
Add Another Course
Add Another Course
Academy account forever
learning materials available for life
learning materials available for life
Money-back guarantee
14 days right of withdrawal (according to the Distance Selling Act)
14 days right of withdrawal (according to the Distance Selling Act)
Sound scientific content
Certificate valid worldwide & unlimited in time
Certificate valid worldwide & unlimited in time
Recognized & Certified
Our graduates, partners & friends say
Our team will be happy to advise you at any time by phone, chat or in person
Your complete course for database management systems
Expand your IT knowledge and become a database professional with our MariaDB and MySQL Administrator training. In this practice-oriented course, you will learn the essential techniques for managing and optimizing relational databases. Immerse yourself in the world of relational databases and learn how to manage data efficiently and securely.
In today's digital world, data is at the heart of every organization. MariaDB and MySQL form the backbone of many applications, both on the web and within companies. With the all-round package Fundamentals of IT Competence MariaDB and MySQL - Fundamentals , you will be able to manage and analyze large amounts of data efficiently.
Practical exercises and projects are an integral part of the course so that you can directly apply and consolidate what you have learned. Work on real-life scenarios and develop solutions that you can implement in your professional practice.
Sign up for our training in MariaDB and MySQL and take the first step towards a successful career in database administration. Become an expert in databases and open up new career opportunities in a dynamic and growing industry.
Factsheet on the course
Extent of learning
442 E
3
EQF level
The training is based on EQF level 3 »
Course start
Possible immediately
Learning variant
Classroom Courses
Available
Languages
DE
EN
ES
All course dates
Find your classroom course
MariaDB and MySQL Ad... -
Half-day weekend course
| 18-01-2025 | starting at 1.490,-
Presence phase from: 15-02-2025
Questions about the course? We are happy to advise you.
Join in at any time!
Questions about the course? We are happy to advise you.
Everything at a glance!
MariaDB and MySQL Administrator
Expert knowledge about databases
Expand your knowledge with MariaDB and MySQL!
With MariaDB and MySQL you are well equipped with all the essential aspects of database administration. The training prepares you perfectly for the exciting tasks as a database administrator, developer or system integrator. The training includes the basics of IT skills, MariaDB and MySQL basics .
What can you expect from our training?
The course "MariaDB and MySQL - the administration course" starts with a comprehensive introduction to IT competence, MariaDB and MySQL, including installation and configuration on different operating systems. You will be familiarized with tools such as phpMyAdmin and MySQL Workbench to help you manage your databases efficiently. You will learn the basic syntax and structure of how to create databases and tables, formulate queries and manipulate data.
You will also get to know the various storage engines such as InnoDB and MyISAM in order to choose the best solution for your requirements. Security is the focus when it comes to managing user accounts and permissions to control access to your databases.
You will learn how to effectively store, back up and restore your data, including methods for automating backups and minimizing downtime.
To optimize the performance of your databases through indexing, query optimization and configuration tuning. You will also learn how to set up your databases for high availability and scalability, including replication and clustering.
Conditions of participation
- Online or written registration
- Basic IT knowledge is recommended but not required
- Minimum age 18 years (for participants under 18 years, written parental consent is required for registration)
- Access to an internet-enabled device
- Access to a stable internet connection
Certificate of completion
Our certificates are valid worldwide and are issued in different versions. On request, you can receive our certificate in several languages (DE, EN, ES), with country-specific information and with or without printed grades.
All these variants are available to you free of charge for a lifetime for downloading from your online campus. In addition, depending on the learning package you have purchased, you will receive a certificate of your choice, which will be issued on special high-quality embossed paper.
The following certificate (in several languages DE, EN, ES) will be awarded:
"MariaDB and MySQL Administrator "
Do you have specific questions about the training?
We will be happy to help you by phone, e-mail or chat.
Procedure & duration - How your training is structured
The training consists of three modules
You can find the list of modules and subjects by clicking on the "Course content" tab.Duration of the course
As our training courses can be designed very flexibly, the duration of the training depends heavily on your own learning initiative, the amount of time you spend each week and your previous knowledge. Depending on how much time you can invest and how quickly you absorb the required knowledge, it is also possible to complete the training more quickly.Online live training via Zoom
The training is conducted live online via Zoom. The instructors teach in real time and share their screen so that you can follow the lessons from the comfort of your own home. You have access to all dates and the link to the live webinar via the Online Campus, so you can easily take part from home.You will receive the Zoom meeting link by e-mail before the start of the course and it will also be available on our Flexyfit learning platform. Please make sure that you have entered your current e-mail address when registering.
With online distance learning courses, you set the tone
Learn at your own pace, when and where you want. The Academy account accompanies you on your computer, tablet or smartphone and contains everything you need for the course.You decide how you learn
You can choose from a wide range of Full HD learning videos in which our top instructors teach you the training content. You can also read the content in our scripts and presentations.No pain, no gain
Along the way, you will work your way through a variety of compulsory and additional tasks. These include writing a simple program, carrying out a security analysis or using a cloud service. All tasks are explained in a step-by-step guide so that you can apply what you have learned in practice.Last but not least... Exams
You can expect lots of multiple choice online exams to test your knowledge. You can take a test exam before each exam to be optimally prepared.
Detailed Course Contents
Extent of learning
442 E | Volume
EDK
187
IT competence
PL
216
Presence | Self-study
RE
6
Literature research
TE
23
Practical realization
AE
10
Additional tasks & examinations
This training is suitable for educational leave. The individual review and approval is subject to the respective funding agency. For more detailed information on the duration and procedure of educational leave, please contact us directly! Book a consultation appointment now.
Participation in the face-to-face webinars is mandatory for educational leave and must be proven to the AMS. Confirmation of attendance must be requested on the participant's own responsibility. Confirmation of attendance of the face-to-face webinar will only be issued during each webinar if requested by the participant.
Module IT competence
Show all chapters of the subjects
Basic knowledge of EDP
The subject "Basic IT knowledge" teaches basic knowledge and concepts of electronic data processing. It offers a comprehensive introduction to the world of computer technology, operating systems, networks and much more.
A computer is an electronic device that is used to process data. It performs calculations, stores and processes information. There are different types of computers, including personal computers (PCs), servers and embedded systems. Each type has specific applications and functions.
An operating system manages the hardware and software resources of a computer. It enables the execution of applications and ensures communication between hardware and software. The best-known operating systems include Windows, macOS and Linux, although each operating system has its own characteristics and areas of application.
Code can be translated by either compilers or interpreters. Compilers convert the entire code into machine language, while interpreters execute the code line by line. The fetch-decode-execute cycle describes the process by which the processor fetches, decodes and executes instructions.
A process is a program that is being executed. The management of processes includes the allocation of resources and the monitoring of their execution. Multitasking enables the simultaneous execution of several processes, whereby process scheduling determines which processes are executed when and for how long.
Hardware is controlled by special software known as drivers. Drivers enable communication between the operating system and hardware components by forwarding specific commands and data.
This module provides a solid foundation in the basic principles of electronic data processing and prepares students to understand and apply more complex concepts in IT.
A computer is an electronic device that is used to process data. It performs calculations, stores and processes information. There are different types of computers, including personal computers (PCs), servers and embedded systems. Each type has specific applications and functions.
An operating system manages the hardware and software resources of a computer. It enables the execution of applications and ensures communication between hardware and software. The best-known operating systems include Windows, macOS and Linux, although each operating system has its own characteristics and areas of application.
Code can be translated by either compilers or interpreters. Compilers convert the entire code into machine language, while interpreters execute the code line by line. The fetch-decode-execute cycle describes the process by which the processor fetches, decodes and executes instructions.
A process is a program that is being executed. The management of processes includes the allocation of resources and the monitoring of their execution. Multitasking enables the simultaneous execution of several processes, whereby process scheduling determines which processes are executed when and for how long.
Hardware is controlled by special software known as drivers. Drivers enable communication between the operating system and hardware components by forwarding specific commands and data.
This module provides a solid foundation in the basic principles of electronic data processing and prepares students to understand and apply more complex concepts in IT.
- WHAT IS A CALCULATOR?
- Definition and basic concepts
- Different types of computers (PCs, servers, embedded systems)
- WHAT IS AN OPERATING SYSTEM?
- Tasks of an operating system
- Examples of common operating systems (Windows, macOS, Linux)
- HOW IS CODE EXECUTED?
- Translation and execution of code (compiler vs. interpreter)
- Sequence of code execution (fetch-decode-execute cycle)
- WHAT ARE PROCESSES?
- Definition and management of processes
- Multitasking and process scheduling
- HOW IS HARDWARE CONTROLLED?
- Basics of hardware control
- Drivers and their role in the system
- WHAT IS A PROGRAM?
- Definition of a program
- Differences between applications and system software
- NETWORK BASICS
- Basics of network technology
- Network protocols and architectures (TCP/IP, OSI model)
- WHAT IS A SERVER?
- Definition and tasks of a server
- Differences between server and client systems
- Examples and areas of application of servers
- WHAT IS THE CLOUD?
- Definition and basics of cloud technology
- Differences between public, private and hybrid cloud
- Advantages and challenges of using the cloud
- INTERNET OF THINGS (IOT)
- Definition and basics of the IoT
- Examples of IoT applications (smart homes, Industry 4.0)
- Challenges and future of the IoT
- SERVICES
- Definition and importance of IT services
- Different types of services (web services, microservices)
- Examples and areas of application of IT services
Show chapter
Coding
The subject "Coding " teaches basic and advanced concepts of programming and software development. It aims to provide participants with a sound understanding of the various programming languages, principles and techniques. In addition, what has been learned is consolidated through knowledge tests and practical tasks. Here are the main topics covered in this module:
Programming languages and how they work
Participants will learn the basic principles and concepts of programming languages. An overview of high-level and low-level programming languages will be given, with the differences between these types clearly highlighted. High-level languages such as Python and Java are compared to machine-oriented languages such as Assembly.
From Visual Programming to 0 and 1
This section covers the range of programming from visual programming languages to machine-oriented languages. Examples of visual programming languages, such as Scratch, and machine-oriented languages, such as Assembly, are presented. The different levels of programming and their applications are explained.
Fundamentals of programming
The basic concepts of programming are taught here. These include the syntax and semantics of programming languages, the declaration and use of variables and data types (such as integer, float, string, boolean), as well as the use of arithmetic, logical and comparison operators.
Design patterns
Design patterns are proven solution patterns for recurring problems in software development. Participants learn the definition and purpose of design patterns and are given examples of common patterns such as singleton, factory and observer. The application and advantages of design patterns in software development are also discussed.
Control structures
This section covers the basic control structures in programming, including conditions and branching with if, else and elif statements as well as loops such as for and while loops. The importance of loop control using break and continue is also explained.
Functions and modularity
Participants will learn how to define and call functions, including parameters, return values and code reusability. The basic principles of modularity and the division of code into manageable, reusable modules are also covered.
Basic data structures
This section provides a basic understanding of data structures such as lists, arrays, dictionaries, hashmaps, tuples and sets. Students will learn how to create, access and modify these structures.
Simple algorithms and problem solving
Participants are introduced to basic sorting algorithms such as bubble sort and selection sort. They will also learn about search algorithms such as linear and binary search. Systematic problem-solving strategies and debugging methods are discussed.
Object-oriented programming (OOP)
The basic principles of object-oriented programming are taught, including classes, objects, attributes and methods. Concepts such as inheritance, polymorphism and encapsulation are fundamentally explained and illustrated with simple examples.
Simple projects and practical applications
Participants put their knowledge into practice in small, practical projects, such as the development of a calculator, a to-do list or a simple game. Finally, simple techniques for checking and improving your own code through code reviews are covered.
Programming languages and how they work
Participants will learn the basic principles and concepts of programming languages. An overview of high-level and low-level programming languages will be given, with the differences between these types clearly highlighted. High-level languages such as Python and Java are compared to machine-oriented languages such as Assembly.
From Visual Programming to 0 and 1
This section covers the range of programming from visual programming languages to machine-oriented languages. Examples of visual programming languages, such as Scratch, and machine-oriented languages, such as Assembly, are presented. The different levels of programming and their applications are explained.
Fundamentals of programming
The basic concepts of programming are taught here. These include the syntax and semantics of programming languages, the declaration and use of variables and data types (such as integer, float, string, boolean), as well as the use of arithmetic, logical and comparison operators.
Design patterns
Design patterns are proven solution patterns for recurring problems in software development. Participants learn the definition and purpose of design patterns and are given examples of common patterns such as singleton, factory and observer. The application and advantages of design patterns in software development are also discussed.
Control structures
This section covers the basic control structures in programming, including conditions and branching with if, else and elif statements as well as loops such as for and while loops. The importance of loop control using break and continue is also explained.
Functions and modularity
Participants will learn how to define and call functions, including parameters, return values and code reusability. The basic principles of modularity and the division of code into manageable, reusable modules are also covered.
Basic data structures
This section provides a basic understanding of data structures such as lists, arrays, dictionaries, hashmaps, tuples and sets. Students will learn how to create, access and modify these structures.
Simple algorithms and problem solving
Participants are introduced to basic sorting algorithms such as bubble sort and selection sort. They will also learn about search algorithms such as linear and binary search. Systematic problem-solving strategies and debugging methods are discussed.
Object-oriented programming (OOP)
The basic principles of object-oriented programming are taught, including classes, objects, attributes and methods. Concepts such as inheritance, polymorphism and encapsulation are fundamentally explained and illustrated with simple examples.
Simple projects and practical applications
Participants put their knowledge into practice in small, practical projects, such as the development of a calculator, a to-do list or a simple game. Finally, simple techniques for checking and improving your own code through code reviews are covered.
- PROGRAMMING LANGUAGES / TYPES
- Principles and concepts of programming languages
- Differences between high-level and low-level languages
- HOW DO THEY WORK?
- From visual programming to 0 and 1 (machine-oriented languages)
- Different levels of programming
- Examples of visual and machine-oriented programming languages
- BASICS OF PROGRAMMING
- Syntax and semantics: explanation of syntax rules and the meaning of lines of code
- Variables and data types: Different data types (integer, float, string, boolean) and how to declare and use variables
- Operators: Arithmetic, logical and comparison operators
- DESIGN PATTERNS
- Definition and purpose of design patterns
- Examples of common design patterns (singleton, factory, observer)
- Application and advantages of design patterns in software development
- CONTROL STRUCTURES
- Conditions and branches: if, else, and elif statements
- Loops: for and while loops, as well as the meaning of loop control (break, continue)
- FUNCTIONS AND MODULARITY
- Definition and calling of functions: Parameters, return values and the importance of code reusability
- Basic principles of modularity: how to divide code into manageable, reusable modules
- BASIC DATA STRUCTURES
- Lists and arrays: Creating, accessing, and modifying elements
- Dictionaries and hashmaps: Basic understanding and application
- Tuples and sets: use and differences to lists and dictionaries
- SIMPLE ALGORITHMS AND PROBLEM SOLVING
- Sorting algorithms: Introduction to simple sorting methods such as bubble sort and selection sort
- Searching: Linear and binary searches
- Problem solving strategies: Approach methods for systematic problem solving and debugging
- OBJECT-ORIENTED PROGRAMMING (OOP)
- Basic principles of OOP: classes, objects, attributes, methods
- Concepts such as inheritance, polymorphism and encapsulation: basic explanations and simple examples
- SIMPLE PROJECTS AND PRACTICAL APPLICATIONS
- Small projects: Practice-oriented exercises such as a calculator, a to-do list, or a simple game
- Code reviews: Simple techniques for reviewing and improving your own code
Show chapter
Databases
The subject "Databases" provides a basic introduction to the concepts and applications of databases. It aims to provide participants with a sound understanding of the different types of databases, their benefits and the most commonly used database systems. Here are the main topics covered in this module:
What are databases?
A database is a structured collection of data. There are relational databases, which organize data into tables with relationships, and non-relational databases, which are more flexible and are often used for specific applications such as big data.
Why do you need databases?
Databases offer efficient data management, fast queries and increased data security. They are essential for applications such as customer databases, financial systems and warehouse management.
The most commonly used databases:
MySQL: Open source, widely used for web applications.
PostgreSQL: Advanced functions and SQL support.
Oracle Database: Highly scalable, for large companies.
Microsoft SQL Server: Integrated into the Windows environment.
MongoDB: NoSQL database for unstructured data.
SQLite: Lightweight, ideal for mobile applications.
This module provides a solid foundation for understanding and using databases.
What are databases?
A database is a structured collection of data. There are relational databases, which organize data into tables with relationships, and non-relational databases, which are more flexible and are often used for specific applications such as big data.
Why do you need databases?
Databases offer efficient data management, fast queries and increased data security. They are essential for applications such as customer databases, financial systems and warehouse management.
The most commonly used databases:
MySQL: Open source, widely used for web applications.
PostgreSQL: Advanced functions and SQL support.
Oracle Database: Highly scalable, for large companies.
Microsoft SQL Server: Integrated into the Windows environment.
MongoDB: NoSQL database for unstructured data.
SQLite: Lightweight, ideal for mobile applications.
This module provides a solid foundation for understanding and using databases.
- WHAT ARE DATABASES?
- Definition and basic concepts of databases
- Relational vs. non-relational databases
- WHY DO YOU NEED THEM?
- Advantages of using databases
- Examples of database applications
- THE MOST COMMONLY USED DATABASES
- Overview of the most commonly used databases
- Features and areas of application of the most popular database systems
Show chapter
Introduction to electronic data processing (EDP)
The subject "Introduction to electronic data processing (EDP)" teaches basic knowledge and the importance of data processing in various areas of life. Students learn about the historical development and practical applications.
Importance and necessity of data processing
Data processing is indispensable in almost all areas of modern life. It enables the efficient management and analysis of large amounts of data, improves decision-making and optimizes business processes. In today's digital world, the ability to process data is an essential prerequisite for success in many professions and industries.
History of data processing
The history of data processing goes back a long way, from the first mechanical calculating machines to modern computers. Important milestones include the invention of punch card machines, the development of the first computers in the 1940s and the rapid development of technology in the 20th and 21st centuries. This evolution has fundamentally changed the way we process and use data.
Examples from practice
Healthcare: Electronic patient records enable efficient management of patient data and improve the quality of medical care through quick access to relevant information.
Business: Companies use data processing to optimize business processes, customer management and for data-driven marketing strategies.
Science: In research, large amounts of data are analyzed in order to gain scientific knowledge and drive innovation, for example in genome research or climate modelling.
Importance and necessity of data processing
Data processing is indispensable in almost all areas of modern life. It enables the efficient management and analysis of large amounts of data, improves decision-making and optimizes business processes. In today's digital world, the ability to process data is an essential prerequisite for success in many professions and industries.
History of data processing
The history of data processing goes back a long way, from the first mechanical calculating machines to modern computers. Important milestones include the invention of punch card machines, the development of the first computers in the 1940s and the rapid development of technology in the 20th and 21st centuries. This evolution has fundamentally changed the way we process and use data.
Examples from practice
Healthcare: Electronic patient records enable efficient management of patient data and improve the quality of medical care through quick access to relevant information.
Business: Companies use data processing to optimize business processes, customer management and for data-driven marketing strategies.
Science: In research, large amounts of data are analyzed in order to gain scientific knowledge and drive innovation, for example in genome research or climate modelling.
- IMPORTANCE AND NECESSITY OF DATA PROCESSING IN VARIOUS AREAS OF LIFE
- Relevance of data processing in everyday life
- Areas of application of IT in various sectors
- Advantages of IT in modern society
- HISTORY OF DATA PROCESSING
- Development of data processing from its beginnings to the present day
- Milestones and important inventions in data processing
- Evolution of computer technology and its effects
- EXAMPLES FROM PRACTICE (E.G. HEALTHCARE, BUSINESS, SCIENCE)
- Application of EDP in the healthcare sector: Patient management, diagnostic support, research
- Use of IT in business: business processes, accounting, marketing analyses
- Role of IT in science: data analysis, simulations, scientific publications
Show chapter
Security IT competence
The subject "Security" provides basic knowledge in the areas of data protection, authentication and cyber security. It covers the following topics:
Data protection basics
Data protection basics
- Data protection basics: protection of personal data.
- Important laws and regulations: GDPR and its requirements.
- Measures to protect privacy: Techniques for securing privacy.
Authentication basics
- Definition and meaning: identity verification for security.
- Various methods: passwords, biometric procedures, multi-factor authentication.
- Best practices: Secure authentication systems.
Cyber Security & Hacking
- Basics: Protection against digital threats.
- Common threats: Phishing, malware, DDoS attacks.
- Security measures: Use of firewalls and antivirus software.
This module prepares participants for the secure handling of data and systems.
- DATA PROTECTION BASICS
- Basics of data protection
- Important laws and regulations (e.g. GDPR)
- Measures to protect privacy
- AUTHENTICATION BASICS
- Definition and importance of authentication
- Various authentication methods (passwords, biometric methods)
- Best practices for secure authentication
- CYBER SECURITY & HACKING
- Basics of cyber security
- Common threats and attacks (phishing, malware, DDoS)
- Measures to increase security (firewalls, antivirus software)
Show chapter
Software
The subject "Software" provides an overview of the different types of software, their availability on different devices, the production and distribution processes and the communication between software programs.
There are two main categories of software: system software, such as operating systems and drivers, and application software, such as word processing programs and games. Software is available on various devices, including desktop computers, mobile devices and embedded systems. There is both platform-independent software and platform-specific applications.
Software is produced using various development processes such as agile and the waterfall model. Version control and continuous integration/deployment (CI/CD) are crucial for efficient software development. Software can be distributed on-premises, cloud-based or as a mobile app.
Software communicates with each other via interfaces such as APIs and webhooks. These enable the integration of services and real-time notification between different applications.
This module comprehensively prepares participants to understand and use software in practice.
- WHAT TYPES OF SOFTWARE ARE THERE?
- System software vs. application software
- Examples of different software categories
- ON WHICH DEVICES IS IT AVAILABLE?
- Desktop, mobile devices, embedded systems
- Platform independence and platform-specific applications
- HOW IS SOFTWARE PRODUCED AND DISTRIBUTED?
- Development processes (agile, waterfall model)
- Version control and continuous integration/continuous deployment (CI/CD)
- Distribution of software (on-premises, cloud-based, mobile apps)
- HOW DOES SOFTWARE COMMUNICATE WITH SOFTWARE? (INTERFACES)
- Definition and types of interfaces (APIs, webhooks)
- Examples and applications of software communication
Show chapter
Tools
The subject "Tools" offers a comprehensive insight into the various tools and environments used for the development and use of modern software solutions. This includes basic development tools, the use of the command line, version control and an introduction to artificial intelligence (AI). This section is supplemented by knowledge checks and practical tasks.
Understanding the working environment
Students will be introduced to basic development tools, including text editors such as Visual Studio Code and Sublime Text, and integrated development environments (IDEs) such as PyCharm and Eclipse. They will learn the basic command line commands used for navigation and file management. In addition, you will receive an introduction to version control with Git and learn the basic commands for managing code versions.
Artificial intelligence
The basic concepts of artificial intelligence are explained, including definitions and different areas such as machine learning and neural networks. Participants will learn about use cases and examples of the application of AI in everyday life and discuss the benefits and challenges of AI technologies.
This module prepares participants to work effectively with modern development tools and to develop a fundamental understanding of artificial intelligence.
Understanding the working environment
Students will be introduced to basic development tools, including text editors such as Visual Studio Code and Sublime Text, and integrated development environments (IDEs) such as PyCharm and Eclipse. They will learn the basic command line commands used for navigation and file management. In addition, you will receive an introduction to version control with Git and learn the basic commands for managing code versions.
Artificial intelligence
The basic concepts of artificial intelligence are explained, including definitions and different areas such as machine learning and neural networks. Participants will learn about use cases and examples of the application of AI in everyday life and discuss the benefits and challenges of AI technologies.
This module prepares participants to work effectively with modern development tools and to develop a fundamental understanding of artificial intelligence.
- UNDERSTANDING THE WORKING ENVIRONMENT
- Simple development tools: Introduction to text editors (e.g. Visual Studio Code, Sublime Text) and IDEs (e.g. PyCharm, Eclipse)
- Command line/terminal: Basic commands for navigation and file management
- Versioning: Introduction to Git and basic commands for version control
- ARTIFICIAL INTELLIGENCE
- Definition and basic concepts of AI
- Different areas of AI (machine learning, neural networks)
- Use cases and examples of AI in everyday life
- Advantages and challenges of AI technologies
Show chapter
Module MySQL - Basics
Show all chapters of the subjects
Data analysis and aggregation
In this class, students will learn how to efficiently group and analyze data to gain valuable insights. The course begins with an introduction to the use of the `GROUP BY` clause in SQL, which makes it possible to group data according to certain criteria and thus present it more clearly.
Another important aspect of the subject is the various aggregate functions such as `COUNT`, `SUM`, `AVG` and others. These functions are used to calculate summarized values from data sets, which is essential for analyzing large amounts of data.
Students will also learn important MySQL functions that will help them create complex queries and perform detailed analysis. This includes the use of aliases to make queries clearer and easier to understand.
Another important aspect of the subject is the various aggregate functions such as `COUNT`, `SUM`, `AVG` and others. These functions are used to calculate summarized values from data sets, which is essential for analyzing large amounts of data.
Students will also learn important MySQL functions that will help them create complex queries and perform detailed analysis. This includes the use of aliases to make queries clearer and easier to understand.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Database management and tools
This class introduces students to the essential aspects of database administration and the use of helpful tools. The course begins with user account management, where students will learn how to create and manage user accounts to ensure a secure and organized database environment.
Another key point is the assignment of rights and authorizations. Here participants will learn how to control access to databases and their contents to ensure data security and integrity.
The subject also provides an introduction to phpMyAdmin, a widely used tool for managing MySQL databases via a web-based user interface. Students will learn the basic operations in phpMyAdmin, including creating and editing databases, tables and records, as well as backing up and restoring data.
Another key point is the assignment of rights and authorizations. Here participants will learn how to control access to databases and their contents to ensure data security and integrity.
The subject also provides an introduction to phpMyAdmin, a widely used tool for managing MySQL databases via a web-based user interface. Students will learn the basic operations in phpMyAdmin, including creating and editing databases, tables and records, as well as backing up and restoring data.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Data manipulation
In this subject, participants learn the basic techniques of data manipulation in databases. First, they will learn how to enter data using the INSERT statement to insert new records into tables.
In the next step, participants learn how to change existing data using the 'UPDATE' statement to update and correct database content.
Another important part of the subject is the deletion of data. Participants will learn how to use the `DELETE` statement to remove records from tables.
Finally, concepts for ensuring data integrity and the importance of transactions are taught. Participants will learn how to use transactions to perform database operations securely and consistently to ensure data integrity.
In the next step, participants learn how to change existing data using the 'UPDATE' statement to update and correct database content.
Another important part of the subject is the deletion of data. Participants will learn how to use the `DELETE` statement to remove records from tables.
Finally, concepts for ensuring data integrity and the importance of transactions are taught. Participants will learn how to use transactions to perform database operations securely and consistently to ensure data integrity.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Introduction to databases
In this subject, participants are given a basic introduction to the world of databases. First, we explain what a database is and what basic functions it fulfills. Students learn the differences between relational databases and other database types in order to develop an understanding of the various approaches and areas of application.
An important focus of the subject is the design and structure of databases. It explains how databases are organized and which components are crucial for their functionality.
An introduction to table structures is also given. Students will learn how tables function as the basic building blocks of databases and how they are used to store and organize data.
An important focus of the subject is the design and structure of databases. It explains how databases are organized and which components are crucial for their functionality.
An introduction to table structures is also given. Students will learn how tables function as the basic building blocks of databases and how they are used to store and organize data.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Create and query tables
In this subject, participants learn the basic and advanced techniques for creating and querying database tables. At the beginning, the focus is on creating tables. Participants will learn how to define and structure new tables in a database using the 'CREATE TABLE' statement.
The course then moves on to querying data. Participants will learn the basic `SELECT` statement, which can be used to retrieve data from tables. In addition, techniques for creating complex queries are taught in order to extract detailed and specific information from large data sets.
Another important part of the subject is the introduction to primary and foreign keys. Students will learn how to define primary keys to identify unique records in a table and how foreign keys are used to create and manage relationships between tables.
The course then moves on to querying data. Participants will learn the basic `SELECT` statement, which can be used to retrieve data from tables. In addition, techniques for creating complex queries are taught in order to extract detailed and specific information from large data sets.
Another important part of the subject is the introduction to primary and foreign keys. Students will learn how to define primary keys to identify unique records in a table and how foreign keys are used to create and manage relationships between tables.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Links and relationships
In this subject, students will learn how to set up and effectively use relationships between tables to manage complex data structures in relational databases. It begins by explaining how to create relationships between tables to link data in different tables and ensure consistent data organization.
A central part of the subject is the introduction to joins. Students will learn about the different types of joins used to combine data from multiple tables. This begins with an explanation of the basic concept of joins and their importance for data retrieval.
The course then covers specific join types in detail. Students will become familiar with the inner join and the left join to combine data in different ways and create queries that return only relevant records or include records that are missing from one of the tables.
In addition, the right join and full join are explained to further refine the data query and ensure that all relevant data can be included in the analysis, regardless of which table it is in.
A central part of the subject is the introduction to joins. Students will learn about the different types of joins used to combine data from multiple tables. This begins with an explanation of the basic concept of joins and their importance for data retrieval.
The course then covers specific join types in detail. Students will become familiar with the inner join and the left join to combine data in different ways and create queries that return only relevant records or include records that are missing from one of the tables.
In addition, the right join and full join are explained to further refine the data query and ensure that all relevant data can be included in the analysis, regardless of which table it is in.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Module MariaDB and MySQL Admin
Show all chapters of the subjects
Introduction and setup (MDB)
This class provides students with a basic introduction to MariaDB and MySQL, two widely used relational database management systems. Beginning with an overview of the features and benefits of these systems, system requirements and installation prerequisites, the course then covers the installation and basic configuration of MariaDB and MySQL on various platforms, including Windows, macOS and Linux. Participants will learn how to install these database management systems and make the necessary configuration settings to set up a stable and powerful database environment.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Performance and query profiling (MDB)
In this class, students will learn the techniques of query profiling and performance tuning to maximize the efficiency and speed of SQL queries. The course begins with an introduction to query profiling, where students will learn how to use the EXPLAIN tool to analyze SQL queries and understand their execution plans.
Another focus is on the optimization of SQL queries. Participants will receive practical tips and strategies to make queries more efficient and improve the performance of their databases. In addition, methods for monitoring database performance are presented in order to identify and resolve bottlenecks and performance problems at an early stage.
Another focus is on the optimization of SQL queries. Participants will receive practical tips and strategies to make queries more efficient and improve the performance of their databases. In addition, methods for monitoring database performance are presented in order to identify and resolve bottlenecks and performance problems at an early stage.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Recovery and high availability (MDB)
This subject introduces participants to advanced techniques for recovering data and ensuring the high availability of database systems. The course begins with the basics of point-in-time recovery. Students will learn how to set up and use binary log files to restore a database to a point in time. Best practices for performing a point-in-time recovery are also covered to ensure that data integrity is maintained and downtime is minimized.
Another key component of the subject is high availability. Participants are introduced to the concepts of high availability and learn about different replication methods, including master-slave and master-master replication. These methods make it possible to configure databases so that they remain available even in the event of outages or maintenance work.
It also provides an introduction to Galera Cluster, a technology that enables synchronous multi-master replication. Participants will learn how to implement load balancing and failover strategies to distribute the load across multiple servers and maximize the availability of database services.
Another key component of the subject is high availability. Participants are introduced to the concepts of high availability and learn about different replication methods, including master-slave and master-master replication. These methods make it possible to configure databases so that they remain available even in the event of outages or maintenance work.
It also provides an introduction to Galera Cluster, a technology that enables synchronous multi-master replication. Participants will learn how to implement load balancing and failover strategies to distribute the load across multiple servers and maximize the availability of database services.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Storage and backup
In this subject, participants learn the essential techniques for the efficient storage and backup of databases. The course begins with the basics of data storage, focusing on the management and optimization of tables and databases. Students will learn how to organize databases to maximize performance and minimize storage requirements. Important concepts such as data compression and partitioning are also covered in order to improve the efficiency of data storage.
Another central component of the subject is the backup and restore of databases. Participants will be introduced to various backup strategies and learn how to create regular backups of their databases to prevent data loss. Practical methods for restoring databases from backups are presented in order to be able to react quickly and effectively in the event of data loss. The automation of backup and restore processes is also covered to make data backup a reliable and continuous process.
Another central component of the subject is the backup and restore of databases. Participants will be introduced to various backup strategies and learn how to create regular backups of their databases to prevent data loss. Practical methods for restoring databases from backups are presented in order to be able to react quickly and effectively in the event of data loss. The automation of backup and restore processes is also covered to make data backup a reliable and continuous process.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Storage engines and user administration
In this subject, participants will receive a comprehensive overview of different storage engines as well as the administration of user accounts and access controls in database systems.
The course begins with an introduction and comparison of the various storage engines, such as InnoDB and MyISAM. Participants will learn the advantages and disadvantages of each engine and how to choose the right storage engine for their specific requirements. In addition, techniques for managing and optimizing the selected storage engines are taught in order to maximize the performance and reliability of the databases.
Another central component of the subject is user and access control. Students will learn how to create and manage user accounts and assign permissions and roles to make access to databases secure and efficient. Important security aspects are also covered, including the configuration of remote access and the implementation of IP restrictions to prevent unauthorized access and increase database security.
The course begins with an introduction and comparison of the various storage engines, such as InnoDB and MyISAM. Participants will learn the advantages and disadvantages of each engine and how to choose the right storage engine for their specific requirements. In addition, techniques for managing and optimizing the selected storage engines are taught in order to maximize the performance and reliability of the databases.
Another central component of the subject is user and access control. Students will learn how to create and manage user accounts and assign permissions and roles to make access to databases secure and efficient. Important security aspects are also covered, including the configuration of remote access and the implementation of IP restrictions to prevent unauthorized access and increase database security.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Administration interfaces and SQL Basics (MDB)
In this subject, participants learn the basics of database administration and the basic SQL commands for manipulating and querying data.
The course begins with an introduction to various administration interfaces that make working with databases easier. Participants will get an overview of popular tools such as phpMyAdmin and MySQL Workbench. Both tools offer user-friendly interfaces for the administration of MySQL databases. In addition, other useful tools such as HeidiSQL and DBeaver are introduced, which also offer helpful functions for the administration and debugging of databases.
The second part of the course focuses on the basics of the SQL language. Participants will learn how to create and manage databases and tables. Basic SQL commands are taught, including querying, filtering, inserting, updating and deleting data. These basic skills are critical to working effectively with relational databases and performing complex data queries.
The course begins with an introduction to various administration interfaces that make working with databases easier. Participants will get an overview of popular tools such as phpMyAdmin and MySQL Workbench. Both tools offer user-friendly interfaces for the administration of MySQL databases. In addition, other useful tools such as HeidiSQL and DBeaver are introduced, which also offer helpful functions for the administration and debugging of databases.
The second part of the course focuses on the basics of the SQL language. Participants will learn how to create and manage databases and tables. Basic SQL commands are taught, including querying, filtering, inserting, updating and deleting data. These basic skills are critical to working effectively with relational databases and performing complex data queries.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Recognition of our IT training courses
Training certification
There are no uniformly standardized training paths in the field of IT training. However, this does not mean that the quality and recognition of our training programs are compromised. Our training institute is ISO 9001 certified and recognized. This certification confirms our commitment to the highest quality standards and continuous improvement.
Through our ISO 9001 certification, we ensure that our IT training programs - including our PHP programmer, web developer, programmer courses, and more - are developed and delivered according to international quality standards. You benefit from structured, practical curricula, experienced instructors and a high level of support during your training.
Institute certification
As a recognized institution in adult education, we subject our curricula to regular evaluations that are recognized by state authorities and funding bodies. Our ongoing goal is to exceed current quality standards and thus guarantee you first-class training. Convince yourself of our certifications.
Our certification gives you the certainty that you are receiving high-quality, recognized training that will optimally prepare you for your professional future.
Funding & educational leave - how it works
Can I get funding for my training?
At the Flexyfit EDV Academy, you have a wide range of options for funding your training. There are various funding programs at federal state and EU level as well as tax incentives that serve as a basis.
Please note, however, that the decision on the allocation and amount of funding is the sole responsibility of the respective funding body.
We will be happy to help you find a suitable funding body and provide you with all the course information you need to apply for funding. You must submit the application itself to the relevant funding body.
How does the funding work?
Depending on the funding institution, your training will be financed either through direct assumption of costs after confirmation of the funding application (e.g. AMS) or through full or partial reimbursement after successful completion of the training (e.g. Waff). We recommend that you contact the relevant funding institutions in person to find out about individual funding options.Can I take educational leave for the course?
Yes, the majority of our courses are suitable for educational leave.
If you would like to continue your education without terminating your employment, you can arrange educational leave with your employer. You will be released from work for the duration of the training.
Plan your educational leave with us now! We will be happy to clarify your individual training requirements with you in a personal, non-binding consultation .
How does educational leave work?
You can take your educational leave for a maximum of- Educational leave over a period of 12 months in one go
- split up, whereby each part must last at least
2 months . The parts must be taken within4 years . - Educational leave with part-time educational leave extending over
2 years
Please note that this is a general summary and it is advisable to check with the relevant bodies or authorities for further details and conditions.
Your employer's consent is essential for educational leave. You must submit the training plans issued by us, which require 20 hours per week for full-time educational leave or at least 10 hours per week for part-time educational leave.
It is also necessary to provide regular proof of the progress of your training, for example through examinations or attendance certificates issued by us.
Possibilities and areas of application with MariaDB & MySQL
MariaDB and MySQL are widely used database systems and are used in various areas such as web development, data management, business intelligence analysis, data engineering and management consulting. In web development, you implement database-supported websites or develop CMS platforms such as WordPress, Joomla or Drupal, which are based on MySQL databases. For mobile applications, you could provide backend databases or implement synchronization solutions.
Deepen and expand your skills with MariaDB and MySQ
MariaDB and MySQL are powerful relational database management systems that offer a wide range of applications. These database systems enable you to create and manage databases, develop dynamic web applications, perform complex data analyses and optimize database structures. You will learn how to manage user access rights and implement security measures, perform regular backups and efficiently back up and restore databases.After completing this course, you will be familiar with the most important MySQL and MariaDB commands and know when to use them. You will have mastered the essential tasks required to operate and monitor a MySQL database. You are familiar with the basics of MySQL performance tuning so that you can take your first steps independently in your working environment. You will be familiar with the common backup solutions, their advantages and disadvantages as well as the possibilities and limitations when restoring data.
The "MariaDB and MySQL Administrator" course offers you the opportunity to further develop your personal and professional skills and establish yourself in the IT industry.
Expert knowledge about databases
Expand your knowledge with MariaDB and MySQL!
With MariaDB and MySQL you are well equipped with all the essential aspects of database administration. The training prepares you perfectly for the exciting tasks as a database administrator, developer or system integrator. The training includes the basics of IT skills, MariaDB and MySQL basics .
What can you expect from our training?
The course "MariaDB and MySQL - the administration course" starts with a comprehensive introduction to IT competence, MariaDB and MySQL, including installation and configuration on different operating systems. You will be familiarized with tools such as phpMyAdmin and MySQL Workbench to help you manage your databases efficiently. You will learn the basic syntax and structure of how to create databases and tables, formulate queries and manipulate data.
You will also get to know the various storage engines such as InnoDB and MyISAM in order to choose the best solution for your requirements. Security is the focus when it comes to managing user accounts and permissions to control access to your databases.
You will learn how to effectively store, back up and restore your data, including methods for automating backups and minimizing downtime.
To optimize the performance of your databases through indexing, query optimization and configuration tuning. You will also learn how to set up your databases for high availability and scalability, including replication and clustering.
Conditions of participation
- Online or written registration
- Basic IT knowledge is recommended but not required
- Minimum age 18 years (for participants under 18 years, written parental consent is required for registration)
- Access to an internet-enabled device
- Access to a stable internet connection
Certificate of completion
Our certificates are valid worldwide and are issued in different versions. On request, you can receive our certificate in several languages (DE, EN, ES), with country-specific information and with or without printed grades.
All these variants are available to you free of charge for a lifetime for downloading from your online campus. In addition, depending on the learning package you have purchased, you will receive a certificate of your choice, which will be issued on special high-quality embossed paper.
The following certificate (in several languages DE, EN, ES) will be awarded:
"MariaDB and MySQL Administrator "
Do you have specific questions about the training?
We will be happy to help you by phone, e-mail or chat.
Procedure & duration - How your training is structured
The training consists of three modules
You can find the list of modules and subjects by clicking on the "Course content" tab.Duration of the course
As our training courses can be designed very flexibly, the duration of the training depends heavily on your own learning initiative, the amount of time you spend each week and your previous knowledge. Depending on how much time you can invest and how quickly you absorb the required knowledge, it is also possible to complete the training more quickly.Online live training via Zoom
The training is conducted live online via Zoom. The instructors teach in real time and share their screen so that you can follow the lessons from the comfort of your own home. You have access to all dates and the link to the live webinar via the Online Campus, so you can easily take part from home.You will receive the Zoom meeting link by e-mail before the start of the course and it will also be available on our Flexyfit learning platform. Please make sure that you have entered your current e-mail address when registering.
With online distance learning courses, you set the tone
Learn at your own pace, when and where you want. The Academy account accompanies you on your computer, tablet or smartphone and contains everything you need for the course.You decide how you learn
You can choose from a wide range of Full HD learning videos in which our top instructors teach you the training content. You can also read the content in our scripts and presentations.No pain, no gain
Along the way, you will work your way through a variety of compulsory and additional tasks. These include writing a simple program, carrying out a security analysis or using a cloud service. All tasks are explained in a step-by-step guide so that you can apply what you have learned in practice.Last but not least... Exams
You can expect lots of multiple choice online exams to test your knowledge. You can take a test exam before each exam to be optimally prepared.
Detailed Course Contents
Extent of learning
442 E | Volume
EDK
187
IT competence
PL
216
Presence | Self-study
RE
6
Literature research
TE
23
Practical realization
AE
10
Additional tasks & examinations
This training is suitable for educational leave. The individual review and approval is subject to the respective funding agency. For more detailed information on the duration and procedure of educational leave, please contact us directly! Book a consultation appointment now.
Participation in the face-to-face webinars is mandatory for educational leave and must be proven to the AMS. Confirmation of attendance must be requested on the participant's own responsibility. Confirmation of attendance of the face-to-face webinar will only be issued during each webinar if requested by the participant.
Module IT competence
Show all chapters of the subjects
Basic knowledge of EDP
The subject "Basic IT knowledge" teaches basic knowledge and concepts of electronic data processing. It offers a comprehensive introduction to the world of computer technology, operating systems, networks and much more.
A computer is an electronic device that is used to process data. It performs calculations, stores and processes information. There are different types of computers, including personal computers (PCs), servers and embedded systems. Each type has specific applications and functions.
An operating system manages the hardware and software resources of a computer. It enables the execution of applications and ensures communication between hardware and software. The best-known operating systems include Windows, macOS and Linux, although each operating system has its own characteristics and areas of application.
Code can be translated by either compilers or interpreters. Compilers convert the entire code into machine language, while interpreters execute the code line by line. The fetch-decode-execute cycle describes the process by which the processor fetches, decodes and executes instructions.
A process is a program that is being executed. The management of processes includes the allocation of resources and the monitoring of their execution. Multitasking enables the simultaneous execution of several processes, whereby process scheduling determines which processes are executed when and for how long.
Hardware is controlled by special software known as drivers. Drivers enable communication between the operating system and hardware components by forwarding specific commands and data.
This module provides a solid foundation in the basic principles of electronic data processing and prepares students to understand and apply more complex concepts in IT.
A computer is an electronic device that is used to process data. It performs calculations, stores and processes information. There are different types of computers, including personal computers (PCs), servers and embedded systems. Each type has specific applications and functions.
An operating system manages the hardware and software resources of a computer. It enables the execution of applications and ensures communication between hardware and software. The best-known operating systems include Windows, macOS and Linux, although each operating system has its own characteristics and areas of application.
Code can be translated by either compilers or interpreters. Compilers convert the entire code into machine language, while interpreters execute the code line by line. The fetch-decode-execute cycle describes the process by which the processor fetches, decodes and executes instructions.
A process is a program that is being executed. The management of processes includes the allocation of resources and the monitoring of their execution. Multitasking enables the simultaneous execution of several processes, whereby process scheduling determines which processes are executed when and for how long.
Hardware is controlled by special software known as drivers. Drivers enable communication between the operating system and hardware components by forwarding specific commands and data.
This module provides a solid foundation in the basic principles of electronic data processing and prepares students to understand and apply more complex concepts in IT.
- WHAT IS A CALCULATOR?
- Definition and basic concepts
- Different types of computers (PCs, servers, embedded systems)
- WHAT IS AN OPERATING SYSTEM?
- Tasks of an operating system
- Examples of common operating systems (Windows, macOS, Linux)
- HOW IS CODE EXECUTED?
- Translation and execution of code (compiler vs. interpreter)
- Sequence of code execution (fetch-decode-execute cycle)
- WHAT ARE PROCESSES?
- Definition and management of processes
- Multitasking and process scheduling
- HOW IS HARDWARE CONTROLLED?
- Basics of hardware control
- Drivers and their role in the system
- WHAT IS A PROGRAM?
- Definition of a program
- Differences between applications and system software
- NETWORK BASICS
- Basics of network technology
- Network protocols and architectures (TCP/IP, OSI model)
- WHAT IS A SERVER?
- Definition and tasks of a server
- Differences between server and client systems
- Examples and areas of application of servers
- WHAT IS THE CLOUD?
- Definition and basics of cloud technology
- Differences between public, private and hybrid cloud
- Advantages and challenges of using the cloud
- INTERNET OF THINGS (IOT)
- Definition and basics of the IoT
- Examples of IoT applications (smart homes, Industry 4.0)
- Challenges and future of the IoT
- SERVICES
- Definition and importance of IT services
- Different types of services (web services, microservices)
- Examples and areas of application of IT services
Show chapter
Coding
The subject "Coding " teaches basic and advanced concepts of programming and software development. It aims to provide participants with a sound understanding of the various programming languages, principles and techniques. In addition, what has been learned is consolidated through knowledge tests and practical tasks. Here are the main topics covered in this module:
Programming languages and how they work
Participants will learn the basic principles and concepts of programming languages. An overview of high-level and low-level programming languages will be given, with the differences between these types clearly highlighted. High-level languages such as Python and Java are compared to machine-oriented languages such as Assembly.
From Visual Programming to 0 and 1
This section covers the range of programming from visual programming languages to machine-oriented languages. Examples of visual programming languages, such as Scratch, and machine-oriented languages, such as Assembly, are presented. The different levels of programming and their applications are explained.
Fundamentals of programming
The basic concepts of programming are taught here. These include the syntax and semantics of programming languages, the declaration and use of variables and data types (such as integer, float, string, boolean), as well as the use of arithmetic, logical and comparison operators.
Design patterns
Design patterns are proven solution patterns for recurring problems in software development. Participants learn the definition and purpose of design patterns and are given examples of common patterns such as singleton, factory and observer. The application and advantages of design patterns in software development are also discussed.
Control structures
This section covers the basic control structures in programming, including conditions and branching with if, else and elif statements as well as loops such as for and while loops. The importance of loop control using break and continue is also explained.
Functions and modularity
Participants will learn how to define and call functions, including parameters, return values and code reusability. The basic principles of modularity and the division of code into manageable, reusable modules are also covered.
Basic data structures
This section provides a basic understanding of data structures such as lists, arrays, dictionaries, hashmaps, tuples and sets. Students will learn how to create, access and modify these structures.
Simple algorithms and problem solving
Participants are introduced to basic sorting algorithms such as bubble sort and selection sort. They will also learn about search algorithms such as linear and binary search. Systematic problem-solving strategies and debugging methods are discussed.
Object-oriented programming (OOP)
The basic principles of object-oriented programming are taught, including classes, objects, attributes and methods. Concepts such as inheritance, polymorphism and encapsulation are fundamentally explained and illustrated with simple examples.
Simple projects and practical applications
Participants put their knowledge into practice in small, practical projects, such as the development of a calculator, a to-do list or a simple game. Finally, simple techniques for checking and improving your own code through code reviews are covered.
Programming languages and how they work
Participants will learn the basic principles and concepts of programming languages. An overview of high-level and low-level programming languages will be given, with the differences between these types clearly highlighted. High-level languages such as Python and Java are compared to machine-oriented languages such as Assembly.
From Visual Programming to 0 and 1
This section covers the range of programming from visual programming languages to machine-oriented languages. Examples of visual programming languages, such as Scratch, and machine-oriented languages, such as Assembly, are presented. The different levels of programming and their applications are explained.
Fundamentals of programming
The basic concepts of programming are taught here. These include the syntax and semantics of programming languages, the declaration and use of variables and data types (such as integer, float, string, boolean), as well as the use of arithmetic, logical and comparison operators.
Design patterns
Design patterns are proven solution patterns for recurring problems in software development. Participants learn the definition and purpose of design patterns and are given examples of common patterns such as singleton, factory and observer. The application and advantages of design patterns in software development are also discussed.
Control structures
This section covers the basic control structures in programming, including conditions and branching with if, else and elif statements as well as loops such as for and while loops. The importance of loop control using break and continue is also explained.
Functions and modularity
Participants will learn how to define and call functions, including parameters, return values and code reusability. The basic principles of modularity and the division of code into manageable, reusable modules are also covered.
Basic data structures
This section provides a basic understanding of data structures such as lists, arrays, dictionaries, hashmaps, tuples and sets. Students will learn how to create, access and modify these structures.
Simple algorithms and problem solving
Participants are introduced to basic sorting algorithms such as bubble sort and selection sort. They will also learn about search algorithms such as linear and binary search. Systematic problem-solving strategies and debugging methods are discussed.
Object-oriented programming (OOP)
The basic principles of object-oriented programming are taught, including classes, objects, attributes and methods. Concepts such as inheritance, polymorphism and encapsulation are fundamentally explained and illustrated with simple examples.
Simple projects and practical applications
Participants put their knowledge into practice in small, practical projects, such as the development of a calculator, a to-do list or a simple game. Finally, simple techniques for checking and improving your own code through code reviews are covered.
- PROGRAMMING LANGUAGES / TYPES
- Principles and concepts of programming languages
- Differences between high-level and low-level languages
- HOW DO THEY WORK?
- From visual programming to 0 and 1 (machine-oriented languages)
- Different levels of programming
- Examples of visual and machine-oriented programming languages
- BASICS OF PROGRAMMING
- Syntax and semantics: explanation of syntax rules and the meaning of lines of code
- Variables and data types: Different data types (integer, float, string, boolean) and how to declare and use variables
- Operators: Arithmetic, logical and comparison operators
- DESIGN PATTERNS
- Definition and purpose of design patterns
- Examples of common design patterns (singleton, factory, observer)
- Application and advantages of design patterns in software development
- CONTROL STRUCTURES
- Conditions and branches: if, else, and elif statements
- Loops: for and while loops, as well as the meaning of loop control (break, continue)
- FUNCTIONS AND MODULARITY
- Definition and calling of functions: Parameters, return values and the importance of code reusability
- Basic principles of modularity: how to divide code into manageable, reusable modules
- BASIC DATA STRUCTURES
- Lists and arrays: Creating, accessing, and modifying elements
- Dictionaries and hashmaps: Basic understanding and application
- Tuples and sets: use and differences to lists and dictionaries
- SIMPLE ALGORITHMS AND PROBLEM SOLVING
- Sorting algorithms: Introduction to simple sorting methods such as bubble sort and selection sort
- Searching: Linear and binary searches
- Problem solving strategies: Approach methods for systematic problem solving and debugging
- OBJECT-ORIENTED PROGRAMMING (OOP)
- Basic principles of OOP: classes, objects, attributes, methods
- Concepts such as inheritance, polymorphism and encapsulation: basic explanations and simple examples
- SIMPLE PROJECTS AND PRACTICAL APPLICATIONS
- Small projects: Practice-oriented exercises such as a calculator, a to-do list, or a simple game
- Code reviews: Simple techniques for reviewing and improving your own code
Show chapter
Databases
The subject "Databases" provides a basic introduction to the concepts and applications of databases. It aims to provide participants with a sound understanding of the different types of databases, their benefits and the most commonly used database systems. Here are the main topics covered in this module:
What are databases?
A database is a structured collection of data. There are relational databases, which organize data into tables with relationships, and non-relational databases, which are more flexible and are often used for specific applications such as big data.
Why do you need databases?
Databases offer efficient data management, fast queries and increased data security. They are essential for applications such as customer databases, financial systems and warehouse management.
The most commonly used databases:
MySQL: Open source, widely used for web applications.
PostgreSQL: Advanced functions and SQL support.
Oracle Database: Highly scalable, for large companies.
Microsoft SQL Server: Integrated into the Windows environment.
MongoDB: NoSQL database for unstructured data.
SQLite: Lightweight, ideal for mobile applications.
This module provides a solid foundation for understanding and using databases.
What are databases?
A database is a structured collection of data. There are relational databases, which organize data into tables with relationships, and non-relational databases, which are more flexible and are often used for specific applications such as big data.
Why do you need databases?
Databases offer efficient data management, fast queries and increased data security. They are essential for applications such as customer databases, financial systems and warehouse management.
The most commonly used databases:
MySQL: Open source, widely used for web applications.
PostgreSQL: Advanced functions and SQL support.
Oracle Database: Highly scalable, for large companies.
Microsoft SQL Server: Integrated into the Windows environment.
MongoDB: NoSQL database for unstructured data.
SQLite: Lightweight, ideal for mobile applications.
This module provides a solid foundation for understanding and using databases.
- WHAT ARE DATABASES?
- Definition and basic concepts of databases
- Relational vs. non-relational databases
- WHY DO YOU NEED THEM?
- Advantages of using databases
- Examples of database applications
- THE MOST COMMONLY USED DATABASES
- Overview of the most commonly used databases
- Features and areas of application of the most popular database systems
Show chapter
Introduction to electronic data processing (EDP)
The subject "Introduction to electronic data processing (EDP)" teaches basic knowledge and the importance of data processing in various areas of life. Students learn about the historical development and practical applications.
Importance and necessity of data processing
Data processing is indispensable in almost all areas of modern life. It enables the efficient management and analysis of large amounts of data, improves decision-making and optimizes business processes. In today's digital world, the ability to process data is an essential prerequisite for success in many professions and industries.
History of data processing
The history of data processing goes back a long way, from the first mechanical calculating machines to modern computers. Important milestones include the invention of punch card machines, the development of the first computers in the 1940s and the rapid development of technology in the 20th and 21st centuries. This evolution has fundamentally changed the way we process and use data.
Examples from practice
Healthcare: Electronic patient records enable efficient management of patient data and improve the quality of medical care through quick access to relevant information.
Business: Companies use data processing to optimize business processes, customer management and for data-driven marketing strategies.
Science: In research, large amounts of data are analyzed in order to gain scientific knowledge and drive innovation, for example in genome research or climate modelling.
Importance and necessity of data processing
Data processing is indispensable in almost all areas of modern life. It enables the efficient management and analysis of large amounts of data, improves decision-making and optimizes business processes. In today's digital world, the ability to process data is an essential prerequisite for success in many professions and industries.
History of data processing
The history of data processing goes back a long way, from the first mechanical calculating machines to modern computers. Important milestones include the invention of punch card machines, the development of the first computers in the 1940s and the rapid development of technology in the 20th and 21st centuries. This evolution has fundamentally changed the way we process and use data.
Examples from practice
Healthcare: Electronic patient records enable efficient management of patient data and improve the quality of medical care through quick access to relevant information.
Business: Companies use data processing to optimize business processes, customer management and for data-driven marketing strategies.
Science: In research, large amounts of data are analyzed in order to gain scientific knowledge and drive innovation, for example in genome research or climate modelling.
- IMPORTANCE AND NECESSITY OF DATA PROCESSING IN VARIOUS AREAS OF LIFE
- Relevance of data processing in everyday life
- Areas of application of IT in various sectors
- Advantages of IT in modern society
- HISTORY OF DATA PROCESSING
- Development of data processing from its beginnings to the present day
- Milestones and important inventions in data processing
- Evolution of computer technology and its effects
- EXAMPLES FROM PRACTICE (E.G. HEALTHCARE, BUSINESS, SCIENCE)
- Application of EDP in the healthcare sector: Patient management, diagnostic support, research
- Use of IT in business: business processes, accounting, marketing analyses
- Role of IT in science: data analysis, simulations, scientific publications
Show chapter
Security IT competence
The subject "Security" provides basic knowledge in the areas of data protection, authentication and cyber security. It covers the following topics:
Data protection basics
Data protection basics
- Data protection basics: protection of personal data.
- Important laws and regulations: GDPR and its requirements.
- Measures to protect privacy: Techniques for securing privacy.
Authentication basics
- Definition and meaning: identity verification for security.
- Various methods: passwords, biometric procedures, multi-factor authentication.
- Best practices: Secure authentication systems.
Cyber Security & Hacking
- Basics: Protection against digital threats.
- Common threats: Phishing, malware, DDoS attacks.
- Security measures: Use of firewalls and antivirus software.
This module prepares participants for the secure handling of data and systems.
- DATA PROTECTION BASICS
- Basics of data protection
- Important laws and regulations (e.g. GDPR)
- Measures to protect privacy
- AUTHENTICATION BASICS
- Definition and importance of authentication
- Various authentication methods (passwords, biometric methods)
- Best practices for secure authentication
- CYBER SECURITY & HACKING
- Basics of cyber security
- Common threats and attacks (phishing, malware, DDoS)
- Measures to increase security (firewalls, antivirus software)
Show chapter
Software
The subject "Software" provides an overview of the different types of software, their availability on different devices, the production and distribution processes and the communication between software programs.
There are two main categories of software: system software, such as operating systems and drivers, and application software, such as word processing programs and games. Software is available on various devices, including desktop computers, mobile devices and embedded systems. There is both platform-independent software and platform-specific applications.
Software is produced using various development processes such as agile and the waterfall model. Version control and continuous integration/deployment (CI/CD) are crucial for efficient software development. Software can be distributed on-premises, cloud-based or as a mobile app.
Software communicates with each other via interfaces such as APIs and webhooks. These enable the integration of services and real-time notification between different applications.
This module comprehensively prepares participants to understand and use software in practice.
- WHAT TYPES OF SOFTWARE ARE THERE?
- System software vs. application software
- Examples of different software categories
- ON WHICH DEVICES IS IT AVAILABLE?
- Desktop, mobile devices, embedded systems
- Platform independence and platform-specific applications
- HOW IS SOFTWARE PRODUCED AND DISTRIBUTED?
- Development processes (agile, waterfall model)
- Version control and continuous integration/continuous deployment (CI/CD)
- Distribution of software (on-premises, cloud-based, mobile apps)
- HOW DOES SOFTWARE COMMUNICATE WITH SOFTWARE? (INTERFACES)
- Definition and types of interfaces (APIs, webhooks)
- Examples and applications of software communication
Show chapter
Tools
The subject "Tools" offers a comprehensive insight into the various tools and environments used for the development and use of modern software solutions. This includes basic development tools, the use of the command line, version control and an introduction to artificial intelligence (AI). This section is supplemented by knowledge checks and practical tasks.
Understanding the working environment
Students will be introduced to basic development tools, including text editors such as Visual Studio Code and Sublime Text, and integrated development environments (IDEs) such as PyCharm and Eclipse. They will learn the basic command line commands used for navigation and file management. In addition, you will receive an introduction to version control with Git and learn the basic commands for managing code versions.
Artificial intelligence
The basic concepts of artificial intelligence are explained, including definitions and different areas such as machine learning and neural networks. Participants will learn about use cases and examples of the application of AI in everyday life and discuss the benefits and challenges of AI technologies.
This module prepares participants to work effectively with modern development tools and to develop a fundamental understanding of artificial intelligence.
Understanding the working environment
Students will be introduced to basic development tools, including text editors such as Visual Studio Code and Sublime Text, and integrated development environments (IDEs) such as PyCharm and Eclipse. They will learn the basic command line commands used for navigation and file management. In addition, you will receive an introduction to version control with Git and learn the basic commands for managing code versions.
Artificial intelligence
The basic concepts of artificial intelligence are explained, including definitions and different areas such as machine learning and neural networks. Participants will learn about use cases and examples of the application of AI in everyday life and discuss the benefits and challenges of AI technologies.
This module prepares participants to work effectively with modern development tools and to develop a fundamental understanding of artificial intelligence.
- UNDERSTANDING THE WORKING ENVIRONMENT
- Simple development tools: Introduction to text editors (e.g. Visual Studio Code, Sublime Text) and IDEs (e.g. PyCharm, Eclipse)
- Command line/terminal: Basic commands for navigation and file management
- Versioning: Introduction to Git and basic commands for version control
- ARTIFICIAL INTELLIGENCE
- Definition and basic concepts of AI
- Different areas of AI (machine learning, neural networks)
- Use cases and examples of AI in everyday life
- Advantages and challenges of AI technologies
Show chapter
Module MySQL - Basics
Show all chapters of the subjects
Data analysis and aggregation
In this class, students will learn how to efficiently group and analyze data to gain valuable insights. The course begins with an introduction to the use of the `GROUP BY` clause in SQL, which makes it possible to group data according to certain criteria and thus present it more clearly.
Another important aspect of the subject is the various aggregate functions such as `COUNT`, `SUM`, `AVG` and others. These functions are used to calculate summarized values from data sets, which is essential for analyzing large amounts of data.
Students will also learn important MySQL functions that will help them create complex queries and perform detailed analysis. This includes the use of aliases to make queries clearer and easier to understand.
Another important aspect of the subject is the various aggregate functions such as `COUNT`, `SUM`, `AVG` and others. These functions are used to calculate summarized values from data sets, which is essential for analyzing large amounts of data.
Students will also learn important MySQL functions that will help them create complex queries and perform detailed analysis. This includes the use of aliases to make queries clearer and easier to understand.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Database management and tools
This class introduces students to the essential aspects of database administration and the use of helpful tools. The course begins with user account management, where students will learn how to create and manage user accounts to ensure a secure and organized database environment.
Another key point is the assignment of rights and authorizations. Here participants will learn how to control access to databases and their contents to ensure data security and integrity.
The subject also provides an introduction to phpMyAdmin, a widely used tool for managing MySQL databases via a web-based user interface. Students will learn the basic operations in phpMyAdmin, including creating and editing databases, tables and records, as well as backing up and restoring data.
Another key point is the assignment of rights and authorizations. Here participants will learn how to control access to databases and their contents to ensure data security and integrity.
The subject also provides an introduction to phpMyAdmin, a widely used tool for managing MySQL databases via a web-based user interface. Students will learn the basic operations in phpMyAdmin, including creating and editing databases, tables and records, as well as backing up and restoring data.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Data manipulation
In this subject, participants learn the basic techniques of data manipulation in databases. First, they will learn how to enter data using the INSERT statement to insert new records into tables.
In the next step, participants learn how to change existing data using the 'UPDATE' statement to update and correct database content.
Another important part of the subject is the deletion of data. Participants will learn how to use the `DELETE` statement to remove records from tables.
Finally, concepts for ensuring data integrity and the importance of transactions are taught. Participants will learn how to use transactions to perform database operations securely and consistently to ensure data integrity.
In the next step, participants learn how to change existing data using the 'UPDATE' statement to update and correct database content.
Another important part of the subject is the deletion of data. Participants will learn how to use the `DELETE` statement to remove records from tables.
Finally, concepts for ensuring data integrity and the importance of transactions are taught. Participants will learn how to use transactions to perform database operations securely and consistently to ensure data integrity.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Introduction to databases
In this subject, participants are given a basic introduction to the world of databases. First, we explain what a database is and what basic functions it fulfills. Students learn the differences between relational databases and other database types in order to develop an understanding of the various approaches and areas of application.
An important focus of the subject is the design and structure of databases. It explains how databases are organized and which components are crucial for their functionality.
An introduction to table structures is also given. Students will learn how tables function as the basic building blocks of databases and how they are used to store and organize data.
An important focus of the subject is the design and structure of databases. It explains how databases are organized and which components are crucial for their functionality.
An introduction to table structures is also given. Students will learn how tables function as the basic building blocks of databases and how they are used to store and organize data.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Create and query tables
In this subject, participants learn the basic and advanced techniques for creating and querying database tables. At the beginning, the focus is on creating tables. Participants will learn how to define and structure new tables in a database using the 'CREATE TABLE' statement.
The course then moves on to querying data. Participants will learn the basic `SELECT` statement, which can be used to retrieve data from tables. In addition, techniques for creating complex queries are taught in order to extract detailed and specific information from large data sets.
Another important part of the subject is the introduction to primary and foreign keys. Students will learn how to define primary keys to identify unique records in a table and how foreign keys are used to create and manage relationships between tables.
The course then moves on to querying data. Participants will learn the basic `SELECT` statement, which can be used to retrieve data from tables. In addition, techniques for creating complex queries are taught in order to extract detailed and specific information from large data sets.
Another important part of the subject is the introduction to primary and foreign keys. Students will learn how to define primary keys to identify unique records in a table and how foreign keys are used to create and manage relationships between tables.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Links and relationships
In this subject, students will learn how to set up and effectively use relationships between tables to manage complex data structures in relational databases. It begins by explaining how to create relationships between tables to link data in different tables and ensure consistent data organization.
A central part of the subject is the introduction to joins. Students will learn about the different types of joins used to combine data from multiple tables. This begins with an explanation of the basic concept of joins and their importance for data retrieval.
The course then covers specific join types in detail. Students will become familiar with the inner join and the left join to combine data in different ways and create queries that return only relevant records or include records that are missing from one of the tables.
In addition, the right join and full join are explained to further refine the data query and ensure that all relevant data can be included in the analysis, regardless of which table it is in.
A central part of the subject is the introduction to joins. Students will learn about the different types of joins used to combine data from multiple tables. This begins with an explanation of the basic concept of joins and their importance for data retrieval.
The course then covers specific join types in detail. Students will become familiar with the inner join and the left join to combine data in different ways and create queries that return only relevant records or include records that are missing from one of the tables.
In addition, the right join and full join are explained to further refine the data query and ensure that all relevant data can be included in the analysis, regardless of which table it is in.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Module MariaDB and MySQL Admin
Show all chapters of the subjects
Introduction and setup (MDB)
This class provides students with a basic introduction to MariaDB and MySQL, two widely used relational database management systems. Beginning with an overview of the features and benefits of these systems, system requirements and installation prerequisites, the course then covers the installation and basic configuration of MariaDB and MySQL on various platforms, including Windows, macOS and Linux. Participants will learn how to install these database management systems and make the necessary configuration settings to set up a stable and powerful database environment.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Performance and query profiling (MDB)
In this class, students will learn the techniques of query profiling and performance tuning to maximize the efficiency and speed of SQL queries. The course begins with an introduction to query profiling, where students will learn how to use the EXPLAIN tool to analyze SQL queries and understand their execution plans.
Another focus is on the optimization of SQL queries. Participants will receive practical tips and strategies to make queries more efficient and improve the performance of their databases. In addition, methods for monitoring database performance are presented in order to identify and resolve bottlenecks and performance problems at an early stage.
Another focus is on the optimization of SQL queries. Participants will receive practical tips and strategies to make queries more efficient and improve the performance of their databases. In addition, methods for monitoring database performance are presented in order to identify and resolve bottlenecks and performance problems at an early stage.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Recovery and high availability (MDB)
This subject introduces participants to advanced techniques for recovering data and ensuring the high availability of database systems. The course begins with the basics of point-in-time recovery. Students will learn how to set up and use binary log files to restore a database to a point in time. Best practices for performing a point-in-time recovery are also covered to ensure that data integrity is maintained and downtime is minimized.
Another key component of the subject is high availability. Participants are introduced to the concepts of high availability and learn about different replication methods, including master-slave and master-master replication. These methods make it possible to configure databases so that they remain available even in the event of outages or maintenance work.
It also provides an introduction to Galera Cluster, a technology that enables synchronous multi-master replication. Participants will learn how to implement load balancing and failover strategies to distribute the load across multiple servers and maximize the availability of database services.
Another key component of the subject is high availability. Participants are introduced to the concepts of high availability and learn about different replication methods, including master-slave and master-master replication. These methods make it possible to configure databases so that they remain available even in the event of outages or maintenance work.
It also provides an introduction to Galera Cluster, a technology that enables synchronous multi-master replication. Participants will learn how to implement load balancing and failover strategies to distribute the load across multiple servers and maximize the availability of database services.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Storage and backup
In this subject, participants learn the essential techniques for the efficient storage and backup of databases. The course begins with the basics of data storage, focusing on the management and optimization of tables and databases. Students will learn how to organize databases to maximize performance and minimize storage requirements. Important concepts such as data compression and partitioning are also covered in order to improve the efficiency of data storage.
Another central component of the subject is the backup and restore of databases. Participants will be introduced to various backup strategies and learn how to create regular backups of their databases to prevent data loss. Practical methods for restoring databases from backups are presented in order to be able to react quickly and effectively in the event of data loss. The automation of backup and restore processes is also covered to make data backup a reliable and continuous process.
Another central component of the subject is the backup and restore of databases. Participants will be introduced to various backup strategies and learn how to create regular backups of their databases to prevent data loss. Practical methods for restoring databases from backups are presented in order to be able to react quickly and effectively in the event of data loss. The automation of backup and restore processes is also covered to make data backup a reliable and continuous process.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Storage engines and user administration
In this subject, participants will receive a comprehensive overview of different storage engines as well as the administration of user accounts and access controls in database systems.
The course begins with an introduction and comparison of the various storage engines, such as InnoDB and MyISAM. Participants will learn the advantages and disadvantages of each engine and how to choose the right storage engine for their specific requirements. In addition, techniques for managing and optimizing the selected storage engines are taught in order to maximize the performance and reliability of the databases.
Another central component of the subject is user and access control. Students will learn how to create and manage user accounts and assign permissions and roles to make access to databases secure and efficient. Important security aspects are also covered, including the configuration of remote access and the implementation of IP restrictions to prevent unauthorized access and increase database security.
The course begins with an introduction and comparison of the various storage engines, such as InnoDB and MyISAM. Participants will learn the advantages and disadvantages of each engine and how to choose the right storage engine for their specific requirements. In addition, techniques for managing and optimizing the selected storage engines are taught in order to maximize the performance and reliability of the databases.
Another central component of the subject is user and access control. Students will learn how to create and manage user accounts and assign permissions and roles to make access to databases secure and efficient. Important security aspects are also covered, including the configuration of remote access and the implementation of IP restrictions to prevent unauthorized access and increase database security.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Administration interfaces and SQL Basics (MDB)
In this subject, participants learn the basics of database administration and the basic SQL commands for manipulating and querying data.
The course begins with an introduction to various administration interfaces that make working with databases easier. Participants will get an overview of popular tools such as phpMyAdmin and MySQL Workbench. Both tools offer user-friendly interfaces for the administration of MySQL databases. In addition, other useful tools such as HeidiSQL and DBeaver are introduced, which also offer helpful functions for the administration and debugging of databases.
The second part of the course focuses on the basics of the SQL language. Participants will learn how to create and manage databases and tables. Basic SQL commands are taught, including querying, filtering, inserting, updating and deleting data. These basic skills are critical to working effectively with relational databases and performing complex data queries.
The course begins with an introduction to various administration interfaces that make working with databases easier. Participants will get an overview of popular tools such as phpMyAdmin and MySQL Workbench. Both tools offer user-friendly interfaces for the administration of MySQL databases. In addition, other useful tools such as HeidiSQL and DBeaver are introduced, which also offer helpful functions for the administration and debugging of databases.
The second part of the course focuses on the basics of the SQL language. Participants will learn how to create and manage databases and tables. Basic SQL commands are taught, including querying, filtering, inserting, updating and deleting data. These basic skills are critical to working effectively with relational databases and performing complex data queries.
- The detailed chapters on the subject will be available here shortly!
Show chapter
Recognition of our IT training courses
Training certification
There are no uniformly standardized training paths in the field of IT training. However, this does not mean that the quality and recognition of our training programs are compromised. Our training institute is ISO 9001 certified and recognized. This certification confirms our commitment to the highest quality standards and continuous improvement.
Through our ISO 9001 certification, we ensure that our IT training programs - including our PHP programmer, web developer, programmer courses, and more - are developed and delivered according to international quality standards. You benefit from structured, practical curricula, experienced instructors and a high level of support during your training.
Institute certification
As a recognized institution in adult education, we subject our curricula to regular evaluations that are recognized by state authorities and funding bodies. Our ongoing goal is to exceed current quality standards and thus guarantee you first-class training. Convince yourself of our certifications.
Our certification gives you the certainty that you are receiving high-quality, recognized training that will optimally prepare you for your professional future.
Funding & educational leave - how it works
Can I get funding for my training?
At the Flexyfit EDV Academy, you have a wide range of options for funding your training. There are various funding programs at federal state and EU level as well as tax incentives that serve as a basis.
Please note, however, that the decision on the allocation and amount of funding is the sole responsibility of the respective funding body.
We will be happy to help you find a suitable funding body and provide you with all the course information you need to apply for funding. You must submit the application itself to the relevant funding body.
How does the funding work?
Depending on the funding institution, your training will be financed either through direct assumption of costs after confirmation of the funding application (e.g. AMS) or through full or partial reimbursement after successful completion of the training (e.g. Waff). We recommend that you contact the relevant funding institutions in person to find out about individual funding options.Can I take educational leave for the course?
Yes, the majority of our courses are suitable for educational leave.
If you would like to continue your education without terminating your employment, you can arrange educational leave with your employer. You will be released from work for the duration of the training.
Plan your educational leave with us now! We will be happy to clarify your individual training requirements with you in a personal, non-binding consultation .
How does educational leave work?
You can take your educational leave for a maximum of- Educational leave over a period of 12 months in one go
- split up, whereby each part must last at least
2 months . The parts must be taken within4 years . - Educational leave with part-time educational leave extending over
2 years
Please note that this is a general summary and it is advisable to check with the relevant bodies or authorities for further details and conditions.
Your employer's consent is essential for educational leave. You must submit the training plans issued by us, which require 20 hours per week for full-time educational leave or at least 10 hours per week for part-time educational leave.
It is also necessary to provide regular proof of the progress of your training, for example through examinations or attendance certificates issued by us.
Possibilities and areas of application with MariaDB & MySQL
MariaDB and MySQL are widely used database systems and are used in various areas such as web development, data management, business intelligence analysis, data engineering and management consulting. In web development, you implement database-supported websites or develop CMS platforms such as WordPress, Joomla or Drupal, which are based on MySQL databases. For mobile applications, you could provide backend databases or implement synchronization solutions.
Deepen and expand your skills with MariaDB and MySQ
MariaDB and MySQL are powerful relational database management systems that offer a wide range of applications. These database systems enable you to create and manage databases, develop dynamic web applications, perform complex data analyses and optimize database structures. You will learn how to manage user access rights and implement security measures, perform regular backups and efficiently back up and restore databases.After completing this course, you will be familiar with the most important MySQL and MariaDB commands and know when to use them. You will have mastered the essential tasks required to operate and monitor a MySQL database. You are familiar with the basics of MySQL performance tuning so that you can take your first steps independently in your working environment. You will be familiar with the common backup solutions, their advantages and disadvantages as well as the possibilities and limitations when restoring data.
The "MariaDB and MySQL Administrator" course offers you the opportunity to further develop your personal and professional skills and establish yourself in the IT industry.
Available course variations
MariaDB and MySQL Administrator
Highlights
Language of Instruction
Course Module
IT competence (presence)
IT competence (online)
EDP competence Full HD learning videos
Learning Type / Learning Method
Course Modality
Study Method
Auditory & Visual Learning Style
Communicative & Kinesthetic Learning Style
Study Timeframe
Study Support (# all-inclusive)
Text & Presentation PDFs
Lectures Bookable as Classroom Units
Support via Online Campus, E-mail, Chat, Tel.
WhatsApp & On-site Support
Test/Dummy Exam
Exam/Completion
EDK Intermediate Examination Online
Final Exam
Certificate in DE, EN or ES
Certificate accepted worldwide & never expires
Academy Account (# all-inclusive)
Lifetime Access to Online Campus
Free Demo Account / Trial Package
Certificate Copy as Downloadable PDF
Certificate with Verification via QR-Code
Financial Aid
Financial Aid/Grant Opportunities
Paid Educational Leave (AT)
Grants for Businesses
Grants for Self-Employed Persons
Course Advising
Cost Estimate for Financial Aid Provider
Benefits
Job Openings Mailing List
Comprehensive Training Opportunities
Absolute Best Price & Service Offer
EN
Classroom course Webinar
Presence
communicative
suitable
recommended
Flexible
Flexible date
up to 100%
non-binding
Basic information on the learning variants:
- The training content is the same for each learning variant
- The examination period, duration of training and examination procedure are independent of the learning variant
- Sie können von der Lernvariante "Fernstudium" auf Präsenz unterricht aufbuchen. Auch einzelne Modulblöcke sind aufbuchbar
- With the "face-to-face course" learning option, you can book and complete individual blocks in private lessons
- The final certificate does not differ, regardless of which learning variant you have completed the course in
- Your Academy account and the learning content will stay with you for the rest of your life
vor 2 Tagen
Auf Vollzeit-Berufstätige wird besonders Rücksicht genommen. Die Aufbereitung der Lernunterlagen (in der Kombination Buchform, Folien und Videos) ist großartig.
Ein wirklich tolles Team, sympathische und professionelle Vortragende, insgesamt ein top Ausbildungsinstitut, das ich jedem nur sehr weiterempfehlen kann. ⭐️⭐️⭐️⭐️⭐️
vor 6 Tagen
Einfach ein Top Team !
vor 15 Tagen
Interessanter und sehr umfangreicher Kursplan, kompetente Betreuung, sehr nettes Team, ganz einfach TOP und jederzeit gerne wieder.
18.11.2023
Schnelle Antwort auf alle Fragen.
11.11.2023
Schnelle Beratung, Top Service
07.11.2023
Sehr gute Unterstützung durch dem Personal, sowohl telefonisch als auch per Mail. Besonderen Dank an Sarah
17.10.2023
Ganz tolles Angebot und Service... jederzeit gerne wieder.
12.10.2023
Nett,
07.10.2023
Schnelle unkomplizierte Anmeldung. Ratenzahlung perfekt und man kann sich das lerntempo selbst anpassen
01.10.2023
Sportkompetenz + Fitnesstrainer B-Lizenz sind ein sehr umfangreicher Kurs, in dem jede Menge Wissen vermittelt wird, welches dem aktuellen wissenschaftlichen Stand entspricht. Man bekommt einen Gegenwert für sein Geld. Der Schwerpunkt liegt auf dem Maschinentraining. Neben bekannten Übungen, werden auch interessante Spezialübungen gezeigt. Was ich etwas vermisst habe sind klassische Hantelübungen (z.B. Kurzhantelüberzüge, Kreuzhebevarianten, Kniebeugen, Bankdrücken, Stirndrücken, SZ-Bizepscurls,... usw.), welche meiner Meinung nach insbesondere für Anfänger etwas besser geeignet sind als einige der gezeigten Kabelzugübungen. Was leider ebenfalls zu kurz kommt, sind Übungen für die Bauchmuskulatur. Hier bitte nachbessern.
Auf Nachrichten wird sehr schnell reagiert. Für das Fachgespräch habe ich innerhalb von 24 Stunden einen Termin bekommen. Ich werde auf jeden Fall weitere Kurse machen. Alles in allem kann ich den Kurs sehr empfehlen.
22.06.2023
Alles 👍
10.05.2023
Alles ist gut vorbereitet, die Kurse, die Mitarbeiter, perfekt.
10.05.2023
Die begleitung in eure Welt war sehr klar und deutig. Die mitarbeitarin hat mich von anfang an begleitet mit telefonate wo sie an alle meine fragen ein antwort gefunden hat. Und auch bei umstellund des Gutschein kauf haben mich die mitarbeiter sofort geholfen
25.04.2023
Aufbau, Unterlagen und Videos sind top, wenn man etwas benötigt reagieren sie schnell.
15.04.2023
Super Team, kompetent, geduldig und immer freundlich
07.04.2023
Kompetente Auskunft, gute Organisation super Kursangebot
01.04.2023
Tolle Academy
10.03.2023
Klasse Ausbildung, qualifiziertes Personal, guter Service
07.03.2023
Die Module sind sehr lehrreich gestaltet. Zudem sind die Videos sehr gut dargestellt und verständlich.
05.03.2023
Vielseitiges Kurs- und Ausbildungsangebot in dem auch verschiedene Richtungen kombiniert werden. Ganz toll!
Rating
Zoe Alina
2 weeks ago
Very well organized team, uncomplicated operation of online lessons, versatile informative script :) All in all top!
[+]
posted on
Susi Sorglos
2 weeks ago
I am very impressed with Flexyfit, always nice and helpful people. Very sympathetic. Thank you very much for your great support.
[+]
posted on
Anna Kober
3 weeks ago
Great training and super nice people. You can tell how much emphasis is placed on conveying the necessary knowledge to the course participants in an understandable way. I was even kindly allowed to take a course completely free of charge after there were somewhat problematic and disruptive participants in my group. I will 100% take more courses with you in the future because learning is extremely fun, especially thanks to the friendly staff!
[+]
posted on
Brigitte Moser
3 weeks ago
The entire flexyfit team is extremely friendly, prompt and helpful. The lecturers are competent and respond to the course participants. All learning materials were provided clearly and in sufficient detail. The additional videos mean there is something for every type of learner. All in all, the training and exam went well. I can definitely recommend flexyfit and will be happy to book and recommend further training courses with you again!
[+]