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
MySQL - Basics
starting at €1.290,- | face-to-face course
» Our Course Packages
Flexible learning - our possible learning options for the course:
Course Fee: from €
1.290,-
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
MySQL - Basics: Your entry into the world of databases
Learn the basic skills for working with MySQL, one of the most popular relational database systems. Our MySQL Fundamentals course is designed for beginners who want to develop a solid understanding of the SQL query language and how to use it in MySQL databases.
This course is ideal for beginners with no prior programming knowledge who are looking to pursue a career in database development or administration. IT professionals and software developers who wish to expand their knowledge of database administration will also benefit from this course. The course is particularly suitable for analytical and structured individuals who want to develop the ability to manage and analyze large amounts of data efficiently.
MySQL is a widely used and powerful database solution that is used in many companies and projects. A sound knowledge of MySQL will open up numerous career opportunities in the IT industry. Start your journey into the database world with our"MySQL - Basics" course and lay the foundations for your career as a database professional.
This course is ideal for beginners with no prior programming knowledge who are looking to pursue a career in database development or administration. IT professionals and software developers who wish to expand their knowledge of database administration will also benefit from this course. The course is particularly suitable for analytical and structured individuals who want to develop the ability to manage and analyze large amounts of data efficiently.
MySQL is a widely used and powerful database solution that is used in many companies and projects. A sound knowledge of MySQL will open up numerous career opportunities in the IT industry. Start your journey into the database world with our"MySQL - Basics" course and lay the foundations for your career as a database professional.
Factsheet on the course
Extent of learning
356 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
MySQL - Basics -
Half-day weekend course
| 18-01-2025 | starting at 1.290,-
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!
MySQL - Basics
Your entry into the world of databases: MySQL basics course
Introduction to databases
Our practice-oriented training ensures that you not only acquire theoretical knowledge, but can also apply it through practical exercises and examples. This prepares you optimally for the professional requirements in database development, database design and database administration.
What can you expect from the course?
In the course you will receive an introduction to SQL and learn the basic SQL syntax and semantics. You will be familiarized with basic SQL commands such as SELECT, INSERT, UPDATE and DELETE . We also teach you about database structures, including the structure and management of tables and the linking of multiple tables using JOINs.
Another focus of the course is on data manipulation. You will learn how to insert, change and delete data efficiently and how to filter and sort data using WHERE and ORDER BY. Practical exercises in which you perform SQL queries on a practice database will help you to consolidate what you have learned and gain practical experience.
This course is ideal for beginners with no prior programming knowledge who are looking to pursue a career in database development or administration. IT professionals and software developers who want to expand their knowledge of database administration will also benefit from this course. The course is particularly suitable for analytical and structured individuals who want to develop the ability to manage and analyze large amounts of data efficiently.
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, with country-specific information and with or without printed grades.
All of 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 will be awarded:
"MySQL - Basics"
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 two 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
356 E | Volume
EDK
187
IT competence
PL
144
Presence | Self-study
RE
4
Literature research
TE
15
Practical realization
AE
6
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
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.
Areas of application and possibilities with MySQL
MySQL is a widely used relational database system that is used for managing and organizing data in various applications. With MySQL you can perform a variety of tasks in different areas of database administration and development.
In the area of data management , MySQL allows you to create and manage databases and tables, insert, update and delete data as well as query and filter data using SQL commands. In web development, MySQL is often used in combination with programming languages such as PHP, Python or Java to create dynamic web applications and manage user data, sessions and other important information.
For data analysis , MySQL provides the ability to perform complex queries to analyze data and create reports, as well as aggregate and calculate data to support business decisions. In the area of database design and optimization, you can design and implement efficient database structures, normalize databases to avoid data redundancy and improve data integrity, and optimize queries and indexes to increase database performance.
Backup and restore are also important aspects of working with MySQL, as you can perform regular backups to secure databases and restore them in the event of data loss or corruption. In user management and security, you can manage user access rights and implement security measures to protect sensitive data from unauthorized access.
In addition, MySQL can be integrated with various other systems and tools to exchange and synchronize data and is often used as a backend database for various applications, from content management systems (CMS) to e-commerce platforms.
With MySQL, you have the ability to create powerful and flexible database solutions that support a wide range of applications
Your entry into the world of databases: MySQL basics course
Introduction to databases
Our practice-oriented training ensures that you not only acquire theoretical knowledge, but can also apply it through practical exercises and examples. This prepares you optimally for the professional requirements in database development, database design and database administration.
What can you expect from the course?
In the course you will receive an introduction to SQL and learn the basic SQL syntax and semantics. You will be familiarized with basic SQL commands such as SELECT, INSERT, UPDATE and DELETE . We also teach you about database structures, including the structure and management of tables and the linking of multiple tables using JOINs.
Another focus of the course is on data manipulation. You will learn how to insert, change and delete data efficiently and how to filter and sort data using WHERE and ORDER BY. Practical exercises in which you perform SQL queries on a practice database will help you to consolidate what you have learned and gain practical experience.
This course is ideal for beginners with no prior programming knowledge who are looking to pursue a career in database development or administration. IT professionals and software developers who want to expand their knowledge of database administration will also benefit from this course. The course is particularly suitable for analytical and structured individuals who want to develop the ability to manage and analyze large amounts of data efficiently.
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, with country-specific information and with or without printed grades.
All of 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 will be awarded:
"MySQL - Basics"
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 two 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
356 E | Volume
EDK
187
IT competence
PL
144
Presence | Self-study
RE
4
Literature research
TE
15
Practical realization
AE
6
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
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.
Areas of application and possibilities with MySQL
MySQL is a widely used relational database system that is used for managing and organizing data in various applications. With MySQL you can perform a variety of tasks in different areas of database administration and development.
In the area of data management , MySQL allows you to create and manage databases and tables, insert, update and delete data as well as query and filter data using SQL commands. In web development, MySQL is often used in combination with programming languages such as PHP, Python or Java to create dynamic web applications and manage user data, sessions and other important information.
For data analysis , MySQL provides the ability to perform complex queries to analyze data and create reports, as well as aggregate and calculate data to support business decisions. In the area of database design and optimization, you can design and implement efficient database structures, normalize databases to avoid data redundancy and improve data integrity, and optimize queries and indexes to increase database performance.
Backup and restore are also important aspects of working with MySQL, as you can perform regular backups to secure databases and restore them in the event of data loss or corruption. In user management and security, you can manage user access rights and implement security measures to protect sensitive data from unauthorized access.
In addition, MySQL can be integrated with various other systems and tools to exchange and synchronize data and is often used as a backend database for various applications, from content management systems (CMS) to e-commerce platforms.
With MySQL, you have the ability to create powerful and flexible database solutions that support a wide range of applications
Available course variations
MySQL - Basics
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!
[+]
posted on
safa alj
a months ago
A great team - competent, friendly, always helpful and supportive - provided excellent support for the practical training. We recommend! :)
[+]
posted on
Dr. Michael Kohlberger, BSc MSc
a months ago
Great support and extensive course content. We recommend!
[+]
posted on
Florian Reining
a months ago
I really enjoyed training to become a B-license fitness trainer there. The teaching materials provided are great and flawless. I learned a lot of new things there and always enjoyed what I was doing. The team is great and is always there for you if you have any questions!
[+]
posted on
Hrvoje Stilin (Stilintrhasher)
a month ago
The best thing that could have happened to me is this academy. Access to participants is excellent. All employees are very competent, very professional and very friendly. A person can learn so much that it is indescribably good. I would recommend it to everyone. When I arrived in Austria I was looking for something like this and luckily I found this academy and signed up for the course without hesitation. Everything we get in return is worth 100 times more than what we pay. Indescribable experience, indescribable people, once again and 1000 times I say: Thank you for everything, thank you for this indescribable experience. THANK YOU, THANK YOU, THANK YOU
[+]
posted on
Magdalena Bartosch
a months ago